LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dajana
 
Posts: n/a
Default Automatically change the text color when you check out the checkbo

I have few checkboxes and what I am trying to do is to write a macro so that
every time I check out one of the check boxes the text (statement) that is
associated with that specific checkbox changes color.
Also I have a macro that automatically copies and pastes info from one sheet
to the other however if the text is in red it will paste it but in automatic
black color. How can I get it paste in color.
 
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
How change dimensions of data label text box in pie chart? Gouden Willem Charts and Charting in Excel 3 March 7th 06 12:11 PM
Check if cell contains certain text jhockstr Excel Worksheet Functions 2 August 25th 05 09:32 AM
automatically change text case on entry John Davies Excel Discussion (Misc queries) 2 July 15th 05 08:42 AM
text color change in cell reference TomKat743 Excel Discussion (Misc queries) 3 June 16th 05 12:38 AM
Check if table contains text Peter B Excel Worksheet Functions 1 January 21st 05 01:38 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"