LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 470
Default Verifying that data exist

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Verifying uniqueness of records in data arad Excel Discussion (Misc queries) 4 June 25th 07 05:50 PM
Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist [email protected] Excel Programming 4 June 18th 06 06:08 PM
Command Line. How to tell to XL : If the xls file exist : Open it, if it does not exist : Create it. Tintin92 Excel Programming 3 March 11th 06 06:45 PM
verifying data type benb Excel Programming 1 December 8th 04 07:50 PM
Verifying all data in each row is filled in John[_86_] Excel Programming 1 June 9th 04 11:45 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"