Excel VBA - Simpliest Q ever - Button

  GregB 15:56 11 Aug 05
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 05

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 05

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…