excel survey...activeX or UserForm

[ironj32]

I am creating a survey that is going to be emailed out to many people and am wondering if i should be using ActiveX controls or UserForm controls. The survey is going to consist of many input text boxes, options buttons, and check boxes. I would like some text boxes enabled/required/locked based upon previous option button selections. I also would like to use a submit button to automatically email me back the survey once they have completed it. Any advice on what i should be using is greatly appreciated. Thanks!

 

[RonRepp]

iron32:

If you are going to be using Excel as the output, then use a User Form.

You can do virtually anything within a UserForm that you can do in VB 6 form (which would make your ActiveX), but remember that the more memory it takes, the longer it will take to open, close, compute...

I hope this helps.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[fumei]

I would second that. I think a Userform is easier to set up and maintain validation logic, ie. textboxes, option buttons et al. Just my opinion. I find them easier to design the layout as well.

Gerry
My paintings and sculpture