Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wanted to create a routine to make sure the user not only entered something
in the textbox of the userform, but that the answer is a valid answer. The routine below is for checking to be sure something was entered. However, it does not seem to work. Any suggestions? Private Sub txtST_Exit(ByVal Cancel As MSForms.ReturnBoolean) If txtST = "" Then txtST.SetFocus End If End Sub Now for the second part. The field, txtST, will contain a value from 1 to 8. I would actually like to have a listbox for this field so the user can choose and I do not have to verify if input is correct. How do I do this? Thanks, Les |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Verifying uniqueness of records in data | Excel Discussion (Misc queries) | |||
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist | Excel Programming | |||
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it. | Excel Programming | |||
verifying data type | Excel Programming | |||
Verifying all data in each row is filled in | Excel Programming |