Opening in Form View

[Guest]

Can an Excel form be opened in form view instead of spreadsheet view? I'd
like clients to open Excel and immediately see the form which they will fill
out and that data collated into a spreadsheet. XP 2003 Excel software.
Thanks in advance.

 

[Dave Peterson]

The userform needs excel--it's not a standalone program.

But you could show the userform as soon as you open your workbook:

Option Explicit
sub auto_open()
userform1.show
end sub