| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox value
Hello,
How can you describe a blank value in a listbox. Such as if the user did not choose a value. I started the following code and the value is not working correctly. Thank You If listbox.Value Is Null Then MsgBox ("Please make a selection") Else End If |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Listbox value
The ListIndex property of the list box will be -1 if no selection
has been made. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "tjh" wrote in message ... Hello, How can you describe a blank value in a listbox. Such as if the user did not choose a value. I started the following code and the value is not working correctly. Thank You If listbox.Value Is Null Then MsgBox ("Please make a selection") Else End If |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
| Modification of listbox to listbox code | Excel Programming | |||
| Multicolumn Listbox and ordinary listbox | Excel Programming | |||
| listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
| Is refreshing listbox rowsource in listbox click event possible? | Excel Programming | |||
Linear Mode
