ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to add a datepicker control to a cell in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/192290-there-way-add-datepicker-control-cell-excel.html)

Hamid Komaïri

Is there a way to add a datepicker control to a cell in Excel?
 
I'm building a pivot - table including a lot of columns representing dates, I
wanted to include some kind of control that lets you pick the date from a
little datepicker - control popup. This can be handy when records have to be
added or modified. I dont know if this is possible for excel. It should be
accessible through vba also.

Thx in advance.

Ron de Bruin

Is there a way to add a datepicker control to a cell in Excel?
 
Hi Hamid

You can try this
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hamid Komaïri" <Hamid wrote in message
...
I'm building a pivot - table including a lot of columns representing dates, I
wanted to include some kind of control that lets you pick the date from a
little datepicker - control popup. This can be handy when records have to be
added or modified. I dont know if this is possible for excel. It should be
accessible through vba also.

Thx in advance.



Hamid Komaïri[_2_]

Is there a way to add a datepicker control to a cell in Excel?
 
Hi Ron,

Many thanks, that should fit my needs perfectly!

"Ron de Bruin" wrote:

Hi Hamid

You can try this
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hamid Komaïri" <Hamid wrote in message
...
I'm building a pivot - table including a lot of columns representing dates, I
wanted to include some kind of control that lets you pick the date from a
little datepicker - control popup. This can be handy when records have to be
added or modified. I dont know if this is possible for excel. It should be
accessible through vba also.

Thx in advance.




Hamid Komaïri[_2_]

Is there a way to add a datepicker control to a cell in Excel?
 
Hi Ron,

Another thing. So, I'm satisfied with your answer, can I except of clicking
the "yes" or "no" button, do anything else to rate your answer?

Greetings

"Hamid Komaïri" wrote:

Hi Ron,

Many thanks, that should fit my needs perfectly!

"Ron de Bruin" wrote:

Hi Hamid

You can try this
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hamid Komaïri" <Hamid wrote in message
...
I'm building a pivot - table including a lot of columns representing dates, I
wanted to include some kind of control that lets you pick the date from a
little datepicker - control popup. This can be handy when records have to be
added or modified. I dont know if this is possible for excel. It should be
accessible through vba also.

Thx in advance.




Ron de Bruin

Is there a way to add a datepicker control to a cell in Excel?
 
Hi Hamid

You are posting in the web interface and I use a newsreader(Outlook Express) so I
don't know what you see or what you can do.

Many thanks, that should fit my needs perfectly!

But A line like this is a appreciated

Have a nice day


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hamid Komaïri" wrote in message ...
Hi Ron,

Another thing. So, I'm satisfied with your answer, can I except of clicking
the "yes" or "no" button, do anything else to rate your answer?

Greetings

"Hamid Komaïri" wrote:

Hi Ron,

Many thanks, that should fit my needs perfectly!

"Ron de Bruin" wrote:

Hi Hamid

You can try this
http://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Hamid Komaïri" <Hamid wrote in message
...
I'm building a pivot - table including a lot of columns representing dates, I
wanted to include some kind of control that lets you pick the date from a
little datepicker - control popup. This can be handy when records have to be
added or modified. I dont know if this is possible for excel. It should be
accessible through vba also.

Thx in advance.





All times are GMT +1. The time now is 12:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com