| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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  5").ValueCboHealth.List = Worksheets("Lists").Range("D2 5").ValueCboReact.List = Worksheets("Lists").Range("D2 5").ValueCboDisp.List = Worksheets("Lists").Range("E2:E4").Value CboDept.List = Worksheets("Lists").Range("C2:C10").Value End Sub |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
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 5").Value> CboHealth.List = Worksheets("Lists").Range("D2 5").Value> CboReact.List = Worksheets("Lists").Range("D2 5").Value> CboDisp.List = Worksheets("Lists").Range("E2:E4").Value > CboDept.List = Worksheets("Lists").Range("C2:C10").Value > End Sub |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| ComboBox Population | =?Utf-8?B?UGhpbGlw?= | Microsoft Excel Programming | 1 | 19th Nov 2005 02:05 PM |
| combobox population | dirt | Microsoft Excel Programming | 0 | 22nd Dec 2004 03:16 PM |
| Problem in ComboBox Population | =?Utf-8?B?R2FuZXNo?= | Microsoft Access Forms | 1 | 15th Jun 2004 02:58 AM |
| Combobox Population | stck2mlon | Microsoft Excel Programming | 4 | 3rd Jun 2004 12:37 PM |
| Problems with combobox population | Alessandro | Microsoft Dot NET Compact Framework | 2 | 9th Oct 2003 04:18 PM |
