Call a macro from within an Excel worksheet 2

[MrMajik]

I have a worksheet that has 200 cells that I want to test what the user enters without having the user to click a button or do some other action. The cells need to have real numbers only, no text.

I thought about calling a macro to test the contents of cells when one of the cells loses the focus but I don't know if this can be done in Excel.

Any ideas on how to test the content of a cell after the user exits the cell?

Thank you.

 

[xlbo]

No need for any code (although you would typically use the worksheet CHANGE event for this kind of thing)
Just use data>Validation and set it to allow Whole Number or Decimal (pick from the list in the validation dialogue box)

Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[SBendBuckeye]

Open the VB Project editor and double click ThisWorkbook. Do whatever you need to do with the SheetChange event.

Good Luck!

 

[SBendBuckeye]

Geoff's way is better, sorry I didn't read your post closely enough.

 

[MrMajik]

Geoff; Thanks. Works like a charm and just what I was in search of! Here's a star