Help with perplexing form problem

F

Frustrated

I am using VBA in Excel XP with Win 2K. PLEASE help me with this issue

I have a user form on which there is a single control (calendar control 10.0). I have simple code attached to a button on a sheet that opens the form obtains the date the user double clicked and then dismisses the form again.

Everything works fine except: every time the form is opened it gets a little smaller. It will even cut off the right edge of the calendar control obscuring the last day of the week from view.

The height and width properties of the form are changed, even though I manually set them before hand to the correct size

Please advise me on this, what is going on?
 
T

Tom Ogilvy

Private Sub Userform_Initialize()
userform.Width = 30
userform.Height = 40
End Sub

Might help, but I can't say why it is happening.

--
Regards,
Tom Ogilvy

Frustrated said:
I am using VBA in Excel XP with Win 2K. PLEASE help me with this issue.

I have a user form on which there is a single control (calendar control
Click to expand...
10.0). I have simple code attached to a button on a sheet that opens the
form obtains the date the user double clicked and then dismisses the form
again.
Everything works fine except: every time the form is opened it gets a
Click to expand...
little smaller. It will even cut off the right edge of the calendar control
obscuring the last day of the week from view.
The height and width properties of the form are changed, even though I
Click to expand...
manually set them before hand to the correct size.
 
D

Doug Glancy

Are you unloading the form or just hiding when you "dismiss" it?

As a fix, I guess you could set the height and width in the
userform_initialize event or userform_activate event, but maybe that
wouldn't work any better than doing it as you have been:

Me.Height = 100
Me.Width = 200

hth,

Doug

Frustrated said:
I am using VBA in Excel XP with Win 2K. PLEASE help me with this issue.

I have a user form on which there is a single control (calendar control
Click to expand...
10.0). I have simple code attached to a button on a sheet that opens the
form obtains the date the user double clicked and then dismisses the form
again.
Everything works fine except: every time the form is opened it gets a
Click to expand...
little smaller. It will even cut off the right edge of the calendar control
obscuring the last day of the week from view.
The height and width properties of the form are changed, even though I
Click to expand...
manually set them before hand to the correct size.
 
F

Frustrated

Thanks Tom and Doug.

I fixed the issue by adding the sizing code to the form initialize event. This works, but I still don't know why this occurs to begin with...oh well.
 
D

Doug Glancy

use the "Unload" method. Read about it in Help, but the basic syntax is:

"Unload UserForm1"
or, if from inside the Form, you can say "Unload Me"

hth,

Doug
 
Top