Put the following code behind each worksheet and simply change the text message.
Private Sub Worksheet_Activate()
UserForm1.TextBox1.Text = "This is Sheet number 2!!"
End Sub
When the worksheet is activates the text on your userform will change.
Put the following code behind each worksheet and simply change the text message.
Private Sub Worksheet_Activate()
UserForm1.TextBox1.Text = "This is Sheet number 2!!"
End Sub
When the worksheet is activates the text on your userform will change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks