Calendar that inputs date in a specific cell

**slmi1313** · 02-08-2009, 11:08 PM

Hey all, I need help with the code used in this calendar that I found on the site.http://www.excelforum.com/developmen...ndar-form.html

I need the code to add the selected date to a specific cell lets say cell D8
at the moment it adds the date in any cell selected

can anybody help

**royUK** · 02-09-2009, 05:54 AM

The code is not locked so simply find the line that adds the date & change it to the range you require. The code you need to change is in the Class Module,

Please Login or Register  to view this content.

Change to:

Please Login or Register  to view this content.

**slmi1313** · 02-09-2009, 10:04 AM

Awesome Thanks Roy,

Lets say I need in the future to change the cell, I don't know how you got cell d8 out of this code

Please Login or Register  to view this content.

I tried this code

Please Login or Register  to view this content.

and naturally it didn't work

**royUK** · 02-09-2009, 10:15 AM

Cells(8,4) refers to D8 which is Row8Column4

You can use Range("D8")

**slmi1313** · 02-09-2009, 10:16 AM

great resolved Thanks a million

**Nickvii7** · 11-27-2012, 08:42 PM

Does anyone know?? I have the same problem but I need the date to input on two merged cells. Both on different worksheets?

**arlu1201** · 11-28-2012, 01:36 AM

Nickvii7,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.