Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a list box and a command button on a userform. When the command
button is clicked I want to test to ensure the user has selected only 1 item in the listbox. I have this but it doesn't work and I don't know why, any ideas? ' ensure a part number is selected to edit If lbxPreview.Value = Null Then MsgBox "Please select a Part Number from the list to edit.", vbCritical Exit Sub End If -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
Why null reference to ListBox? | Excel Programming | |||
Null, "null", vbNull, vbNullString, vbEmpty | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |