Date in the UserForm

[kachuen2006]

I 'm going to make a small data base using a populate UserForm for data entry. I have a pop up calendar for my expiry date entry but i dont know how to made it to show the date in the UserForm instead of the cell in the worksheet. Can someone help to figure out the problem???

[Norie]

There's no code or userform in the workbook you uploaded, just a button that doesn't work.

Did you upload the correct workbook?

[kachuen2006]

There's no code or userform in the workbook you uploaded, just a button that doesn't work.

Did you upload the correct workbook?

Sorry that i selected the wrong file, and here it is... calendar1.xlsm

[kachuen2006]

can anyone give me some help...

[Norie]

Which userform is it you are referring to?

[kachuen2006]

Dear Norie,

Thanks for your kindly help! I will like to input the data into the Log worksheet but i m stuck by the pop-up calendar. Can you tell me the changes you've done?

Kevin

[Norie]

Kevin

Firstly, do the changes work?

[kachuen2006]

yes....its work perfectly.....and i have copy all the script into my another file but in vain....it cant show the date ~.~

I found 2 changes in the code..
1 With frm_EnterData2.Expiry
.Value = CDate(CmdBtnGroup.Tag)
End With
GoTo chg_month

2. Sub addDate()
' frm_EnterData2.Expiry.Value = re
End Sub

its there anythings i omitted?

[Norie]

What do you mean it can't show the date?

Where?

I made quite a few changes, for example you had this to show the pop-up when the Expiry textbox was double clicked in.

Please Login or Register  to view this content.

I changed that to this.

Please Login or Register  to view this content.

Then I put a call to Show_Cal in the Initialize event of frmCalendar2 and removed frmCalendar2.Show from Show_Cal.

Please Login or Register  to view this content.

In the class cCmdButtons I made the change you've just posted, though I probably would have changed some other things there - the code's a bit higgeldy piggeldy.

I commented out the line of code in adddate because as far as I can see it wasn't doing anything - probably should have deleted the sub.

That's all I changed really, there was no code to put the data from the userform on the worksheet.

[kachuen2006]

Dear Norie,

I really appreciate your detail explanation which help me learn a lot. Thank you very much