PDA

View Full Version : Solved: Date picker userform - the size is changed



gonen
02-09-2009, 04:33 AM
Hi

I am using a date picker userform, after I set it up to my desired size and save it, exiting excel and re starting it, the displayed userform size is changed.

Is there a way to LOCK the size / location of a userform ?

thanks !!!

Oorang
02-09-2009, 06:58 AM
If you are setting your size via the properties, then they should be saved. How are you actually setting it?

gonen
02-09-2009, 07:02 AM
I just drag the edges to the size I wish.

save

exit excel


what do I do wrong ?


thanks

Oorang
02-09-2009, 07:04 AM
Are you dragging the edges in design view or in display view?

lucas
02-09-2009, 07:44 AM
If you plan on using the calendar on more than one computer you should read this thread:

http://www.vbaexpress.com/forum/showthread.php?t=10914

Oorang
02-09-2009, 10:29 AM
Hey Lucas, do you know what "unreliabilities" in the Calander Control Ken was referring to?

lucas
02-09-2009, 11:31 AM
Hi Aaron, principally, the library is not present on all machines, even with similar installations........see this from post #11 of the linked thread.



it was working fine on the laptop i made the workbook on, but when i opened it up on another, almost identical machine it would throw a "can't find object or library" error.


If you want to use the native calendar control on a file that will be used on many machines you will run into this problem quite often. The only thing you can do is make sure the calendar control is installed on every machine it gets used on........an overwhelming caveat in most cases...

Oorang
02-09-2009, 11:52 AM
Excellent, thanks lucus.

gonen
02-09-2009, 12:05 PM
I am pretty new to VBA.

Did not notice the Design mode.

Does it make any difference ?

thanks !

Oorang
02-10-2009, 09:30 AM
It's the difference between it getting saved or not:)

gonen
02-10-2009, 09:44 AM
cool.

thanks a lot.