Why not use Data - Validation?
--
HTH...

Jim Thomlinson


"mikeburg" wrote:


Any VBA code suggestion how to allow only numeric input in certain cells
& text string input in other cells of a particular worksheet other than
using onentry. I need the VBA code to be in the sheet change code
since other sheets exists in the same workbook.

For example:

Only allow numeric entries in cells F4 thru O5
Only allow text strings entries in cells F6 thru O6
Only allow numeric entries in cells F7 thru O7
Only allow text strings entries in cells F8 thru O8
Only allow numeric entries in cells F9 thru O9
Only allow text strings entries in cells F10 thru O10
etc.

Thanks so very much. mikeburg


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=471819