[rama4672]

I Have done a form that when it is run it asks for the date, What i want it to do when the date is entered is have the date that was entered put into a cell on a worksheet, How do i get it to do that.

Thanks

Ian

 

[SabreWolf3]

Hi Ian,

Without knowing how the date is selected on your form, it's difficult to answer your question. Does the user type the date into a textbox? Or select it from a drop-down menu?

I usually have three separate drop-downs on my userforms for date selection. Combobox1 contains year, Combobox2 contains month, and Combobox3 contains day. Then I have a commandbutton at the bottom of the form. To enter my data onto a cell in the worksheet, I do this:

Sub CommandButton4_Click
Sheet1.Range("A1").Value = UserForm1.Combobox2.Value & "/" & UserForm1.Combobox3.Value & "/" & UserForm1.Combobox1.Value
End Sub

Let us know if you need more help.

 

[XL Guru]

Ian, your location is not stated.

Here in the UK, whenever I need to do this I look up this post by John Green, MVP.

http://www.google.co.uk/groups?hl=e...up=*excel*&as_uauthors=john%20green&lr=&hl=en

Rgds/HTH if applicable,
Andy

 

[rama4672]

Thanks for the help Andy and sabrewolf, That has been a great help

Ian

I am in the UK Andy