Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox population question
I am trying to populate multible comboboxes from different sheets and cannot
figure out how to do it with the from initialize event. Heres my code. Please help. Private Sub UserForm_Initialize() CbxMfg.List = Worksheets("MANCODE").Range("A2:A1000").Value CboFire.List = Worksheets("Lists").Range("D2:D5").Value CboHealth.List = Worksheets("Lists").Range("D2:D5").Value CboReact.List = Worksheets("Lists").Range("D2:D5").Value CboDisp.List = Worksheets("Lists").Range("E2:E4").Value CboDept.List = Worksheets("Lists").Range("C2:C10").Value End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox population question
Hi,
Following examples should help. (Edit for your ranges). CbxMfg.RowSource = Worksheets("MANCODE") _ .Range("A1:A26").Address(external:=True) CboFire.RowSource = Worksheets("Lists") _ .Range("B1:B26").Address(external:=True) Regards, OssieMac "Mekinnik" wrote: I am trying to populate multible comboboxes from different sheets and cannot figure out how to do it with the from initialize event. Heres my code. Please help. Private Sub UserForm_Initialize() CbxMfg.List = Worksheets("MANCODE").Range("A2:A1000").Value CboFire.List = Worksheets("Lists").Range("D2:D5").Value CboHealth.List = Worksheets("Lists").Range("D2:D5").Value CboReact.List = Worksheets("Lists").Range("D2:D5").Value CboDisp.List = Worksheets("Lists").Range("E2:E4").Value CboDept.List = Worksheets("Lists").Range("C2:C10").Value End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox Population | Excel Programming | |||
combobox population | Excel Programming | |||
Combobox Population | Excel Programming | |||
ComboBox Population of Cell Range | Excel Programming | |||
Userform text & combobox population help required please | Excel Programming |