How would I go about setting up a pop up window, customized for specific data
input, & linked to one or more worksheets?

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?

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?

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?