Form or VBA controls

[Annie]

I have been working on an Excel workbooks for about a year and have just thought to notice that
there are two different types of controls that you can place on a worksheet - Form controls and
VBA(?) controls. Is there any reason to chose one over the other?

TIA,

Annie

 

[Earl Kiosterud]

Annie,

The controls from the Forms toolbar are fairly simple, and for most, their
only result is to change a cell. They have fairly limited flexibility,
pretty much all of which is accessible via the Format command. Those from
the Controls toolbox are ActiveX controls. They have lots of properties you
can change (the linked cell, etc.), and can have "code behind" them. That
means they can run your macro code when they're used, giving them
programmability.

 

[Dave Hawley]

Hi Annie

I think this link will help
http://www.ozgrid.com/Excel/Excel-controls-forms-toolbox.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****