PLEASE HELP in Need of a VBA userform code for Calender date to Display in another userform textbox

[resaadkins]

[h=2]HELP!!! Need VBACode for Calendar to display in Userform textbox[/h]

What code so I use in order to have a userform1 calendar linked to a worksheet cell and then have the worksheet cell data displayed in another userform2 textbox?​

 

[Momentman]

HELP!!! Need VBACode for Calendar to display in Userform textbox

What code so I use in order to have a userform1 calendar linked to a worksheet cell and then have the worksheet cell data displayed in another userform2 textbox?​

Try this for the calendar:

Private Sub Calendar1_Click()
Range("A1").value = Calendar1.Value 
Range("A1").NumberFormat="mm/dd/yy"
End Sub

And this for the Textbox

userform2.textbox1.value = range("A1").value or

userform2.textbox1.value = userform1.calendar1,value

 

[resaadkins]

I tried this and it still not display date in the textbox on userform1
the calendar is in userform2. any thoughts as to why this isn't functioning right