I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

This is a fantastic idea for a VBA project. You should re-post in the
Programming group.
--
Gary's Student


"Elf_chick" wrote:

I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

Elf_chick wrote:

I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

--

Dave Peterson

Sorry to be ignorant and sorry for being late in responding, but where is the
Programming group?

"Gary''s Student" wrote:

This is a fantastic idea for a VBA project. You should re-post in the
Programming group.
--
Gary's Student


"Elf_chick" wrote:

I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

Thank you very much for your suggestion. I actually went through just about
all the posts after I posted this until I found your tip/link to someone with
a similar question and ended up using it. Thanks again.

"Dave Peterson" wrote:

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

Elf_chick wrote:

I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

--

Dave Peterson

Remember that you can search google, too.

http://groups.google.co.uk/advanced_...=group:*excel*



Elf_chick wrote:

Thank you very much for your suggestion. I actually went through just about
all the posts after I posted this until I found your tip/link to someone with
a similar question and ended up using it. Thanks again.

"Dave Peterson" wrote:

Ron de Bruin has some tips/links at:
http://www.rondebruin.nl/calendar.htm

Elf_chick wrote:

I am doing a spreadsheet with dates and instead of individually typing in
each and every one, I was wondering if there was an add-in that when you
click on the cell, a calendar pops up and you choose the date. Kind of like
when you're in Access and you click on the date and the calendar appears and
you can choose what ever date you want.

--

Dave Peterson


--

Dave Peterson

It's been done. Look at John Walkenbach's PUP utility.

You can find his web page at:
http://www.j-walk.com/ss/
You can try a free trial version. You can also obtain the
source code.

Pieter Vandenberg

Elf_chick wrote:
: Sorry to be ignorant and sorry for being late in responding, but where is the
: Programming group?

: "Gary''s Student" wrote:

: This is a fantastic idea for a VBA project. You should re-post in the
: Programming group.
: --
: Gary's Student
:
:
: "Elf_chick" wrote:
:
: I am doing a spreadsheet with dates and instead of individually typing in
: each and every one, I was wondering if there was an add-in that when you
: click on the cell, a calendar pops up and you choose the date. Kind of like
: when you're in Access and you click on the date and the calendar appears and
: you can choose what ever date you want.