Quick, general userform question

[VB Newbie]

Is there a limit to the number of userforms one can create in an Excel
workbook? If it matters, I use Excel 2000. Thank you kindly!

[goober]

The number of worksheets you can have in a workbook is limited only by the ammount of available memory that your computer has.


Is there a limit to the number of userforms one can create in an Excel
workbook? If it matters, I use Excel 2000. Thank you kindly!

[JNW]

I don't think there is a limit, but the more userforms you have the bigger
the file gets. And generally, the bigger the file the slower it gets.

"VB Newbie" wrote:

> Is there a limit to the number of userforms one can create in an Excel
> workbook? If it matters, I use Excel 2000. Thank you kindly!

[VB Newbie]

Thanks for the help. Here is the situation. The computers have 128MB at
work, but the userforms, which will total about 50-60, that I will be
creating are very small, with only 4 textboxes for entry and a command
button. Do you sense any problems with that? Thank you again!

"JNW" wrote:

> I don't think there is a limit, but the more userforms you have the bigger
> the file gets. And generally, the bigger the file the slower it gets.
>
> "VB Newbie" wrote:
>
> > Is there a limit to the number of userforms one can create in an Excel
> > workbook? If it matters, I use Excel 2000. Thank you kindly!

[JNW]

128 is pushing it, especially if the computer is running XP.

If your userforms are really that simple, you could make one and have it be
used for all your forms. That would save a lot of room.

JNW

"VB Newbie" wrote:

> Thanks for the help. Here is the situation. The computers have 128MB at
> work, but the userforms, which will total about 50-60, that I will be
> creating are very small, with only 4 textboxes for entry and a command
> button. Do you sense any problems with that? Thank you again!
>
> "JNW" wrote:
>
> > I don't think there is a limit, but the more userforms you have the bigger
> > the file gets. And generally, the bigger the file the slower it gets.
> >
> > "VB Newbie" wrote:
> >
> > > Is there a limit to the number of userforms one can create in an Excel
> > > workbook? If it matters, I use Excel 2000. Thank you kindly!

[VB Newbie]

Dear JNW or anyone who would like to assist-

I think I can reduce the number of userforms by 75-80%, however I can't find
a quick fix to my issue. Here is what I have thus far.

Userform1 with 4 optionbuttons.
Userform2 with 2 textboxes and a commandbutton.

Each optionbutton will open up Userform2. If optionbutton1 is selected, I
want the textboxes to place their values in A1 and A2, OB2 to B1 and B2, OB3
to C1 and C2, and OB4 to D1 and D2 using commandbutton1.

Is this feasible using scripts in Userform2 or do I need to set up
individual scripts for each optionbutton?

Any help would be greatly appreciated!!
"JNW" wrote:

> 128 is pushing it, especially if the computer is running XP.
>
> If your userforms are really that simple, you could make one and have it be
> used for all your forms. That would save a lot of room.
>
> JNW
>
> "VB Newbie" wrote:
>
> > Thanks for the help. Here is the situation. The computers have 128MB at
> > work, but the userforms, which will total about 50-60, that I will be
> > creating are very small, with only 4 textboxes for entry and a command
> > button. Do you sense any problems with that? Thank you again!
> >
> > "JNW" wrote:
> >
> > > I don't think there is a limit, but the more userforms you have the bigger
> > > the file gets. And generally, the bigger the file the slower it gets.
> > >
> > > "VB Newbie" wrote:
> > >
> > > > Is there a limit to the number of userforms one can create in an Excel
> > > > workbook? If it matters, I use Excel 2000. Thank you kindly!

[VB Newbie]

Problem fixed!

"VB Newbie" wrote:

> Dear JNW or anyone who would like to assist-
>
> I think I can reduce the number of userforms by 75-80%, however I can't find
> a quick fix to my issue. Here is what I have thus far.
>
> Userform1 with 4 optionbuttons.
> Userform2 with 2 textboxes and a commandbutton.
>
> Each optionbutton will open up Userform2. If optionbutton1 is selected, I
> want the textboxes to place their values in A1 and A2, OB2 to B1 and B2, OB3
> to C1 and C2, and OB4 to D1 and D2 using commandbutton1.
>
> Is this feasible using scripts in Userform2 or do I need to set up
> individual scripts for each optionbutton?
>
> Any help would be greatly appreciated!!
> "JNW" wrote:
>
> > 128 is pushing it, especially if the computer is running XP.
> >
> > If your userforms are really that simple, you could make one and have it be
> > used for all your forms. That would save a lot of room.
> >
> > JNW
> >
> > "VB Newbie" wrote:
> >
> > > Thanks for the help. Here is the situation. The computers have 128MB at
> > > work, but the userforms, which will total about 50-60, that I will be
> > > creating are very small, with only 4 textboxes for entry and a command
> > > button. Do you sense any problems with that? Thank you again!
> > >
> > > "JNW" wrote:
> > >
> > > > I don't think there is a limit, but the more userforms you have the bigger
> > > > the file gets. And generally, the bigger the file the slower it gets.
> > > >
> > > > "VB Newbie" wrote:
> > > >
> > > > > Is there a limit to the number of userforms one can create in an Excel
> > > > > workbook? If it matters, I use Excel 2000. Thank you kindly!