Which is better for a search form - a popup User Form or a standard Worksheet?

[stubarny]

Hello,

I'm an intermediate VBA developer and am working with some legacy code that uses User Forms (the kind that pops up).

I feel the User Forms effectively double the amount of VBA knowledge I need (and any successors) whilst not really adding any functionality when compared to entering data to a worksheet. I also find it very hard to error-check the VBA code that creates the form (when running in break mode the VBA window seems to only run through the VBA code that creates the form after a button on the loaded User Form had been pressed - very strange).

I was wondering what the opinion of experienced VBA programmers is on User Forms? Is it better to create a 'userform' on a worksheet and then just call a procedure that activates the worksheet whenever the userform is needed? (especially as a worksheet can be formatted in a much more user friendly format than a pop-up User Form)

Thanks for your opinions on this

Stu