M
M G Henry
I am working in Excel 2003
As a part of my worksheet titled "Worksheet" I am trying to enable
Combo boxes based on the value of a check box and the value in a list
box.
There will be a total of 6 combo boxes on the Worksheet. The first
combo box that deals with the body of a book will by default enabled.
The second combo box will be set to appear disabled unless a forms
control check box is checked to indicate there will be a cover on the
book.
The 3rd through 6th combo box will each be disabled by default and
will be enabled when the list box which indicates the additional
sections has a value of 1 through 4. 1 would enable the 3rd combo
box, 2 would enable the 3rd and 4th combo box, etc.
I know how to place the controls on the worksheet I just do not know
how to set up the checks for the fields that will switch them to
enabled when needed
As a part of my worksheet titled "Worksheet" I am trying to enable
Combo boxes based on the value of a check box and the value in a list
box.
There will be a total of 6 combo boxes on the Worksheet. The first
combo box that deals with the body of a book will by default enabled.
The second combo box will be set to appear disabled unless a forms
control check box is checked to indicate there will be a cover on the
book.
The 3rd through 6th combo box will each be disabled by default and
will be enabled when the list box which indicates the additional
sections has a value of 1 through 4. 1 would enable the 3rd combo
box, 2 would enable the 3rd and 4th combo box, etc.
I know how to place the controls on the worksheet I just do not know
how to set up the checks for the fields that will switch them to
enabled when needed