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.

Hands-on: Acer Predator Triton 700 review

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

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

Apple predictions 2017