Synchronize Combo Boxes?

J

Jen

Is there a way to synchronize 2 combo boxes in Excel? I.e., limit the values
in the 2nd box depending on what was selected in the first? I do this often
in Access but don't work much in Excel.

The first combo box is based on a list of major codes found on a separate
sheet. The second box is based on a list of sub-categories listed on a third
sheet, which shows each major code and the sub-categories appropriate for it.
All three sheets are in the same workbook.

How can I do this?

Thanks,
Jen
 
J

Jim Cone

Possibly...
http://support.microsoft.com/?kbid=213748
"How to Populate One List Box Based on Another List Box"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Jen"
wrote in message
Is there a way to synchronize 2 combo boxes in Excel? I.e., limit the values
in the 2nd box depending on what was selected in the first? I do this often
in Access but don't work much in Excel.

The first combo box is based on a list of major codes found on a separate
sheet. The second box is based on a list of sub-categories listed on a third
sheet, which shows each major code and the sub-categories appropriate for it.
All three sheets are in the same workbook.
How can I do this?
Thanks,
Jen
 
T

trevosef

Possibly...http://support.microsoft.com/?kbid=213748
"How to Populate One List Box Based on Another List Box"
--
Jim Cone
San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Jen"
wrote in message
Is there a way to synchronize 2 combo boxes in Excel? I.e., limit the values
in the 2nd box depending on what was selected in the first? I do this often
in Access but don't work much in Excel.

The first combo box is based on a list of major codes found on a separate
sheet. The second box is based on a list of sub-categories listed on a third
sheet, which shows each major code and the sub-categories appropriate for it.
All three sheets are in the same workbook.
How can I do this?
Thanks,
Jen

Hi,

Try using ListFillRange property of the ComboBox for the sub-
categories based on the value of the first ComboBox

Trevosef
 

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

Top