| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Integer only textbox?
Can I set a textbox (on a form) to accept only integer values? If so
how? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Integer only textbox?
Create an _AfterUpdate() routine for your text box and then check if
its an integer in your code. wrote: Can I set a textbox (on a form) to accept only integer values? If so how? TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Integer only textbox?
Okay, I was afraid it wouldn't be as simple as a property value.
Thank you. ImpulseBlue wrote: Create an _AfterUpdate() routine for your text box and then check if its an integer in your code. wrote: Can I set a textbox (on a form) to accept only integer values? If so how? TIA |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Integer only textbox?
If the tool must use a userform then you are stuck with setting up
events for it, but if you had the input in a cell on a worksheet then you could use simple Data Validation and set it to only whole numbers.... just some thoughts wrote: Okay, I was afraid it wouldn't be as simple as a property value. Thank you. ImpulseBlue wrote: Create an _AfterUpdate() routine for your text box and then check if its an integer in your code. wrote: Can I set a textbox (on a form) to accept only integer values? If so how? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add an integer to an existing integer? | Excel Worksheet Functions | |||
| Highlight all Text in a Textbox when the textbox is selected | Excel Programming | |||
| HELP! I Lost The Ability To Advance From TextBox To TextBox With the ENTER Or The TAB Keys | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
| Textbox Bug? Missing/delayed update of textbox filled via VBA | Excel Programming | |||
Linear Mode
