Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with populating a combo box on a userform
Hi All
i have a combo box on a userform that i populate on the form initialization event ... using the following code dim rng as range set rng = Sheets("LookupContainer").Range("ContainerNo") for each cell in rng if cell.offset(0,-1).value = "" and cell.offset(0,1).value = "" then userform3.cboContainer.additem cell.value end if next --- however when i open the userform from another userform no containers are shown in the combo box .. if i close (cancel) and reopen it again they are - i'm only talking about 6 records here (from about 9) ... any ideas - is there a better way to do it? (Using excel 2000) thanks JulieD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating data on userform | Excel Programming | |||
Populating a userform 3 col listbox | Excel Programming | |||
Populating Sheet Data From A UserForm Combo Box Enabled For Multi-Choices | Excel Programming | |||
Populating a VBA UserForm | Excel Programming | |||
Populating Textbox in UserForm | Excel Programming |