How to adjust size of the userform ?

[joh46k]

Hi , I am new to Excel VBA

Problem - Normally, If u move your cursors to the corner of your userform,we will see the single-two pointed arrow pop-out and then we can adjust our own desired size of the user-form.

How to do that in EXCEL VBA? your help is appreciated!!

[AndyLitch]

Me.width = 150
Me.height = 200

[joh46k]

@AndyLitch: where to put those code in #2
Is it under UserForm Initialize ?

[joh46k]

@AndyLitch:

I tried to put your code inside the UserForm Initialize but no arrows appear at the corner to adjust !

(If i am not wrong, code in #2 , is fixed size and user cannot adjust their desired size )

[joh46k]

Bump no response

[AndyLitch]

Apologies - server problems

It sets the size of the userform for you so you won't get handles.. I would generally put the code in the initialize section but it can go anywhere that suits best.

[Andy Pope]

Here is a non API approach.
http://www.andypope.info/vba/resizeform.htm

You might also want to look at the anchor controls example if you are allowing userform resizing.
http://www.andypope.info/vba/Anchor.htm

[AndyLitch]

Very impressive Andy... I must make a point of learning that

[JosephP]

see also formfun.zip on Stephen Bullen's page http://www.oaltd.co.uk/Excel/