Userform to select worksheet

B

begoldar

Board Regular
Joined
Dec 20, 2005
Messages
98
Hi Everyone,

I'm trying to make a new userform that will activate a worksheet based upon a user choice in a dropdown menu. Is there a way to do this? Thanks!
 
Sort by date Sort by votes
billy1989 said:
Is there any way to reduce the space between the columns of sheets? The gap is very large as you can see in the screenshot!

View attachment 103583
Click to expand...
My code does not do that; there is no instruction to have spaces like that. Check your screen resolution or change the optLeft variable from 78 to some other number. And if by chance you are using Google Sheets or a Mac, that would be the reason.
 
Upvote 0

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
You must log in or register to reply here.

Similar threads

V
  • Question Question
Userform, combobox: Repicking the same selection?
Replies
2
Views
55
vrod2000
V
P
  • Solved
Loading sheet row data to a userform issue.
Replies
7
Views
231
DanteAmor
DanteAmor
C
  • Question Question
Tab Selection from Userform based on Date range
Replies
5
Views
111
campbell1093
C
J
  • Question Question
Filter ListBox on a UserForm using a ComboBox
Replies
1
Views
192
DanteAmor
DanteAmor
I
  • Solved
If value isnt in userform drop down list then allow user to add it
2 3
Replies
20
Views
799
ipbr21054
I

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

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