Two different calendar pop-ups on same worksheet?

[speterson]

I'm less than a novice at VB code, really! (Maybe I'm too ambitious for my own good). I'm trying to have two buttons on a worksheet that will each bring up the calendar pop-up. But each button will enter the calendar date in a different cell than the other button. I always seem to get stuck with it only entering the date in one or the other because I don't know how to create a second Calendar.frm file to link the second text cell to. I've able to create two different modules but get stuck trying to get the dates to go to two different cells. I don't necessarily need to use the buttons; they could simply click on the specific cells to open the calendars. Please help.

[Leith Ross]

Hello speterson,

Welcome to the Forum!

You should post your workbook. Seeing the layout, formatting, formulae, and any VBA code, will guarantee a working solution. A lot of time will also be saved by eliminating guesswork.

[speterson]

As you can see, I've got one of them working. When I click on the "button" in Q9, it brings up the calendar and enters the data in O9. But I haven't been able to figure out how to get it to enter the other date in S9 when I click on U9.

[jaslake]

Hi speterson

Try this

Please Login or Register  to view this content.

You need to assign the Calendar Macro to both buttons.

You've got merged cells going on there. Most of the experts on this Forum will suggest you avoid that.
John

[speterson]

Thanks! I'll give it a try!

[jaslake]

Hi speterson

Were it me, I'd probably create a second calendar. See attached.

John

[speterson]

Thank You, John! This is exactly what I was looking for. I'm going to go over the code with a microscope and figure out what you did. I know using merged cells doesn't make it easy, but the boss designs the forms, I have to make them work. You've made my day!

Thanks Again!

Speterson