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

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