Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm writing a macro that allows the user to change the colors of the
Conditional formattting. I can't figure out how to open the Conditional Formtting dialog box and then end the macro. My intent is to use an event to run another macro after they've set the colors. Ideally, the event would be the close of the Conditional Formatting dialog box, but I'm not sure that is an XL event. If not, I'll just have the user selecting a cell as the event. 1. Can anyone tell me how to open the Conditional Formatting dialog box from VBA and leave it open for the user to edit? 2. Is the closing of the Conditional Formatting dialog box an event? If so, what is it called? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell format dialog box will not open | Excel Discussion (Misc queries) | |||
Condtional Format | Excel Discussion (Misc queries) | |||
Condtional Format Question | Excel Worksheet Functions | |||
condtional format to | Excel Worksheet Functions | |||
Condtional Format Problem ! | Excel Programming |