Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to make a resizable UserFrom?

Tags:

ms-word

vba

I do not know how to make the simplest in the world resizable UserForm. What I have seen on different forum threads are terrible behemots (huge as the Universe libraries doing too much). But I need a simple, one stroke solution and I hope it exists. At this moment I have this code:

Dim myForm As UserForm1
Set myForm = New UserForm1
myForm.Caption = "Attributes"
myForm.Show

And I have UserForm_Initialize() which does some extra work. What is horrible (unreasonable?) is that by default a form is not resizable.

like image 301
Jacobian Avatar asked Sep 30 '22 07:09

Jacobian


1 Answers

Here's a simple guide on how to make a userform drag and re-sizable.

http://www.mrexcel.com/forum/excel-questions/558649-userform-movable-resizable.html

like image 53
Mana Avatar answered Oct 05 '22 06:10

Mana