Using Calendar pop-up in cell?

[hallingh]

Hi All:

I have a workbook that projects budget surplus/deficit for upcoming months. The workbook works fine, but I now need to upgrade it a bit. There is a cell where the user enters in the amount of funding received for a certain month. What I need to do is put a little button in the cell to the right of this number that displays a calendar when clicked. When the user selects a date on the calendar, it needs to automatically populate the correct cell below based on what month the user selected.

The cells that contain the data below all come under a row which contains the month. The row looks like this:

A           B            C            D            E
Oct-09     Nov-09      Dec-09      Jan-10       Feb-10

And so on.

The problem is, that these months can change, so I need Excel to recognize "Oct-09" as October 2009, and "Jan-10" as January 2010. This way, when the user selects the date from the calendar, Excel will know exactly what cell to put it into.

I'm sure I have made this seem extremely complicated, and I'm sure it's probably simpler than I'm making it out to be, but it's tough to explain these things. I know this won't be a simple answer, so any guidance at all would be greatly appreciated; I simply don't know where to begin!

Thanks in advance for any help you can give me.

Hank

 

[hallingh]

Any insight on how to create a simple pop-up calendar would be much apreciated as well. Would I have to use a userform and activate it in vba when the user clicks on the cell? Is there an easier way to accomplish this?I've never used a userform to gather a value before, which is why I was hoping there was a simpler way of doing this, but if I have to use a userform then I would obviously like to start developing it.

Thanks for the looks!

Hank

 

[mr.paul.c]

you might want to look at this thread