Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too Many Dropdowns???
Hi Rick,
Just curiosity, apart from the controls do you have a lot of code in your Form module. There are reports in this NG of potential problems with over 64Kb. Regards, Peter -----Original Message----- Hi, I've created a 8 page multipage control with a total of 15 dropdowns on one form to utilize a database that I've created. It is working OK at this point, but now when I add more controls it will not recognize them. To further explain.... After you create the additional dropdown on the multipage control, you double click this dropdown (in the design mode) and it will not start a sub- endsub for you in the code module. Also when I try to add items to this dropdown control with some other code (when I show the form), it says that the dropdown cannot be located ("Method or data member not found."). I'm using WinXP and Office2000. Is it a physical limitation of Excel? It is a memory problem? I have 512mb of RAM with a P4 processor. I also experimented by adding another command button on the multipage control with the same result - Excel will not recognize it. Again, everything is working OK until I add more controls. I appreciate your response with this. Thanks, Rick . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using dropdowns | Excel Discussion (Misc queries) | |||
DropDowns | Excel Discussion (Misc queries) | |||
Dropdowns | Excel Discussion (Misc queries) | |||
Too Many Dropdowns??? | Excel Programming | |||
Dropdowns | Excel Programming |