|
creation of data input window in excel
How would I go about setting up a pop up window, customized for specific data
input, & linked to one or more worksheets? |
creation of data input window in excel
what is your starting point, ie how much vba do you know or have used
before? basically in the VBE window you need to insert a userform into your workbook, put the controls on it that you want and then program the OK button to post the data where you want it. i don't know of any on-line tutorials for this ... but if you have specific questions just post back Cheers JulieD "revrenddan" wrote in message ... How would I go about setting up a pop up window, customized for specific data input, & linked to one or more worksheets? |
creation of data input window in excel
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 http://support.microsoft.com/support.../Q157/3/13.asp XL97: Unable to Show UserForms in Other Projects 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 Here are some other sources of information: 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/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://support.microsoft.com/default...b;en-us;829070 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 http://www.bmsltd.ie/Excel/Default.htm http://maths.sci.shu.ac.uk/units/ioa/ <- Excel VBA tutorial http://support.microsoft.com/default...;EN-US;Q168067 Regards, Tom Ogilvy "JulieD" wrote in message ... what is your starting point, ie how much vba do you know or have used before? basically in the VBE window you need to insert a userform into your workbook, put the controls on it that you want and then program the OK button to post the data where you want it. i don't know of any on-line tutorials for this ... but if you have specific questions just post back Cheers JulieD "revrenddan" wrote in message ... How would I go about setting up a pop up window, customized for specific data input, & linked to one or more worksheets? |
creation of data input window in excel
just one or two then ? :)
"Tom Ogilvy" wrote in message ... 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 http://support.microsoft.com/support.../Q157/3/13.asp XL97: Unable to Show UserForms in Other Projects 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 Here are some other sources of information: 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/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel http://support.microsoft.com/default...b;en-us;829070 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 http://www.bmsltd.ie/Excel/Default.htm http://maths.sci.shu.ac.uk/units/ioa/ <- Excel VBA tutorial http://support.microsoft.com/default...;EN-US;Q168067 Regards, Tom Ogilvy "JulieD" wrote in message ... what is your starting point, ie how much vba do you know or have used before? basically in the VBE window you need to insert a userform into your workbook, put the controls on it that you want and then program the OK button to post the data where you want it. i don't know of any on-line tutorials for this ... but if you have specific questions just post back Cheers JulieD "revrenddan" wrote in message ... How would I go about setting up a pop up window, customized for specific data input, & linked to one or more worksheets? |
| All times are GMT +1. The time now is 10:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com