Userform for entering date into cell F23

**jamer02** · 07-12-2011, 07:11 AM

Hey guys,

Does anybody know how to create a userform that asks the user to input a date, which then gets copied into cell F23 of sheet 1 of a workbook?

Any help would be great.

Jamer

**Dave H9** · 07-12-2011, 08:14 AM

In it's simplest form -

Sub dte_req()
mydate = InputBox("Please enter date")
Sheet1.Range("F23").Value = mydate
End Sub

Dave H

**jamer02** · 07-12-2011, 08:33 AM

works a treat

cheers

**royUK** · 07-12-2011, 12:59 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save