Excel VBA - Simpliest Q ever - Button

  GregB 15:56 11 Aug 2005
Locked

All,

I'm pulling my hair out here! :o(

I've got the code, and I've put a button on my form (using View->Toolbars->Control Toolbox) and selecting the button.

I just can't get the button to act as a button. Whenever I click it, it allows me to resize it, and edit the code etc... How do I get back out of design mode?!

Cheers

  VoG II 16:30 11 Aug 2005

If this button is on a userform then you need to insert in an ordinary module some code to display it:

Sub ShowMyForm()

userform1.Show

End Sub

  GregB 11:50 12 Aug 2005

It was even easier than that - I needed to re-click the Design button on the Toolbox Toolbar.

Only worked it out after reverting back to an old version of Excel, which had it implemented slightly better (IMVHO) :o)

Thanks anyway!

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?