highlighting cell
Hi, how do I set the color of a sell using VB? please let me know. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=488595 |
highlighting cell
See ColorIndex property in XL Help!
Regards, Stefi owl527 ezt *rta: Hi, how do I set the color of a sell using VB? please let me know. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=488595 |
highlighting cell
and the range INterior property
-- HTH RP (remove nothere from the email address if mailing direct) "Stefi" wrote in message ... See ColorIndex property in XL Help! Regards, Stefi "owl527" ezt rta: Hi, how do I set the color of a sell using VB? please let me know. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=488595 |
highlighting cell
Try something like
Range("A1").Interior.ColorIndex = 3 See ColorIndex in Help for more information. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "owl527" wrote in message ... Hi, how do I set the color of a sell using VB? please let me know. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=488595 |
highlighting cell
Another tip.
Turn on the macro recorder in tools=Macro=Record a New Macro then select the cell and change the color manually. then turn off the macro recorder and look at the recorded code. -- Regards, Tom Ogilvy "owl527" wrote in message ... Hi, how do I set the color of a sell using VB? please let me know. Thanks. -- owl527 ------------------------------------------------------------------------ owl527's Profile: http://www.excelforum.com/member.php...o&userid=20916 View this thread: http://www.excelforum.com/showthread...hreadid=488595 |
All times are GMT +1. The time now is 11:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com