Hi,
I am trying to write some VBA code. I want to have a message box appear every time a workbook is opened.
I want it to have a yes/no button, where pressing yes will show "sheet1" and pressing no will show "sheet2".
So far i have this:
Private Sub Workbook_Open()
Dim answer As Integer
answer = MsgBox("Is this your first time using this spreadsheet?", vbYesNo + vbQuestion, "Instructions")
If answer = vbYes Then
Worksheets("Sheet1").Activate
Else
Worksheets("Sheet2").Activate
End If
End Sub
The message box appears when i press play in VBA, but it does not open automatically when i open the workbook, nor does it return sheet 1 when yes is pressed, or return sheet2 when no is pressed.
I am an inexperienced vba user.
I am trying to write some VBA code. I want to have a message box appear every time a workbook is opened.
I want it to have a yes/no button, where pressing yes will show "sheet1" and pressing no will show "sheet2".
So far i have this:
Private Sub Workbook_Open()
Dim answer As Integer
answer = MsgBox("Is this your first time using this spreadsheet?", vbYesNo + vbQuestion, "Instructions")
If answer = vbYes Then
Worksheets("Sheet1").Activate
Else
Worksheets("Sheet2").Activate
End If
End Sub
The message box appears when i press play in VBA, but it does not open automatically when i open the workbook, nor does it return sheet 1 when yes is pressed, or return sheet2 when no is pressed.
I am an inexperienced vba user.