Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox default datatype
I have a series of 5 listboxes on a form and the values (single select
from these listboxes are used in various calculations in the app. Unfortunately, when I open the the workbook and the form loads, I don' want anything selected and since the initialize event also runs th change events of the listbox (which contains a function wit calculations based on the selected item), I get an invalid use of nul error. I've now found out that whilst some of the non selected listboxes ar returning an empty string (i.e. "") one or two of them (and it isn' consistent which one or two) are returning Null as their value. I hav found a way round this by duplicating the Access function Nz() t handle Null values but I was wondering if there was any way of settin the default datatype of a listbox? I.e. can I set my listboxes t always return Strings? Any help or comments are appreciated. Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help- SUB: DATATYPE FOR A CELL.. | Excel Programming | |||
DataType Conversion | Excel Programming | |||
Listbox default | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Default value in Listbox | Excel Programming |