LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 219
Default How to use VBA to open the Condtional Format dialog box for the user

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell format dialog box will not open ms.giz Excel Discussion (Misc queries) 1 May 21st 08 05:34 PM
Condtional Format Dave Excel Discussion (Misc queries) 3 July 18th 07 02:05 AM
Condtional Format Question Jon Dow[_2_] Excel Worksheet Functions 2 April 15th 07 04:08 AM
condtional format to Todd Excel Worksheet Functions 0 June 16th 06 05:52 PM
Condtional Format Problem ! Michael168[_35_] Excel Programming 5 October 12th 03 07:18 PM


All times are GMT +1. The time now is 12:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"