Solved: Active Control or text box ???

[jammer6_9]

I am having 20 text boxes in a userform (my Mainform), In each "KeyPress" event of the text box, I am calling a "Monthview Calendar" that is in another userform and what I wanted is when I click on the calendar, the value should go to that active text box... How can I do that?

[vba]
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)

frmMain.ActiveControl.Value = calendar.MonthView1.Value
Me.Hide

End Sub

[/vba]

[gwkenny]

Could post the workbook or take a gander at the thread: http://vbaexpress.com/forum/showthread.php?t=17939

In Leave_Request_1.7.xls he does exactly what you want.

If you open the file click the button "Submit Leave Request Form" and double click in the "start" textbox.

Then examine the code behind it, it's pretty easy

Cheers

[jammer6_9]

Definitely it gives me what I wanted... Thanks...

Could post the workbook or take a gander at the thread: http://vbaexpress.com/forum/showthread.php?t=17939

In Leave_Request_1.7.xls he does exactly what you want.

If you open the file click the button "Submit Leave Request Form" and double click in the "start" textbox.

Then examine the code behind it, it's pretty easy

Cheers