I have code written for the user to enter their Name, Date and Time when they open the workbook. However, I do not know how to make it so they have to enter that information before continuing, or how to write the caode to save the information to a new line each time they enter the workbook. I need this to be a log...
Code
Sub AddNameandDateForAccessLog()
Dim myValue As Variant
myValue = InputBox("Please Enter Your Name for Access Log")
Range("A35").Value = myValue
Dim myDate As Variant
myDate = InputBox("Please enter today's date in mm/dd/yyyy format")
Range("C35").Value = myDate
Dim myTime As Variant
myTime = InputBox("Please enter the time")
Range("F35").Value = myTime
End Sub
Display More