| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Allow only numeric data in certain cells & only text strings in others
Any VBA code suggestion how to allow only numeric input in certain cell & text string input in other cells of a particular worksheet other tha using onentry. I need the VBA code to be in the sheet change cod 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. mikebur -- mikebur ----------------------------------------------------------------------- mikeburg's Profile: http://www.excelforum.com/member.php...fo&userid=2458 View this thread: http://www.excelforum.com/showthread.php?threadid=47181 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
| Identifying cells without certain text strings | Excel Worksheet Functions | |||
| Replacing characters in numeric text strings and SUMming | Excel Discussion (Misc queries) | |||
| How to skip cells with text strings. | Excel Discussion (Misc queries) | |||
| Converting variable text strings to numeric | Excel Discussion (Misc queries) | |||
![mikeburg[_33_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
