Form Control versus Active Control? When to use which?

[LightLY]

Dear Excel experts,

I am starting to use Excel 2010 VBA. I am confused over form control
and active controls. It seems they are quite similar. May I know under
what situation should one use form control or active control?

My understanding based on what I have read and tried is that when one
needs to write VBA code, use active control. Other than that, use form
control. Is this correct?

Thank you.

 

[Jim Cone]

Form controls are less complicated (fewer options) and have less overhead (memory requirements).
If form controls do the job and meet your needs they should be your first choice.
Both types of controls can be manipulated using VBA.

On the other hand, each successive release of XL has its unique features (problems).
Buttons of one type or the other can disappear, resize, move or act erratically depending
on how/when they are used, their settings and the Excel version.
Some of these issues belong to Microsoft and some to the user - cut and try sometimes is necessary.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)





"LightLY" <[email protected]>
wrote in message
news:b7ba6f90-6c2b-4db1-b177-d49a32354beb@v29g2000yqv.googlegroups.com...