Hello There,
In one of my earlier post, regarding highlighting Table's current row selection was solved.
You can refer the above link for the working of a table's current row selection example.
I would like to know, how this can be worked out (VBA Code) without a table in a worksheet. Here the indicator column would be Column A.
If the current row selection has any value then:
-the indicator column A's cell should highlight a Yellow colour.
-rowheight = 25
-horizontal center aligned
-row = bold
If the current row selection has any no value then:
-it should do nothing.
When the user leaves the selection, the row should be back to it's previous state
Please find attached a sample workbook for your reference.
Thank you and look forward to hearing from you.
Regards,
Don
In one of my earlier post, regarding highlighting Table's current row selection was solved.
Highlight Current Table Row Selection (Specific Column/Entire row)
Hello There, I have 2 requirements to indicate current row selection in a table as below and to achieve this using VBA: 1. To highlight the current row's specific column (with fill colour) 2. To highlight the entire row (with fill colour) I have attached a sample workbook for your reference...
chandoo.org
I would like to know, how this can be worked out (VBA Code) without a table in a worksheet. Here the indicator column would be Column A.
If the current row selection has any value then:
-the indicator column A's cell should highlight a Yellow colour.
-rowheight = 25
-horizontal center aligned
-row = bold
If the current row selection has any no value then:
-it should do nothing.
When the user leaves the selection, the row should be back to it's previous state
Please find attached a sample workbook for your reference.
Thank you and look forward to hearing from you.
Regards,
Don