sethspearman
New Member
- Joined
- Apr 15, 2010
- Messages
- 11
Hello,
I want to highlight (apply a bold format) around the cell that is 10 cells under the one my user just clicked. I know the vba for applying the formatting. Here is what I don't know how to do.
I only want this to happen if the user clicks on a certain named range. Pseudo code would be
The other trick is that I want to I want to undo it when the user clicks on another cell. So only one cell is highlighted at a time. When the user clicks anywhere outside of the named range then the bold formatting is removed.
Seth
I want to highlight (apply a bold format) around the cell that is 10 cells under the one my user just clicked. I know the vba for applying the formatting. Here is what I don't know how to do.
I only want this to happen if the user clicks on a certain named range. Pseudo code would be
Code:
If userclickedCell is in myNamedRange then
'highlight 10 rows down.
End If
Sub HighlightCell(rowsDown as integer)
'format the borders of that cell.
End Sub
The other trick is that I want to I want to undo it when the user clicks on another cell. So only one cell is highlighted at a time. When the user clicks anywhere outside of the named range then the bold formatting is removed.
Seth