ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worksheet (https://www.excelbanter.com/excel-programming/293901-worksheet.html)

alldreams

worksheet
 
I'd like a checkbox to be unchecked when the user goes to
a different worksheet in the same workbook. What
function should I use?

thanks!

NicoB

worksheet
 
You may use the following event-functions of the 'ThisWorkbook' module
Private Sub Workbook_SheetActivate(ByVal Sh As Object
'manage your checkbox as you wan
'Sh is the new active worksheet
End Sub
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object
'manage your checkbox as you wan
'Sh is the new active worksheet
End Su

or the event-functions of the worksheet module
Private Sub Worksheet_Activate(
'manage your checkbox as you wan
End Su
Private Sub Worksheet_Deactivate(
'manage your checkbox as you wan
End Su



All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com