problem with populating a combo box on a userform

J

JulieD

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
 
Top