Bright01
asked on
Adding a Doubleclick for Checkmarks
EE Pros,
I need a macro that looks at a matrix of cells (columns G - T and below Row 4....could be set up as a rangename) and when a cell is "doubleclicked" a checkmark (Wingding2 with "P") will automatically appear in the cell.
Thank you in advance!
B.
Add-doubleclick-check.xlsm
I need a macro that looks at a matrix of cells (columns G - T and below Row 4....could be set up as a rangename) and when a cell is "doubleclicked" a checkmark (Wingding2 with "P") will automatically appear in the cell.
Thank you in advance!
B.
Add-doubleclick-check.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes.
Change:
Change:
If Not Intersect(Range("G5:T1048576"), Target) Is Nothing Then
to:If Not Intersect(Range(YourNamedRange), Target) Is Nothing Then
ASKER
One quick question; instead of using a hard coded table range, would I be better off using a Range name so that if columns are added, it wouldn't break the Macro?
B.