Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating combobox from another combobox
Hello
I've created, with help, a combobox that lists the sheets in a workbook. I now want a second combobox to be populated from the contents of a specific range from the sheet chosen in combobox 1. ie combobox1 = company names (held in sheet) combobox2 = above company - employee names held in range(A2:A30) Again any help is greatly appreciated. Thanks David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating combobox from another combobox
use the click event of the first combobox
Private Sub Combobox1_Click() Dim sName as String if Combobox1.ListIndex < -1 then sName = Combobox1.Value Combobox2.RowSource = sName & "!A2:A30" End if End sub -- Regards, Tom Ogilvy "David Goodall" wrote in message ... Hello I've created, with help, a combobox that lists the sheets in a workbook. I now want a second combobox to be populated from the contents of a specific range from the sheet chosen in combobox 1. ie combobox1 = company names (held in sheet) combobox2 = above company - employee names held in range(A2:A30) Again any help is greatly appreciated. Thanks David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating combobox/listbox | Excel Programming | |||
Populating ComboBox Methods | Excel Programming | |||
Populating Combobox Methods | Excel Programming | |||
Populating sheet names in combobox | Excel Programming | |||
populating a combobox on a worksheet | Excel Programming |