message box in an excel cell

[IronMan]

Hi,
I have several worksheets which will record XYZ data. One cell has to contain a 'ABC'. I want a Message box to appear when a worksheet is opened and this cell is blank, instructing the user to enter a value, and then when the sheet is opened again with a value in this cell no message box appears.
Any suggestions.

[IronMan]

Sorry, I forgot to mention that I am using Office 2003.

[BurgoEng]

Hi,
Try this code.

sub worksheet_open

if application.activesheet.cells(5,2) ="" then
application.activesheet.cells(5,2).select
msgbox ("Please enter value in B5")
end if
end sub

Cheers!

[IronMan]

Hi BurgoEng,
Thanks a lot for your timely advice. You saved me lot of time.
Regards.

[MattJM]

Hi,
I need to examine an Excel model but get #ref! but I do not know why? Since I am unable to examine the model. Any suggestions would be great.

[Spark92]

Correct a #REF! error

Occurs when a cell reference (cell reference: The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.) is not valid.

Click the cell that displays the error, click the button that appears , and then click Trace Error if it appears.


-------------------------------------------

That is what Microsoft Excel Help provides. Check the formula for errors.

[microbing0]

Hi!

I'm trying to create a spreadsheet with a drop-down menu and I would like to add color choices with the drop-down menu options.

For example, for Choice A, the color would be blue. For Choice B, the color would be red, etc.

Does anyone know how to create this? I've ran across a few articles, however, it states that macro's and programming code's are needed. I'm definently not a macro or programming specialist.!.!

Any help is appreciated! Thanks!!

[BurgoEng]

Hi,
#REF! indicates a broken link - this can be caused when a cell or sheet that a formula is referring to is deleted, or it can be caused by linking to a cell that has a broken link.
Cheers!

[AlpineMan]

I am trying to get rid of leading spaces. I copied three colums of text from an Outlook email message, brought it into Excel, did Text to Columns, and am left with a varying number of leading spaces prior to the text in column C. The text could start with any letter. I have tried TRIM and CLEAN with no change. If I select a cell in column C, I can backspace from the start of the text to remove the spaces.

[Help-Desk]

Did you say that you stripped ALL formatting from the text that you copied? There are several free apps that sit in your quick launch bar that strip the contents of the active clipboard of all formatting tags (i.e., left with ASCII text).

One is called "Puretext". I've attached it here in a zip file.