Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
using Excel 2000 i have one userform with a combo box that i populate on initalization with the following code dim rng as range set rng = Sheets("LookupContainer").Range("ContainerDB") for each cell in rng if cell.offset(0,-1) = "" AND cell.offset(0,1) = "" then userform3.cbocontainers.additem cell.value end if next .... however, when i open the userform (from another userform) the list isn't shown on the drop down of the combo box. If i close & reopen the form it is - any ideas? PS currently i'm talking about 6 records only. Cheers JulieD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating a list/combo box with an Access column. | Excel Discussion (Misc queries) | |||
Populating other cells with combo box selection | Excel Programming | |||
Populating combo boxes | Excel Programming | |||
Populating combo box with a function | Excel Programming | |||
Populating Combo Boxes | Excel Programming |