Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a combo box on form inilialization
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
populating a combo box on form inilialization
How are you opening the userfrom from another userform are you callin
it? or userformname.show? do they each have population lists? where ar the lists located? with a little more information you may get the help you need. Simo -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |