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

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

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

Hi Leath -

Thanks so much for your suggestion to help! I will certainly take you up on
it.

Although I tried to explain the project via my little informal diagram, I'm
afraid when it posted, instead of the entire rows ending up across the
screen, they wrapped to the next line.

This is not a project involving customer name, address, etc. It is rather a
work plan for the coming year and, if done on a typewriter in the days of
old, it would have been done in an outline form (vertically), complete with
flowery, lengthy paragraphs.

Perhaps I am thinking of it incorrectly, but I don't think I can just group
according to category, other than the first category. Let me know your
thoughts.

These people are used to working across the rows. There are about 30
computer "non-users." (They think Excel is too hard.) Additionally, things
beneath a major category row are dependent on the row above. I'll try to
diagram it again using "Txt" to designate the paragraph blurbs. There are
five categories that exist in the first column, which I will refer to as
Cat1, Cat2 etc. Instead of listing all nine titles across the top, I'll just
list five and refer to them as Col1, etc. Here goes --

A B C D E
1 Col1 Col2 Col3 Col4 Col5
2 Cat1 txt txt txt txt
3 - txt txt txt txt
4 - - txt txt txt
5 - - - txt txt
6 - - - - txt
7 Cat2 txt txt txt txt
8 - txt txt txt txt
9 - - txt txt txt
10 - - - txt txt
11 - - - - txt
12 Cat3 txt txt txt txt

Each of the dashes represent a blank cell. I originally put it into a form
that went from Row 1 to Row 2 to Row 3, etc. That left a lot of blanks and
would not show what category someone was under, or for that matter what line
they were on in each particular category.

Do you know how to dynamically add the text of Cat1, Cat2, Cat3, Cat4 and
Cat5 to the MultiPage control tabs (consisting of five pages)?

Is there a way to nest the MultiPage control and dynamically add the text
blurbs so people can know what blurb they are under?

There's one additional problem with this document -- certain people can only
see certain rows. I think I have the security issue solved, but that's
another reason why it has to be completely dynamic.

To sum it up, I need to know how to dynamically add the text in a column to
the tab (which may not work either because some of the blurbs may be too
lengthy, but I thought I would give it a try -- maybe there's some way of
truncating the text, just so the user has an idea of where they're at).

Thanks again for your offer to help!
--
Sandy


"Leith Ross" wrote:


Hello Sandy,

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

This can help reduce the number of Textboxes you currently have on the
form. The code can be written to direct the data to the correct record
or field once the data is entered, rather than having one Textbox per
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 ComboBox
and the MultiPage. They are both very easy to use and offer lots of
programming options.

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

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