Trying to use a number of ComboBox's to ensure user's can only select
specific data from the previous ComboBox. The lists of data will be kept in
Excel columns to make editing simple. I'm just struggling to get a simple
link between the first two ComboBox's to work, not for a lack of trying.

The first ComboBox is simple as I will use the RowSource for the data
source. The selection from this ComboBox will dictate what the next ComboBox
will use as its source data in practice.

The user will only be able to see a form, all the excel sheets will be
hidden from view.

Any help would be much appreciated.

Here is an example of how to do it with worksheet and data validation
dropdowns, http://www.xldynamic.com/source/xld.Dropdowns.html.

It would need adapting for a form, but the principle would be the same.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Philip" wrote in message
...
Trying to use a number of ComboBox's to ensure user's can only select
specific data from the previous ComboBox. The lists of data will be kept
in
Excel columns to make editing simple. I'm just struggling to get a simple
link between the first two ComboBox's to work, not for a lack of trying.

The first ComboBox is simple as I will use the RowSource for the data
source. The selection from this ComboBox will dictate what the next
ComboBox
will use as its source data in practice.

The user will only be able to see a form, all the excel sheets will be
hidden from view.

Any help would be much appreciated.