Calender Code

[Mamud]

HELLO GUYS;

I have that calender user form

Private Sub Calendar2_Click()
RawLog.TextBox7.Value = Calendar2.Value
Unload Me
End Sub

Private Sub UserForm_Activate()
    Me.Calendar2.Value = Date
End Sub

That calender code is used for (Rawlog.textbox7)
How can I use that code to another textbox in the same user form ??
and how can I use that calender form for another textboxes in another user form ??

[royUK]

Which calendar form do you mean? Maybe attach an example workbook

[Mamud]

here's an example

I want to make all textboxes open the same calender and take different values from that calender

[royUK]

Use the Enter event of each TextBox like this

Private Sub TextBox8_Enter()
Cal01.Show
End Sub

Change the calendar Click event to

Private Sub Calendar1_Click()
RawLog.ActiveControl = Me.Calendar1.Value
Unload Me
End Sub

[Mamud]

Nice royUK, it works

but what can I do, If I have 2 different userforms ??

[royUK]

To use it on multiple forms see the example. You might have to add the Calendar form again because it's not installed on my PC

[Mamud]

I got a msg in frm

Variable not defined

[royUK]

The code works for me.

Have you added anything? The message indicates that a variable has been added without declaring it

[Mamud]

can you add me the code to enter the calender value to the textboxes??

[Mamud]

Mr. royUK
I cant add a value from the calender in ur last attached file...