hidden button is the active control

[Gasman]

@arnelgp Finally! an answer that helps. I was playing with this and you have just fleshed it out. Thank you so much!

Wasn't the same exact method mentioned in post #2? by @MajP

 

[arnelgp]

Wasn't the same exact method mentioned in post #2? by @MajP

not exactly, post #2 code will fail, since he did not use Set
to save the activecontrol.
and i use public function.

 

[Gasman]

not exactly, post #2 code will fail, since he did not use Set
to save the activecontrol.
and i use public function.

The logic is the same though, is it not?

 

[arnelgp]

The logic is the same though, is it not?

then i give majpi the attribution to the the code i posted and everyone is happy without complain.

 

[Gasman]

then i give majpi the attribution to the the code i posted and everyone is happy without complain.

No, you enhanced it.
My point was the O/P complained about finally getting an answer from your post #20, when it was pretty much offered on the second post.

 

[arnelgp]

point granted.
Ms.ClaraBarton, don't celebrate early, post#2 is the correct answer, disregard my post.