gheyman
Well-known Member
- Joined
- Nov 14, 2005
- Messages
- 2,342
- Office Version
- 365
- Platform
- Windows
How do I insert the Current user into the value I am trying to add to cell R3 (see below)?
Thanks for the Help!
Thanks for the Help!
Code:
Private Sub CommandButton1_Click()
CurrentUser = Environ("UserName")
Sheets("TitlePage").Select
'Sheets("Search").Range("R3").Value = "User XXXXYYY.SUUEEHSH verified that they read the opening statements"
UserForm2.Hide
End Sub