How to add TabStrip to DialogBox (VBA)

[JFogh]

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

 

[Andrew Poulsom]

Use the MultiPage control:

http://support.microsoft.com/kb/155374

 

[JFogh]

I am working with DialogBox's. Is an UserForm the same as a DialogBox?

 

[Andrew Poulsom]

Yes a UserForm is a dialog box (unless you are using and MS Excel 5.0 Dialog Sheet).

 

[JFogh]

Thats what I'm using An MS Excel 5.0 DIalog Sheet. Is it possible to have tabs in them?

 

[Andrew Poulsom]

Sorry no, the Forms Toolbar doesn't have a Tab-Strip or MultiPage control.

 

[JFogh]

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...

 

[Andrew Poulsom]

Right click the Button and choose format Control. On the Control tab uncheck Dismiss and click OK. Now try your code again.

 

[JFogh]

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

 

[Andrew Poulsom]

Sorry, I don't understand. Why are you hiding DialogA?