automatic date select in userform

[Halos]

Hi,

I created textbox in userform and added date

manually. When I press command button it automatically copying date information to the sheet. Can I select date automatically from the userform and click appropriate date and select? please see below my code:

Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")

ws.Cells(iRow, 1).Value = Me.textbox_data.Value

Thanks in advance
​

 

[Worf]

Hi

Not sure if I understood what you want. Would you like a calendar control like the one below?

 

[Halos]

Hi

Not sure if I understood what you want. Would you like a calendar control like the one below?

Yes, if it is possible it is ok for me.

 

[Worf]

https://www.wiseowl.co.uk/blog/s440/date-time-picker-vba.htm

Try installing the date picker control, link above:

 

[pjrulez]

Hi,
is there an alternative?
That page isn't available anymore...

 

[Worf]

Google for Excel date picker. Here is one option:

Mini Calendar and Date Picker