Detect end of resize

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
2,136
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
I have a class module which I got from somewhere called CResizer. It's puts a handle on the bottom right of a Userform and lets you drag and resize it.
It's really good! What I'd like to do is resize a label on the Form to the new size.
But I can't figure out where to detect the change is done and apply the new label size.

Mouse Up is not detected when moving.
Anyone have any ideas? Thanks.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Sorry, question was a but ragged! It's form Resize I should be looking at, And it's resizing nicely after a bit of experimenting.
This does almost everything
Rich (BB code):
Private Sub UserForm_Resize()
'Application.StatusBar = Me.Width & " " & Me.Height
txtEdit.Width = Int(Me.Width) / 1.263
Frame1.Width = txtEdit.Width - 3
txtEdit.Height = Int(Me.Height) / 1.253
Frame1.Height = txtEdit.Height - 4
End Sub
It's all maths I think... the fault TB Size is 150H, 280 wide. and font side is 8
As the size increases so should the font size. How might I calculate that?
 
Upvote 0

Forum statistics

Threads
1,226,453
Messages
6,191,134
Members
453,642
Latest member
jefals

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top