View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tony_VBACoder Tony_VBACoder is offline
external usenet poster
 
Posts: 11
Default Controls Toolbox control vs Form Toolbox control

Oops...the size before is 600K, not 600MB. Sorry about that typo.

"Tony_VBACoder" wrote:

How come if I add a combo box from the "Controls Toolbox" rather than the
combo box from the "Forms Toolbox", the size of my Excel worksheet becomes
much larger. ie: I had a spreadsheet with 65 combo boxes from the "Forms
Toolbox" and the size was around 600MB, but if I change all those combo boxes
to the combo boxes in the "Control Toolbox", the size becomes just under 1MB.
I am getting the same functionality by using both types of controls, just a
little different code to reference the methods and properties, so I was
wondering why the increase in size.