Connecting a form to an Excel workbook...

M

Mr. Smiley

I was wondering if it is even possible to create a form similar to the ones
used in Access, but have it connected to an Excel workbook. Basically, I
want to create a tool that, once the icon is clicked on a users desktop, will
bring up a form. The user will enter all necessary information, then press a
button for the desired results. Is this possible? Thanks.
 
B

Bob Phillips

Excel has userforms, goto the VBIDE (Alt-F11), and insert one
(Insert>Userfrom)

Use the workbook open event to launch the form.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top