All the damn names are ta
New Member
- Joined
- Oct 28, 2002
- Messages
- 28
Private Sub CommandButton1_Click()
With ActiveWorkBook.Worksheets.PageSetup
.CenterHeader = TextBox1.Value
.CenterFooter = Date
End With
Unload Me
' Me is just another way of saying UserForm
End Sub
I have this macro on the command button of my form, but it doesn't work. Can someone help?
With ActiveWorkBook.Worksheets.PageSetup
.CenterHeader = TextBox1.Value
.CenterFooter = Date
End With
Unload Me
' Me is just another way of saying UserForm
End Sub
I have this macro on the command button of my form, but it doesn't work. Can someone help?