Menu Button

Vampyre

Vampyre

New Member
Joined
Mar 23, 2011
Messages
30
i really need a piece of vba code i can attach to a button , so that it will return me to a menu screen in a user form.

cheers
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Sort by date Sort by votes
Hi there,

Add a command button to your form and add this code to the button:

Code: 
Private Sub CommandButton1_Click()
    Unload Me
    MainForm.Show
End Sub

Change MainForm to the name of your form.
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Question
Custom Right-click cell menu
Replies
4
Views
246
Formula11
F
T
  • Question
VBA to hide all but one sheet on open
Replies
1
Views
72
Cubist
Cubist
T
  • Question
Navigation menu with hyperlinks
Replies
2
Views
106
tigerzen
T
O
  • Solved
Button to Switch between two values on a data validation dropdown list
Replies
6
Views
264
Peter_SSs
Peter_SSs
U
  • Question
Excel Ribbon button icon change effect
Replies
3
Views
561
jkpieterse
jkpieterse

Forum statistics

Threads
1,215,016
Messages
6,122,700
Members
449,092
Latest member
snoom82

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top