Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a hard time with listbox
Sometimes you just get lost in the code. I have a worksheet, now rounding
about 900k in size (sad thing is it only contains 3 pages of visual reference material and no graphics). In it I have several list boxes that manipulate the data that I have stored in them using the additem method. I can easily get the data of a selected item, but now I find myself needing to know if an item is in the list box from within the VBA code. Should I ... A.) Create an array and search the array for the item. B.) Use a function from within the VBA designed for this perpose and I am not aware of C.) Go to the local pub and think about getting a brain transplant Thanks for any input that is positive... Thurman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox 2 takes the value of Listbox 1 | Excel Discussion (Misc queries) | |||
listbox B conditional of input in Listbox A | Excel Discussion (Misc queries) | |||
Listbox B if LIstbox A equals | Excel Discussion (Misc queries) | |||
Can I save to hard drive AND my flash drive at the same time? | Excel Discussion (Misc queries) | |||
Sorting ListBox results or transposing ListBox values to other cells for sorting | Excel Programming |