Connecting a form to an Excel workbook...
 

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.

Connecting a form to an Excel workbook...
 

Hi Mr Smiley,

See Debra Dalgleish's tutorial on creating a userform at:

http://www.contextures.com/xlUserForm01.html


---
Regards,
Norman



"Mr. Smiley" wrote in message
...
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.

Connecting a form to an Excel workbook...
 

Excel has userforms, goto the VBIDE (Alt-F11), and insert one
(InsertUserfrom)

Use the workbook open event to launch the form.

--

HTH

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


"Mr. Smiley" wrote in message
...
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.