problem with populating a combo box on a userform
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 |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com