Hi,
I'm new to VBA. I'm trying to write a macro that toggles between three or more font colors for the cells that are selected. I started with the "record macro" feature and then tinkered with the code because I obviously don't have a very good understanding of this process yet. How would I go about writing a code like this?
Thanks.
write some data in some cells in range some range change color of tex in some to red some to yellow and some light blue (and some other colors) select the range with data and run the macro firs time then next and again, and ...
Please Login or Register to view this content.
Best Regards,
Kaper
Take a look at the file in post#4 of the following thread.
http://www.excelforum.com/excel-prog...-blinking.html
It uses code like the following (written and tested using Excel 2003) to have a cell blink in a sequence of three colors.
LewisPlease Login or Register to view this content.
Last edited by LJMetzger; 03-22-2014 at 12:17 PM. Reason: Made sample code generic
Thanks for that starter Kaper!
I appreciate the help!
Glad it helped.
See also Lewis proposition - it uses another property - color, not colorindex wich allows for much reacher palette of colors.
And following forum rules please mark thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks