Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi there,
I have a userform with a listbox. I need to verify that the user has selected an item from this listbox, and if not have a message appear to tell them to do so. I've written the following code: 'check for a Month/Year If Me.ListBox2.Value = "" Then msg = "Please enter Valid Date" MsgBox msg UserForm1.ListBox2.SetFocus Exit Sub End If This code will work on a Textbox, but not a listbox. Any help would be greatly appreciated! JJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Data Validation (Listbox) | Excel Worksheet Functions | |||
Finding window handle of data validation listbox | Excel Programming | |||
Userform: listbox and controls' data entry validation | Excel Programming | |||
Data Validation Listbox problem | Excel Programming | |||
Change event for data validation listbox | Excel Programming |