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 !!!
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 !!!
If you are setting your size via the properties, then they should be saved. How are you actually setting it?
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
I just drag the edges to the size I wish.
save
exit excel
what do I do wrong ?
thanks
Are you dragging the edges in design view or in display view?
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
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
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Hey Lucas, do you know what "unreliabilities" in the Calander Control Ken was referring to?
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
Hi Aaron, principally, the library is not present on all machines, even with similar installations........see this from post #11 of the linked thread.
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...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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Excellent, thanks lucus.
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
I am pretty new to VBA.
Did not notice the Design mode.
Does it make any difference ?
thanks !
It's the difference between it getting saved or not
Cordially,
Aaron
Keep Our Board Clean!
- Please Mark your thread "Solved" if you get an acceptable response (under thread tools).
- Enclose your code in VBA tags then it will be formatted as per the VBIDE to improve readability.
cool.
thanks a lot.