I don't understand why this isn't working.
Sub showsheet()
UserForm1.Caption = Range("Adm!b2").Value
UserForm1.Show
UserForm1.TextBox1.SetFocus
End Sub
I need the titlebar of the userform to show whatever is in Adm!b2. If it's important this value will always be text.
Thanks in advance.
Sub showsheet()
UserForm1.Caption = Range("Adm!b2").Value
UserForm1.Show
UserForm1.TextBox1.SetFocus
End Sub
I need the titlebar of the userform to show whatever is in Adm!b2. If it's important this value will always be text.
Thanks in advance.