populating a combo box on form inilialization

J

JulieD

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
 
S

Simon Lloyd

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
 
Top