Mastering VBA for Microsoft Office 365 by Richard Mansfield

Mastering VBA for Microsoft Office 365 by Richard Mansfield

Author:Richard Mansfield
Language: eng
Format: epub
ISBN: 9781119579380
Publisher: Wiley
Published: 2019-07-30T00:00:00+00:00


See the previous sidebar for details on a bug in using the Deactivate and Activate events in immediate succession.

RESIZE EVENT

The Resize event fires when a user form is resized either manually by the user or programmatically by you.

The syntax for the Resize event is as follows:

Private Sub UserForm_Resize()

The main use for the Resize event is to move, resize, display, or hide controls to respond to a resized form. For example, you might resize a text box so that it occupies most of the width of the user form it resides on (see Figure 15.10) by using code such as that shown in Listing 15.3.



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.