View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default 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.