User Form

[Annie]

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

 

[Jim Cone]

Ann,
This should help...
http://www.contextures.on.ca/xlUserForm01.html

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Annie" <[email protected]>
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

 

[paul.robinson]

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

 

[Annie]

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

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

 

[Tom Ogilvy]

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/09/linking_userfor.html

http://support.microsoft.com/default.aspx?scid=kb;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-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp

--
Regards,
Tom Ogilvy

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