| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DropDown Menu Macro
Does anyone know how to create a macro to do the following: drop down menu when nothing selected the following 4 cells appear clear, when one of the two options selected the following 4 cells appear grey. Please see attached file +-------------------------------------------------------------------+ |Filename: Image1.jpg | |Download: http://www.excelforum.com/attachment.php?postid=5193 | +-------------------------------------------------------------------+ -- alex1982 ------------------------------------------------------------------------ alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494 View this thread: http://www.excelforum.com/showthread...hreadid=571488 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown Menu Macro
as an example, select C10:F10 then do
Format=conditional formatting change the cell value is to formula is and write a formula like =$B$10<"" then select formatting and select pattern and grey -- Regards, Tom Ogilvy "alex1982" wrote: Does anyone know how to create a macro to do the following: drop down menu when nothing selected the following 4 cells appear clear, when one of the two options selected the following 4 cells appear grey. Please see attached file +-------------------------------------------------------------------+ |Filename: Image1.jpg | |Download: http://www.excelforum.com/attachment.php?postid=5193 | +-------------------------------------------------------------------+ -- alex1982 ------------------------------------------------------------------------ alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494 View this thread: http://www.excelforum.com/showthread...hreadid=571488 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown Menu Macro
I'm being a bit of a donkey, could u right the whole formula i need to enter? -- alex1982 ------------------------------------------------------------------------ alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494 View this thread: http://www.excelforum.com/showthread...hreadid=571488 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
DropDown Menu Macro
I did.
It is working fine for me with B10. for C12:F12, the formula would be =$B$12<"" -- Regards, Tom Ogilvy "alex1982" wrote: I'm being a bit of a donkey, could u right the whole formula i need to enter? -- alex1982 ------------------------------------------------------------------------ alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494 View this thread: http://www.excelforum.com/showthread...hreadid=571488 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| filter dropdown menu so 2nd drop menu is customized | Excel Worksheet Functions | |||
| Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
| Reference Dropdown Menu Items in Macro | Excel Programming | |||
| Referencing Dropdown Menu in macro | Excel Programming | |||
![alex1982[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
