Displaying a Message Box in Excel 1

[Lil8]

Hi,

I am wandering whether it is possible to enter a formula into a cell that checks for a certian criteria and then display a message Box on the screen

IF(C5 = "",MsgBox "Please enter data in Cell C5&quot

instead of validating the cell by going to Data and selecting Validation the normal way.

Nic

 

[xlbo]

Nope - no formula / function within a worksheet can affect ANYTHING other than the cell it is in

The only way to do this would be by using a worksheet EVENT

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244