Convert Worksheet to Userform

[Guest]

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]

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