Hello,
Last December this forum helped me tremendously getting the following VBA code to work:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Font.ColorIndex = IIf(Target.Interior.ColorIndex = 20, 16, 0)
Target.Interior.ColorIndex = IIf(Target.Interior.ColorIndex = 20, -4142, 20)
End Sub
It works great, but a new request has come through that the 4 borders surrounding the cell being double clicked should be changed to bold.
To add more context, the cell in it's non selected state has thin lines on the left and right, but no top and bottom lines. After double clicking, all 4 borders would like to be bold. Then when de-selected (by double clicking again) it would revert to the original state of thin side borders, and no top and bottom borders.
VBA is way over my skillset, I am hoping I can get some help. I did find some codes for borders, but frankly my blind hope and a prayer attempts (not surprisingly) didn't work.
If one of you good people could help, I would be so very grateful!
Thanks!
Last December this forum helped me tremendously getting the following VBA code to work:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
Target.Font.ColorIndex = IIf(Target.Interior.ColorIndex = 20, 16, 0)
Target.Interior.ColorIndex = IIf(Target.Interior.ColorIndex = 20, -4142, 20)
End Sub
It works great, but a new request has come through that the 4 borders surrounding the cell being double clicked should be changed to bold.
To add more context, the cell in it's non selected state has thin lines on the left and right, but no top and bottom lines. After double clicking, all 4 borders would like to be bold. Then when de-selected (by double clicking again) it would revert to the original state of thin side borders, and no top and bottom borders.
VBA is way over my skillset, I am hoping I can get some help. I did find some codes for borders, but frankly my blind hope and a prayer attempts (not surprisingly) didn't work.
If one of you good people could help, I would be so very grateful!
Thanks!