| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Needed for to check data input
I have
D4-D10 E4-E10 F4-F10 G4-G10 H4-H10 I4-I10 J4-J10 The user will input a number but can only be 0-9. How can I make it so that they can only enter numbers and only 0-9? I will need to have it for all of the cells listed above. Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code Needed for to check data input
Hi Albert,
Try using Excel's Data V alidation tool Select all the cells of interest Menu | Data | Data Validation | Allow: Whole number Data: Between 0 | 9 If you need to apply tthe validation from VBA, turn on the macro recorder to obtain the required syntax. --- Regards. Norman "Albert Mulder" wrote in message ... I have D4-D10 E4-E10 F4-F10 G4-G10 H4-H10 I4-I10 J4-J10 The user will input a number but can only be 0-9. How can I make it so that they can only enter numbers and only 0-9? I will need to have it for all of the cells listed above. Thank you |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Code Needed for to check data input
That worked thank you.
"Norman Jones" wrote: Hi Albert, Try using Excel's Data V alidation tool Select all the cells of interest Menu | Data | Data Validation | Allow: Whole number Data: Between 0 | 9 If you need to apply tthe validation from VBA, turn on the macro recorder to obtain the required syntax. --- Regards. Norman "Albert Mulder" wrote in message ... I have D4-D10 E4-E10 F4-F10 G4-G10 H4-H10 I4-I10 J4-J10 The user will input a number but can only be 0-9. How can I make it so that they can only enter numbers and only 0-9? I will need to have it for all of the cells listed above. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code to have User input data for cell | Excel Discussion (Misc queries) | |||
| Input box data check | Excel Discussion (Misc queries) | |||
| Check Input, into Input box question | Excel Programming | |||
| Pause code, wait for input, no input received, carry on with the code | Excel Programming | |||
Linear Mode
