Hello -

I need more information on the multipage control to see if I want to use it
in my solution. I searched the web and was unable to come up with very much.
Can anyone point me in the right direction?

Any help will be greatly appreciated!
--
Sandy

Tools=Options

or

tools=customize

in Excel. Those are multipage type controls.

--
Regards,
Tom Ogilvy


"Sandy" wrote in message
...
Hello -

I need more information on the multipage control to see if I want to use
it
in my solution. I searched the web and was unable to come up with very
much.
Can anyone point me in the right direction?

Any help will be greatly appreciated!
--
Sandy

Hi Tom -

Thanks for your response. I meant the MultiPage control in the toolbox --
the one that has tabs at the top that you drag to the userform. (Sorry.)
--
Sandy


"Tom Ogilvy" wrote:

Tools=Options

or

tools=customize

in Excel. Those are multipage type controls.

--
Regards,
Tom Ogilvy


"Sandy" wrote in message
...
Hello -

I need more information on the multipage control to see if I want to use
it
in my solution. I searched the web and was unable to come up with very
much.
Can anyone point me in the right direction?

Any help will be greatly appreciated!
--
Sandy

Good evening Sandy

As much as I dislike attachments, a brief example will probably say far
more than I could in several lengthy boring paragraphs and give you the
gist of how to start controlling them.

Does that help you any more?

HTH

DominicB


+-------------------------------------------------------------------+
|Filename: Example1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4030 |
+-------------------------------------------------------------------+

--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=483819

Hi Dominic -

Thanks for your response. I tried the link and got the following message:

Invalid Attachment specified. If you followed a valid link, please
notify the webmaster.

Is that the right link you typed or is it a problem with the web site?

Sandy

--
Sandy


"dominicb" wrote:


Good evening Sandy

As much as I dislike attachments, a brief example will probably say far
more than I could in several lengthy boring paragraphs and give you the
gist of how to start controlling them.

Does that help you any more?

HTH

DominicB


+-------------------------------------------------------------------+
|Filename: Example1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4030 |
+-------------------------------------------------------------------+

--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=483819

Hello Sandy,

The Control Toolbox MultiPage control is quite versatile. Each pages
acts like a separate window. The controls on a Page are displayed only
when that Page is selected. The other nice feature is the values of the
controls are not lost when you switch Pages.

This is an ideal control to guide users by dividing your program tasks
into groups. Your program will be more user friendly by eliminating
window clutter and help speed up data entry and retrieval.

The MultiPage control can hold any control that is in the Control
toolBox. It's easy to format. You simply drag and drop a control on to
the Page, like you would with the UserForm. You can add pictures to the
background of each page if you want or simply change the background
color for more effect. The tabs can be positioned on Top (default) on
the Left, Right, or Bottom of the Control. If you have many Pages
(tabs) you can also display them in multiple rows.

Sincerely.
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=483819

Hi Leath -

Thank you for responding! Now for my next question - what about "nesting"
MultiPage controls?

My problem is I have a spreadsheet that is designed like this:
A B C D E F G
H I
1 Text1 Text2 Text3 Text4 Text5 Text6 Text7 Text8 Text9
2 - Text10 Text11 Text12 Text13 Text14 Text15 Text16 Text17

3 - - Text18 Text19 Text20 Text21 Text22 Text23
Text24
4 - - - Text25 Text26 Text27 Text28 Text29
Text30
5 - - - - Text31 Text32 Text33
Text34 Text35
6 - - - - - -
Text36 Text37 Text38
7 Text39 Text40 Etc.

[The hyphen "-" stands for blank]
When I set up a form with textboxes, the textboxes with the dash in them are
blank, making it virtually impossible for a user to know where on the
spreadsheet they are. I was thinking if I could nest MultiPage controls
somehow I may be able to overcome this obstacle. If they can be nested, is
there a limit to how many can be nested?

I tried using Access, but it got ridiculous with all of the subforms.

ANY help at all will be greatly apreciated!
--
Sandy


"Leith Ross" wrote:


Hello Sandy,

The Control Toolbox MultiPage control is quite versatile. Each pages
acts like a separate window. The controls on a Page are displayed only
when that Page is selected. The other nice feature is the values of the
controls are not lost when you switch Pages.

This is an ideal control to guide users by dividing your program tasks
into groups. Your program will be more user friendly by eliminating
window clutter and help speed up data entry and retrieval.

The MultiPage control can hold any control that is in the Control
toolBox. It's easy to format. You simply drag and drop a control on to
the Page, like you would with the UserForm. You can add pictures to the
background of each page if you want or simply change the background
color for more effect. The tabs can be positioned on Top (default) on
the Left, Right, or Bottom of the Control. If you have many Pages
(tabs) you can also display them in multiple rows.

Sincerely.
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=483819

Hello Sandy,

First thing is to separate the Textboxes into groups. For Example on
page of the MultiPage would be for Customer Names, the second page fo
address, third for products ordered, etc. Records can then be accesse
from the user's input.

This can help reduce the number of Textboxes you currently have on th
form. The code can be written to direct the data to the correct recor
or field once the data is entered, rather than having one Textbox pe
cell.

If you would like some help setting this up, I would be glad to help
My 2 favorite controls to use with databases and lists are the ComboBo
and the MultiPage. They are both very easy to use and offer lots o
programming options.

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48381

Yes, I realize that you were talking about the multipage control in the
toolbox. But you said:

I need more information on the multipage control to see if I want to use it
in my solution.

Which sounds like you are asking about the functionality of a multipage and
what it can be used for. Thus I provided some examples.

In any event, the word pictures provided by others offered little over
seeing the functionality and operational nature observable in the examples I
provided in my opinion.

--
Regards,
Tom Ogilvy




"Sandy" wrote in message
...
Hi Tom -

Thanks for your response. I meant the MultiPage control in the toolbox --
the one that has tabs at the top that you drag to the userform. (Sorry.)
--
Sandy


"Tom Ogilvy" wrote:

Tools=Options

or

tools=customize

in Excel. Those are multipage type controls.

--
Regards,
Tom Ogilvy


"Sandy" wrote in message
...
Hello -

I need more information on the multipage control to see if I want to
use
it
in my solution. I searched the web and was unable to come up with
very
much.
Can anyone point me in the right direction?

Any help will be greatly appreciated!
--
Sandy