Input boxes

Hey Guys,

Just trying to do something easy but cant figure it out. I want an input box to put date in in cell F1. I can get the input box but how do i get it to write to cell F1

dim x As Integer

x = InputBox("Enter Date")

Thanks,
Gavin.

Here is the code :

Please Login or Register  to view this content.

Thanks very much for that Rubeus. another question for you. Please see attached.

is there anyway I can get the start of C4 and C6 to change Month with an input box. This is a heading I have to put in the report every month.

Hi Gavin,

I'm sorry I could not get that,
do you want something like this ?

Please Login or Register  to view this content.

Hey Rubeus,

Is it possible to change to the start of the text where it says

" July Monthend saved already, Funds awaiting Director Approval"

So it would just update the Month to whatever month I had in the inputbox.

PS you might want to use an application.inputbox with type:= 1 to help prevent errors

To be fair, if you want it to work well, have a search for inputbox for date - there are much more graceful ways of doing ti than this