| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
accept fractions from textbox
I cannot enter fractions in a TextBox and have them recognised as numbers.
If IsNumeric(UserForm1.TextBox2.Value) = False Then 'Quantity MsgBox "Choose NUMERIC quantity. Transaction cancelled!", , "Company Name" End If I am having trouble getting this to work in Excel 2007; Vista whereas works Excel 2003 XP. Is there a better way or is it a machine setting problem rather than Excel (eg Universal Date settings etc) Thanks B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How2 accept only numbers in userform textbox | 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 | |||
| How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Threaded Mode
