Calendar pop up query

**stevesunfold** · 10-10-2008, 03:26 PM

hi guys

using this code

Please Login or Register  to view this content.

the trouble is that once cell d24 is activated the calendar control pops up as planned , but it pops up semi out of view i.e half the calendar requires me to scroll down the page . is there anyway i can change where the pop up pops up so to speak

regards

**stevesunfold** · 10-10-2008, 03:27 PM

By the way x:y
is cell d24:d24

**stevesunfold** · 10-10-2008, 04:30 PM

I have tried messing about with target to no avail

**stevesunfold** · 10-10-2008, 04:57 PM

also tried messing about with this post
http://www.excelforum.com/excel-prog...ied-place.html

can anyone help please?

**stevesunfold** · 10-10-2008, 05:26 PM

i have 28 rows visible
and when i click d24 the calender pops up ideally but
it start at a25 through to d34
which means 6 rows of the calendar isnt visible without scrolling

regards

**stevesunfold** · 10-11-2008, 08:50 AM

sorry to be a pain but i still cant rectify this
can anyone help?

**stevesunfold** · 10-11-2008, 09:52 AM

i guess it cant be done ive trawled the net and cant find anything at all
oh well
stick to manual entry

**royUK** · 10-11-2008, 10:07 AM

Can you attach an example workbook?

**stevesunfold** · 10-11-2008, 12:00 PM

hi roy
thanks for the reply

**stevesunfold** · 10-11-2008, 12:01 PM

please note when clicking d24 where the calendar pops up

**VBA Noob** · 10-11-2008, 12:11 PM

Not pretty but may help

Please Login or Register  to view this content.

VBA Noob

**royUK** · 10-11-2008, 12:13 PM

Is this what you mean

Please Login or Register  to view this content.

**stevesunfold** · 10-11-2008, 12:13 PM

thanks vba
not worried about it being pretty but i didnt really want it scrolling down the page
unless when you selct your date it then goes to cell d25 automatically

**stevesunfold** · 10-11-2008, 12:15 PM

roy i was hoping it would pop up above the cell d24

and i need it to select the cell and put that date into d24
and then

automatically select d25

thanks

**royUK** · 10-11-2008, 12:18 PM

This might be better, I am using a widscreen laptop so the last code might not work for you

Please Login or Register  to view this content.

**stevesunfold** · 10-11-2008, 12:29 PM

roy absoultely perfect except it doesnt put the selected date into cell d24 and then move down to d25

**VBA Noob** · 10-11-2008, 12:56 PM

Originally Posted by stevesunfold

thanks vba
not worried about it being pretty but i didnt really want it scrolling down the page
unless when you selct your date it then goes to cell d25 automatically

Sure Roy will come back with a more suitable solution

Please Login or Register  to view this content.

VBA Noob

**stevesunfold** · 10-11-2008, 01:11 PM

cheers noob
unfortuantely roys is better but just need a couple of tweask

**VBA Noob** · 10-11-2008, 02:18 PM

Using Roy idea

Please Login or Register  to view this content.

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Please Login or Register  to view this content.

VBA Noob

**Norie** · 10-11-2008, 02:50 PM

Why not use a userform with a calendar control rather than just stick one on a worksheet?

Then you might have more control over what's happening.

You might also want to look into the Top/Left properties.

**stevesunfold** · 10-11-2008, 03:01 PM

vba that is absolutely perfect

just one last thing when i select the k6 cell and the pop up calendar shows is there anyway to have that directly underneath

sorry to be a pain

**VBA Noob** · 10-11-2008, 03:11 PM

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**stevesunfold** · 10-11-2008, 03:15 PM

vba what can i say except a huge huge thank you
also a huge thanks to roy
thanks for the time youve given me
i really appreciate it

**stevesunfold** · 10-11-2008, 03:29 PM

vba

would you be able to walk me through this piece of code with kid gloves so i can learn from this and use it in other sheets i have without having to bother anyone?

regards

**VBA Noob** · 10-11-2008, 03:56 PM

Please Login or Register  to view this content.

Then the offset is use in the other code. More on select case and calendar below

http://www.ozgrid.com/VBA/select-case.htm
http://www.rondebruin.nl/calendar.htm
http://www.fontstuff.com/vba/vbatut07.htm

VBA Noob

**stevesunfold** · 10-11-2008, 04:06 PM

thats weird because i just put that last code in and when i select the date it doesnt go down to the next cell

**VBA Noob** · 10-11-2008, 04:08 PM

Only works on D24 as requested

VBA Noob

**stevesunfold** · 10-11-2008, 04:13 PM

no the last code doesnt enter the date when you click on it

**VBA Noob** · 10-11-2008, 04:14 PM

You mean the explanation. You need the other module

VBA Noob

**stevesunfold** · 10-11-2008, 04:26 PM

just working my way through it now
thank you so much
this will help so many people im sure

regards

**Slomaro2000** · 11-20-2008, 09:39 AM

Very helpful!!!

**likhary** · 11-20-2008, 09:51 AM

:D it being pretty but i didnt really want it scrolling down the page
unless when you selct your date it then goes to cell d25 automatically

**royUK** · 11-20-2008, 09:51 AM

Originally Posted by Slomaro2000

All,
Im trying to us this same macro and having no luck.. Its working on the the spread sheet that is attached on page 1. But when I open a new book and paste it in its not working.

Here is the code I am trying to use

Please Login or Register  to view this content.

I get "Object Required" error

Where is Calendar1??

Please read the Forum Rules & start your own Thread, add a link to this one.

This thread might also be of help, your error might be because the calendar ocx is not installed on your machine