Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! -- goober ------------------------------------------------------------------------ goober's Profile: http://www.excelforum.com/member.php...o&userid=19838 View this thread: http://www.excelforum.com/showthread...hreadid=486491 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick, general userform question
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
General question | Excel Worksheet Functions | |||
A VERY General question | Excel Worksheet Functions | |||
Quick question - quick answer about assigning shortcut keys | Excel Programming | |||
Quick userform question. | Excel Programming | |||
Userform Comboboxes - need a quick how to.. | Excel Programming |