Multipage control help

[desk.doc]

Hi all. I am creating a bar inventory/"numbers" sheet for a corporation. I have been searching on and off for a week or so to find an answer or a tutorial on what I am looking to implement into this worksheet. I want to take a userform, with a multipage control, and have the control for each tab, show me a different part of the worksheets. For instance, the first tab would be inventory, the second tab would be ordering, the third tab would be weekly numbers, etc ... I am wondering how to "add ranges to the multipage control in order to make it a "viewer". I have found tutorials on how to print, enter info into the form and save it to the sheets using a button, but I can't find a tutorial on how to implement the control on how to make tabs show the ranges. Can someone point me in the right direction on a tutorial, or maybe if willing a small spreadsheet with a mulitpage control on it, showing how to add the ranges from different worksheets? I appreciate any help in advance. THANKS!!

[Leith Ross]

Hello Desk.Doc,

Can you explain more about what you mean "show ranges"?

Thanks,
Leith Ross

[desk.doc]

No prob. Thanks for the reply Leith! What I am looking to do is take a userform, and add a multipage control.(This is can do) With the multipage control, I would like to be able to have different tabs on it. (This I can do) What I am trying to take the tabs, each labeled for a different worksheet, and have the worksheet "viewable" on the tab. I am not sure how to implement this action. For instance, the first tab on the multipage control will be inventory. When this tab is selected, I am looking for the tab to show the worksheet it's associated with. The second tab on the multipage control will be Order. This too will be associated with the corresponding worksheet. I can parse the sheet to select the cells I want to view, but I can't find out how to show the worksheet on the tab. I hope this explanation helps. Thank you!

[Leith Ross]

Hello Desk.Doc,

Thanks for the reply. That clears things up for me. I thought you might be talking about having the worksheet or part of it on the MutiPage control. I am guessing you want this to be interactive as well? Let me know.

Sincerely,
Leith Ross

[desk.doc]

If it's possible to do so, I would like for it to be interactive. I have been looking for a tutorial or example on this, but I haven't been able to find anything. Will you point me in a direction?

[Leith Ross]

Hello Desk.Doc,

You can easily place a static view of the worksheet or a range onto the MultiPage. Unlike VB, VBA doesn't support muliple document interface. Which means we can't display it like a window on the MultiPage. However, it may be possible through code to use OLE (Object Linking and Embedding) to create a container on the UserForm. Since I have never done this in VBA, I'll have to research it.

Sincerely,
Leith Ross

[desk.doc]

Thanks again Leith. I get what you are saying. I wasn't sure if it was possible to do this. Is there a tutorial or example on how to do this static. And if you do this static, I assume it's possible to select a certain range to be displayed. Thank you for your time today. I appreciate it!

[royUK]

You are possibly looking for the OWC Spreadsheet Control, not simple to code.

See Dennis Wallentin's article

http://www.excelkb.com/article.aspx?...6&cNode=1U5J4S

[desk.doc]

Thanks for you time today Leith. Is there a tutorial on how to do this with a static view? I am estimate that you can also select certain ranges to be viewed instead of the entire worksheet.

[Leith Ross]

Hello Desk.Doc,

Let me put together an example workbook for you. You can then use the code as a guide. It's easier to see it in a workbook than make several posts to show the code and where it goes. I'll post back later today.

Sincerely,
Leith Ross

[desk.doc]

Leith: Thanks for your time on this. The help you are willing to give is more than I can ask for. THANK YOU!

[Leith Ross]

Hello Desk.Doc,

You're welcome. Glad to help out.

Sincerely,
Leith Ross

[Leith Ross]

Hello Desk.Doc,

The attached workbook has a working example of showing a selected range (7 columns x 25 rows max) on a MultiPage control. You can either type the range in or click the button on the far right of the RefEdit control to select the range using the mouse. To bring up the UserForm run the macro "Run" using the Macro Dialog box (ALT+F8).

Sincerely,
Leith Ross

[desk.doc]

Leith, thank you for the example. Is the max you can show on the form 7x25? Or is this just an example? I don't need to view more on the userform, just asking a question. Your time and energy are more than greatly appreciated. Thank you.

[Leith Ross]

Hello Desk.Doc,

You could expand the size of the viewing area beyond 7 x 25 if you needed to or reduce it. It all depends on your program's needs , and of course the available space you have on the MultiPage control. I choose this size just as an example. If you have any questions about the code, or want to make changes, let me know.

Sincerely,
Leith Ross