ActiveX or Forms Controls in Excel?

[TheRobster]

Is there any real difference between the ActiveX and Forms controls in Excel? (I'm using Excel 97).

ActiveX seems to have a few more controls (e.g. textbox) plus a large list of other things that you could use if you want. They also seem to have their VBA code embedded in the worksheet they are placed on, whereas Forms controls can have their code anywhere in the application...........is this right?

I am assuming that ActiveX controls are better as they seem more flexible and VBA-orientated whereas Forms seems like a simpler soluton for things like button clicks.

Anyone got a view on this?

Cheers
-Rob

[BrianB]

ActiveX controls are not good in worksheets because they obviously contain bugs. They might work at the time but give problems later on - often fatal ones that result in a corrupted or non-openable file.

That said, you might get away with a few controls on a sheet.

The principle of this is simple. The ActiveX controls have more features - so more prone to errors.

[TheRobster]

So you'd recommend staying away from the ActiveX Controls and just using Forms wherever possible?