How to add TabStrip to DialogBox (VBA)

J

JFogh

New Member
Joined
Apr 8, 2011
Messages
12
Hi everybody

Wonder if anybody out there know how add a TabStrip or a "Tab-bar" in general (so its possible to more than one page in the dialogbox, represented by a tab) to a dialogBox in Excel?

thank you in advance
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Sort by date Sort by votes
Thats what I'm using :) An MS Excel 5.0 DIalog Sheet. Is it possible to have tabs in them?
 
Upvote 0
Okay, do you then know if it is possible to close Dialog Sheet A AND open Dialog Sheet B, with one button in Dialog Sheet A, to emulate tabs?
I have tried different things, but no matter what I do, and which order I write my code in the macros, Dialog Sheet A will first close, when Dialog Sheet B is closed...
 
Upvote 0
Right click the Button and choose format Control. On the Control tab uncheck Dismiss and click OK. Now try your code again.
 
Upvote 0
That dosn't seem to help.
My code is like:

Sub Test()

DialogSheets("DialogA").Hide
DialogSheets("DialogB").Show

End Sub

The macro is connected to a button in DialogA. The button is clicked of, to just be a "Standard" button
 
Upvote 0
You must log in or register to reply here.

Similar threads

I
  • Question Question
Show the "Edit Name" dialog from VBA for a specific Name
Replies
1
Views
870
Jaafar Tribak
Jaafar Tribak
M
  • Question Question
Can excel return results that are calculated from separate items in a drop down list
2 3 4
Replies
33
Views
752
Peter_SSs
Peter_SSs
C
  • Question Question
Adding weekly totals from one cell to an overall total
3 4 5
Replies
48
Views
1K
Logit
Logit
I
  • Question Question
How to Set Excel's "Find All" Feature to Search Entire Workbook by Default rather than sheet only ?
Replies
1
Views
161
RoryA
RoryA
R
  • Solved
Dynamic Dropdown list of sheet names
Replies
3
Views
511
alansidman
A

Forum statistics

Threads
1,224,590
Messages
6,179,756
Members
452,940
Latest member
rootytrip

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