Connecting date selected on a calendar to a specific cell

I have designed a calendar GUI in my macro. When someone selects a specific date on said calendar, I want that date to fall into a specific column. I can do this with other user input boxes, but I can't figure out how to do it with the calendar option.

Please help!

-Jared

Hello jared,

It is difficult to offer workable solutions when you have written the code using vaporware. Please post your workbook with before and after examples of how the data should be arranged and any comments needed to explain what you want.

Hello Jared,

Thanks for filling in some of the key details like the which Calendar control you are using. By the way, vaporware is a software industry term used to describe software that has not been written yet. It only exists in the theory.

Hello ,

Here is an example of how to transfer the Calendar selection to cell A1 on the ActiveSheet. You may need to change the name of the command button and the range to match what you are using.

Please Login or Register  to view this content.

Hello Jared,

Glad I could help.