Link to home
Start Free TrialLog in
Avatar of chris pike
chris pikeFlag for Canada

asked on

Date prompt fr new player to add to sheet 1 column E

I have a sheet, and need to add a prompt to input start date for tne player.
Avatar of Kesavan Jeganarayanan
Kesavan Jeganarayanan
Flag of Singapore image

Can try this simple VBA script

Sub Testing()
Dim x As Date
x = InputBox("Enter date")
If IsDate(x) Then Range("A1").Value = CDate(x)
End Sub
ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chris pike

ASKER

Thanks guys/ Still working on some issues with the sheet. Get back to you soon.
Thanks Roy
Pleased to help.