Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Hi I would like to know if anyone can direct me to a site that will teach me
how to create a fairly basic User Form in Excel. I can get into VB Editor and create the form - put in graphics, option buttons, check boxes but I don't know where to go after that to link to the spreadsheet itself. I have no VB experience. I am looking for a simple exercise that will take me through the steps to setting up a simple enough form. Many thanks Ann -- Kind regards Ann Shaw |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Ann,
This should help... http://www.contextures.on.ca/xlUserForm01.html -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Annie" wrote in message Hi I would like to know if anyone can direct me to a site that will teach me how to create a fairly basic User Form in Excel. I can get into VB Editor and create the form - put in graphics, option buttons, check boxes but I don't know where to go after that to link to the spreadsheet itself. I have no VB experience. I am looking for a simple exercise that will take me through the steps to setting up a simple enough form. Many thanks Ann -- Kind regards Ann Shaw |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
On Feb 22, 10:38 am, Annie wrote:
Hi I would like to know if anyone can direct me to a site that will teach me Hi Don't know about a website but "Excel VBA for Dummies" by John Walkenbach is very good, clear and well paced on basic userforms. regards Paul how to create a fairly basic User Form in Excel. I can get into VB Editor and create the form - put in graphics, option buttons, check boxes but I don't know where to go after that to link to the spreadsheet itself. I have no VB experience. I am looking for a simple exercise that will take me through the steps to setting up a simple enough form. Many thanks Ann -- Kind regards Ann Shaw |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Thanks Paul -fellow Tallaght person
I'm in Ashfield College, Templeogue. It's unusual to hear from someone in this neck of the woods!! Ann -- Kind regards Ann Shaw " wrote: On Feb 22, 10:38 am, Annie wrote: Hi I would like to know if anyone can direct me to a site that will teach me Hi Don't know about a website but "Excel VBA for Dummies" by John Walkenbach is very good, clear and well paced on basic userforms. regards Paul how to create a fairly basic User Form in Excel. I can get into VB Editor and create the form - put in graphics, option buttons, check boxes but I don't know where to go after that to link to the spreadsheet itself. I have no VB experience. I am looking for a simple exercise that will take me through the steps to setting up a simple enough form. Many thanks Ann -- Kind regards Ann Shaw |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Form
Here are some additional sources of information:
http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/?id=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 File Name: WE1163.EXE File Size: 161742 bytes File Date: 05/08/97 Keywords: kbfile Description: This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- Regards, Tom Ogilvy "Annie" wrote: Thanks Paul -fellow Tallaght person I'm in Ashfield College, Templeogue. It's unusual to hear from someone in this neck of the woods!! Ann -- Kind regards Ann Shaw " wrote: On Feb 22, 10:38 am, Annie wrote: Hi I would like to know if anyone can direct me to a site that will teach me Hi Don't know about a website but "Excel VBA for Dummies" by John Walkenbach is very good, clear and well paced on basic userforms. regards Paul how to create a fairly basic User Form in Excel. I can get into VB Editor and create the form - put in graphics, option buttons, check boxes but I don't know where to go after that to link to the spreadsheet itself. I have no VB experience. I am looking for a simple exercise that will take me through the steps to setting up a simple enough form. Many thanks Ann -- Kind regards Ann Shaw |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
How to show User Form when form name is in string? | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |