F3 function key in maintaining Controls (Excel 2000)

[HansV]

For data entry with complex validation, a userform is indeed preferable.

But if you want tojust want to add a few check boxes or option buttons to a worksheet, without needing VBA code, controls from the Forms toolbar are very handy.
And a scroll bar on top of a chart can be a good way to let the user modify chart parameters.

[Jan Karel Pieterse]

Hi Chris,

I see. Well, as Hans said already: if the data entry is complex, a userform may be the best way to handle it.

[ChrisGreaves]

And a scroll bar on top of a chart can be a good way to let the user modify chart parameters.

(but not as good as the last 13 videos here, eh?

[VegasNath]

Hi Chris,

As Hans said, I was referring to the controls you can put on your worksheet, which are devided in two camps: the form controls and the control toolbox controls, AKA ActiveX controls. The Form controls have my preference.

Here here! I find the activeX control toolbox controls a nightmare to work with. I much prefer the Forms toolbar.