beforeupdate

  1. A

    Overcome A 'BeforeUpdate' trigger when there is nothing to update?

    I've run into a problem that I hope someone can provide some advice on to resolve. I have a user form with two textboxes, cu2_start and cu2_end. Normally, these textboxes are filled as part of the userform's initialization procedure. Code associated with a 'BeforeUpdate' trigger of cu2_start...
  2. S

    OptionButtons

    Please download attached Excel file. You will find one UserForm there, run it. Two times select option 2 and choose "No" and close UserForm. 1. Why I am asked "Change it?" just after UserForm loads (no selections are made)? 2. More importantly, why I am two times asked "Change it?" when closing...
  3. S

    Event still triggers after setting EnableEvents to False

    Hi all, i have a procedure which unloads a userform. When this userform is loaded, one of the textboxes are setfocused on (textbox1.setfocus). This textbox has validation codes in its BeforeUpdate event. If wrong text is entered, there will be a prompt. In the procedure i have the...

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