Good afternoon,
Torchan kindly helped me (alot) in creating the attached spreadsheet, however whenever I insert the tick on any cell, it automatically jumps to the top of the page again. Is there any way to prevent this?
Kind Regards
Karen
Good afternoon,
Torchan kindly helped me (alot) in creating the attached spreadsheet, however whenever I insert the tick on any cell, it automatically jumps to the top of the page again. Is there any way to prevent this?
Kind Regards
Karen
Removed by JT
Last edited by JohnTopley; 08-21-2023 at 11:30 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Private Sub cmdTICK_Click() With Sheet1 If Me.cmdTICK.BackColor = vbGreen Then ActiveCell.Interior.Color = vbGreen ActiveCell.value = " " & ChrW(&H2713) ActiveCell.Font.Size = 14 Me.Hide End If If Me.cmdTICK.BackColor = &H8000000F Then ActiveCell.Interior.Color = xlNone ActiveCell.value = "" Me.Hide End If End With 'Cells(3, ActiveCell.Column).Select ' <<<< delete or comment out as per this code End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks