Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Too Many Dropdowns???
Thanks Harald,
I think so far I have only about 50 of these controls on my form. For some reason, at home this Saturday morning with a PIII processor and 786mb of RAM, I don't have the same limitation that I have at work with the Excel/VBA program (with a faster processor and less memory). It must be some unknown software/hardware issue. I'm in the process of transferring it all to VB6 this morning, and all seems to be working well, after working out some of the Excel VBA and VB6 differences. Thanks for the information about the 256 control limitations with VB6, but hopefully that won't be an issue. You are right in that if in one way it doesn't work, then it's time to think of another way...with back or next buttons etc. There are creative ways to reduce the number of these controls...things we think about after we finish writing the "first-time" program. I'm not sure what you meant by saying "...but there are no multipages (you can not redistribute MSforms and even referencing it is not recommended from Microsoft." I did have initial troubles with the VB6 multipage control, so I'm using the Microsoft Tabbed Dialog Control 6.0 that you can find under the Project Components. After I get it all to work, then I'll look more at what possibly when wrong with the VB6 multipage control. Thanks, Rick -----Original Message----- Hi Rick VB6 has a very distinct limitation of 255 (256 ?) controls on each form. With workarounds like control arrays and user controls, but there are no multipages (you can not redistribute MSforms and even referencing it is not recommended from Microsoft). But really; which user interaction would require more than 30 intelligent controls simoultaneously ? I urge you to think this through one more time. Think for example "wizard" with Back / Next buttons, and also that this will be operated by people like [insert name or position of ignorant member of family here] most of the time. Best wishes Harald "Rick" skrev i melding ... Harald, Thanks for the reply. To further add dropdowns or other controls, I have found this afternoon that I have to delete other controls on the form. This allows me to do what I need to do, to continue with my efforts using this database with different dropdowns. So I started with the obvious. I deleted two of the multipage pages, after consolidating some of the other dropdown boxes together with others. I'll try this on a computer at home too, and see if that makes a difference. Plus I'll see what will happen if I place all of this on VB6, and run the Excel program from there. I was planning to do that anyway on VB6, once I finished with my prototype programming design using Excel VBA. I had never just ran into this type of a limitation. There seems to always be something.... Thanks, Rick . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Dropdowns | Excel Discussion (Misc queries) | |||
using dropdowns | Excel Discussion (Misc queries) | |||
DropDowns | Excel Discussion (Misc queries) | |||
Dropdowns | Excel Discussion (Misc queries) | |||
Dropdowns | Excel Programming |