Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi.
I have a couple of textboxes on a vb form. For these, I need the value entered to be sure to be numeric. What's the best way to check for that? application.isnumber(txtBox.value) returns false... becauese it thinks its text. the Val(txtBox.value) function does some checking, but it will tell you that Val(5a) = 5, etc. I think one time I did some checking on the len of Val(), as compared to the original len of the entry, but that probably has holes too. Please point me toward the simple way. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checking range of cells for entry then checking for total | Excel Programming | |||
Format Numeric data in Textbox | Excel Worksheet Functions | |||
checking input on a textbox in userform to be a % | Excel Programming | |||
Ensuring UserForm Textbox Entry is numeric | Excel Programming | |||
Use numeric data from a textbox on an userform | Excel Programming |