Copy LDDate value to cell

[aratcliffe]

Hello, could do with a little help with this one.

I have a series of Textboxes, combo boxes and date boxes on a work sheet creating a user form. I want the values entered by the user to copy to another cell on the worksheet. For the textboxes and combo boxes I have been using the following macro:

Private Sub TextBox10_Change()
Sheets("Add New Cus").Range("AS4").Value = TextBox10.Value
End Sub

This has been successful. I am having trouble though with the LDDate1 and LDDate2 boxes, what would the equivalent macro for these be?

(The worksheet name is "Add New Cus")

Thanks!

[LokeshKumar]

Hey,

Your example sounds perfect...
You can see the properties of your object like text box or combo box.....you can see the name as well there.......

Please Login or Register  to view this content.

you can add the following....whatever is highlighted in your combo box will be appear in AS4

Please Login or Register  to view this content.

[aratcliffe]

Hello,
Thanks for your help but it doesn't work for a LDDate object.

What would the equivalent formula be for a LDDAte object?

Thanks

[LokeshKumar]

Hey sorry
I got it wrong......what would be LDDate1 and LDDate2?
Could you explain.....a more.....what you are looking for.....

[aratcliffe]

LDDate is an object which allows the user to choose a date from a drop down calendar.
The value selected is the one which I want to automatically mirrored in a cell

[LokeshKumar]

try this....

Please Login or Register  to view this content.

[aratcliffe]

This still doesn't work?