Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel: Use a name with external workbook reference for data valida | Excel Worksheet Functions | |||
Automate Excel to powerpoint - Graphs along with Datasheet (not workbook) | Charts and Charting in Excel |