Hi,
Say for example, you have a couple of modeless userforms on display and you want to run some small macro each time you activate each userform.
The obvious answer is simply placing the small macro (or a call to it) in each of the UserForm_Activate event handlers.
But what If you wanted to...
I have 25 text boxes named in the following manner on a UserForm
Name: id_[X]_box 1<= x <= 25
I am trying to write a program which can register a change event for all 25 boxes and populate the corresponding [DESCRIPTION] Labels.
Naming scheme for Description Labels Name: desc_[X]_label 1 <= X...
change
check event
class module
class modules
excel
form component
label
property
property let
property set
textbox
userform
userform_activate
userform_initialize
vba
withevents
I am adding a UserForm to speed data entry for our test engineers. This has 3 pairs of TextBox & SpinButtons for selection of product & test plus the test result. Also an Exit button & 2 labels.
_Initialise & _Activate is supposed to set the text for the TextBoxes plus values for the...
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.