ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   mexcel macro to run onselect (https://www.excelbanter.com/excel-programming/323080-mexcel-macro-run-onselect.html)

mtjarrett

mexcel macro to run onselect
 
hey folks,

i want to know if there is a way to make a macro that will highlight a
section of a row (or the whole row if it has to be that way) whenever i
select any cell in that row (not on pressing enter but when i begin to
type in that cell).

thanks,
-michael


Tom Ogilvy

mexcel macro to run onselect
 
Look at Chip Pearson's site

http://www.cpearson.com/excel/download.htm

see the entry for Hilite. Also note the he offers an addin called rowliner
in the same line. You can modify the code to get your specific requirement.

--
Regards,
Tom Ogilvy

"mtjarrett" wrote in message
oups.com...
hey folks,

i want to know if there is a way to make a macro that will highlight a
section of a row (or the whole row if it has to be that way) whenever i
select any cell in that row (not on pressing enter but when i begin to
type in that cell).

thanks,
-michael





All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com