What exactly is the difference between the Control buttons and the Form
buttons? I know the Controls work off of events, so does that mean my code
has to be within the Sheet, and not the Module?

I had code attached to a radiobutton in the Sheet, my boss wanted me to
remove it and place in Module, at which point the macro quit working.
Replacing it to the Sheet made it work again.

I'm thinking that the difference is being able to call the Controls
dynamically while the Forms must be physically activated? Or is it just less
than one way to skin a cat?

The big difference is that you can set properties with the controls from the
Control Tool Box whereas the Forms controls properties are pretty much fixed.
There is also a difference in how the code is attached. The Forms controls
usually give you an opportunity to attach an existing macro when you select
the control from the tool bar. The Tool Box controls allow you to right
click the control and develop the code after you have selected the control.
My personal preference is the Tool Box controls.

"Jon Crawford" wrote:

What exactly is the difference between the Control buttons and the Form
buttons? I know the Controls work off of events, so does that mean my code
has to be within the Sheet, and not the Module?

I had code attached to a radiobutton in the Sheet, my boss wanted me to
remove it and place in Module, at which point the macro quit working.
Replacing it to the Sheet made it work again.

I'm thinking that the difference is being able to call the Controls
dynamically while the Forms must be physically activated? Or is it just less
than one way to skin a cat?