Creating a calendar drop down box for multiple cells

Hi all

Could somebody please tell me where I am going wrong? I am fairly new at vba. Basically I want to be able to click on a certain cell and have a calendar box pop up and enter the date in that cell. I have a few different ranges as to where I need to populate a date.

Please Login or Register  to view this content.

Thanks

Please don't post the same question every 10 minutes!!

You might find this helpful

http://www.fontstuff.com/vba/vbatut07.htm

Per the forum rules, please edit your post to add code tags.
Just highlight all of the code, then click the button with # symbol.

You code works fine for me. However, you stated:

I want to be able to click on a certain cell

Your code uses the BeforeDoubleClick event which, obviously, means not a single click. If you intended to use a single-click, then use the Selection_Change event.

Thanks Palmetto.

ConfusedaboutVBA,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.