| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is the array empty?
Excel 2002, WinXP
I display a UserForm with a Listbox (set to multi-select) and ask the user to select the names he wishes. I then use the procedure that John Walkenbach has in his book to build an array of the selected names. All works well if the user selects at least one name. There is a real possibility that the user will select no names, in which case the array will contain no names. I need to trap that situation. How can I trap the fact that no names were selected or that the array has no members? Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| in excel..:can't empty clip are" but already empty | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| Is Array Empty | Boolean Answer | Excel Programming | |||
| Differentiate between "" and Empty in array elements. | Excel Programming | |||
| Can blank cells created using empty Double-Quotes not be empty?? | Excel Programming | |||
![Otto Moehrbach[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
