jonnynacker
New Member
- Joined
- Sep 11, 2014
- Messages
- 46
Hey Guys,
Trying to get script which creates a command button which will be a certain size and location.
here is the code I have so far
Any help?
Trying to get script which creates a command button which will be a certain size and location.
here is the code I have so far
Code:
Private Sub CommandButton1_Click()
Sheet1.Cells(53, 2).Value = "Category has been changed to;"
Sheet1.Cells(54, 2).Value = "CATEGORY 1"
Sheet1.Cells(55, 2).Value = "On the " & Date & Time
'Button to be created here which will remove this information from spreadsheet and in turn itself
End Sub
UserForm3.Hide
End Sub
Any help?