I have an excel spreadsheet that uses macros and then exports info into
a csv file. How can I do this via a form instead of a spreadsheet as
the user interface of a spreadsheet looks messy.

Thanks.

Does the data have to be visible?

If not then you could do all the manipulation on a hidden sheet (or a sheet
that is not the active sheet) and inform the user about the progress of it
all
via the Excel statusbar.

If the data has to be visible then you could maybe use a listbox or a
listview
on a userform.

RBS

wrote in message
oups.com...
I have an excel spreadsheet that uses macros and then exports info into
a csv file. How can I do this via a form instead of a spreadsheet as
the user interface of a spreadsheet looks messy.

Thanks.