MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Automatic Update for Combo Box

  Asked By: Ronnie    Date: Feb 06    Category: MS Office    Views: 1926

iam having two sheets and having one combo box in each sheet,
depending on the selection of one Combo Box i need to update the combo box in
next sheet

eg:in first sheet i have one combo box with two values:Global,Regional
In second Combo box i have one combo box with four values,ALL
when global is selected in the first sheet i automatically neeed to
select ALL in the second combo box in second sheet



1 Answer Found

Answer #1    Answered By: Hubert Taylor     Answered On: Feb 06

You will need to write a macro in the Change event of the first comboBox.
That macro will need to test the value of the box  and if it is "Global" set
the second ComboBox Value to "All"

You may also want to set the second ComboBox to Locked so the user cannot
change it without coming back to sheet  1 and changing the first ComboBox to

Don't forget if you do this to unlock the second box if the first box is
changed to Regional

Didn't find what you were looking for? Find more on Automatic Update for Combo Box Or get search suggestion and latest updates.