Click through a VBA Userform

Question

Was just wondering if its possible to click through a userform.

Background is the following:

I made a userform where the user needs to select sketches. When the user starts selecting, the userform is going transparent. Is it possible to make this userform now unclickable, so I can select sketches and features beneath the userform?

Answer 1

You can either hide the userform or launch it in non-modal state in the first place:

userformName.Show Modal:=False

But then you need to be careful with your code because any code after this line will run immediately. You also need to close your form in code.