combobox population question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with code issues 5
Help with applying code 5
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
2 comboboxs, different sheet references 2
error message on populating combobox 10
CONCATENATE code 2
open file and update data? 3
Complie error 2

Back
Top