How to Get a Tabstrip "Look" on a Worksheet

**kokodidge** · 10-16-2008, 12:59 PM

I can't use a Tabstrip control in a worksheet (they don't function properly), but I'd like to offer the look and feel of a tabstrip control with a textbox on each tab. Any ideas?

DETAILS
---------
I have a VBA game/simulation which puts the user in the role of a manager trying to comply with regulations. The game looks and works great, but I'm struggling with my opening worksheet. I want to display information about the game, how to play, background about the regulations, etc... All this info, however, is too much to show on a single worksheet. I'd like to use a tab metaphor with one or more textboxes and graphics on each tab.

The only idea I have is to use commandbuttons with a single textbox and change the text on the button click. This will limit my ability to use graphics (screen grabs).

So my questions are:

Is there anyway to use a tabstrip control on a worksheet?
Alternatively, is there an HTML browser control that I could add to the worksheet and change the HTML page whenever the user clicks one of the command buttons?

For what it's worth, the workbook needs to function in Excel 03 and 07. Thanks in advance for your help.

**mikerickson** · 10-16-2008, 01:49 PM

One thought, a Userform with instructions might be useful throughout the game.
The tabstrip (or Multi-Page) could go on that.

**kokodidge** · 10-16-2008, 03:49 PM

You're correct that I'm looking for a multi-page, not a tabstrip.

I thought about putting the mulit-page on a userform, but my preference was to put it on the first worksheet. You do raise a good point though that it might be helpful to access throughout the game.

If I go the userform route, I'm tempted to use a browser control on the instruction page (on the multi-page control), but I can't seem to make it work. I tried the MS Web Browser control (in system32\ieframe.dll) but can't figure out how to load a page in it. Anyone know if there's an easy-to-use HTML browser control that works on userforms?