I think it's a resounding--It depends...
But there is another option. Excel has Data|Form that might fit for you.
If that doesn't quite work, but it's close, John Walkenbach has an enhanced
dataform at:
http://j-walk.com/ss/dataform/index.htm
Brian C wrote:
I'm not sure if this would be beneficial, so I would need help to understand
whether a userform is better than a spreadsheet for allowing individuals to
enter data, and then performing calculations and generating a results page.
Second, if the userform is the best way to go, is it difficult to covnert a
spreadsheet (with some YES/NO option buttons and a list box and lots of data
fields) to a userform without having to re-write alot of code? I'm using
Excel 2000.
Thanks.
--
Dave Peterson