Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 81
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using dropdowns Vineet Excel Discussion (Misc queries) 1 January 9th 07 07:46 PM
DropDowns Dharsh Excel Discussion (Misc queries) 2 April 28th 05 12:34 PM
Dropdowns Carl Hilton Excel Discussion (Misc queries) 1 March 11th 05 05:15 PM
Too Many Dropdowns??? Rick Excel Programming 0 September 11th 04 06:19 PM
Dropdowns Terry von Gease Excel Programming 3 October 23rd 03 06:09 PM


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"