Form or VBA controls

  • Thread starter Thread starter Annie
  • Start date Start date
A

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
 
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.
 
Back
Top