Help needed to decide if I should use AfterUpdate or Exit on my UserForm Combobox

RunTime91

Active Member
Joined
Aug 30, 2012
Messages
290
Office Version
  1. 365
Greetings Experts!

I am triggering code based on the EU's selection in a ComboBox.
I just need some guidance on which event to use between AfterUpdate or Exit; or does it matter?
Right now I'm using Exit but I've never been crazy about seeing the 'ByVal Cancel...' after the event.

I'm imagining since both events exist that there is a difference. Yes, I've read what the internet has to say.
Now I'm asking the experts.

Effectively, what I'm doing is setting the formats, Labels and the enabled features for textbox's based on what the EU selects in the ComboBox
And I want those changes to take effect once the EU exits (tabs or clicks out of the ComboBox)

As Always ~ Thank You for the education ~
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Yes, I've read what the internet has to say

Often times I find it helpful to review the Microsoft documentation refresh myself about what each event does, then perhaps conduct some testing with each method to see what works best for my application.


 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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