View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default InputBox Variables

FJinSA

This will work:

Sub InputDate()
Dim dt As String

dt = InputBox("Please enter the date")
Worksheets("Summary").Range("A4") = dt

End Sub

Regards


Alex
"FJinSA" wrote:

Hi all,
I want to create an input box that asks users for the date to use in the
spreasheet, then I want this date to populate to a worksheet named "Summary"
in cell A4.
Your help in appreciated...