I have a command button that I don't actually use as a button...but as a floating body on the spreadsheet with instructions.
By right clicking on the tab and selecting CODE...I have the following:
Private Sub Worksheet_selectionChange(ByVal Target As Range)
With ActiveWindow.VisibleRange
Me.CommandButton2.Top = .Top
End With
Now this code works great. Everytime I scroll up or down the page and select a CELL to update...the button appears on the visible part of the page.
What it is I need help with, is that this only works, or triggers, when I select a Cell to update. I have a spreadsheet with over 200 Yes / No questions where the user indicates their answer by selecting a Checkbox. I would like the trigger to also be when the user places a checkmark in a checkbox. Any suggestions on updating this code to INCLUDE this trigger as well?
Thanks everyone - I love this forum...and try to contribute as much as I can...I'm just at the point of time where I need to make a withdrawal from genius pool!
GWB
Bookmarks