Drop Down Menus

ginauk84

New Member
Joined
Aug 1, 2005
Messages
32
I am using data validation to create some drop down menus. The same drop down menus are used in loads of different workbooks. I believe there is a way you can link to a master workbook so that every time I update the drop down I don't have to go in and out of every workbook, I can just change the master and all the other workbooks will follow.

Also there is an option in the drop down 'other' and we need people to fill in the cell to the right to say what 'other' is. People aren't doing this so we wondered if there was any way for the cell on the right of the drop down to flash or something when this option was selected?
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
56,596
Office Version
  1. 365
Platform
  1. Windows
Also there is an option in the drop down 'other' and we need people to fill in the cell to the right to say what 'other' is. People aren't doing this so we wondered if there was any way for the cell on the right of the drop down to flash or something when this option was selected?
For this part use Conditional Formatting. If your drop-down is in cell A1, then:
1. Select B1
2. Format|Conditional Formatting...|Condition 1|Formula is: =A1="Other"|Format|Patterns|choose your colour|OK|OK
 

Forum statistics

Threads
1,176,452
Messages
5,903,181
Members
435,014
Latest member
chriswind

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top