I've been googling this everywhere but can't find anything helpful.
In my sub I have something like
Load.AdSelect
AdSelect is a userform that pops up, and all I want it to do is to open AdSelect then close it straight away with no dialogue.
Basically, it selects a cell, A3, opens AdSelect...