User Input Form
 

I have got a forecast that has data entered into it monthly, and due to the size of it, I'd like to be able to provide an input form. I have another file set up this way that someone else created, but I can't reverse engineer it as it is all protected and has hidden worksheets (rats!). What I'm trying to accomplish is to A) set up a custom toolbar with only Input, Save, Print Preview, and Print available; and B) establish pop-up boxes that will allow entries for the quantities of parts received, parts shipped, and the value of the parts shipped. Ideally, I'd like it to be like an Access Form, but linked to the correct cells in my Excel file to populate them monthly with the user input. This would also be a great way to prevent users from accidentally ruining my formulae. Any advice would be much appreciated.

User Input Form
 

The below two articles give you all the basics:

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

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


http://support.microsoft.com/?id=166755
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items


http://msdn.microsoft.com/library/de...mmersguide.asp

--
Regards,
Tom Ogilvy



"Beth" wrote in message
...
I have got a forecast that has data entered into it monthly, and due to
the size of it, I'd like to be able to provide an input form. I have another
file set up this way that someone else created, but I can't reverse engineer
it as it is all protected and has hidden worksheets (rats!). What I'm trying
to accomplish is to A) set up a custom toolbar with only Input, Save, Print
Preview, and Print available; and B) establish pop-up boxes that will allow
entries for the quantities of parts received, parts shipped, and the value
of the parts shipped. Ideally, I'd like it to be like an Access Form, but
linked to the correct cells in my Excel file to populate them monthly with
the user input. This would also be a great way to prevent users from
accidentally ruining my formulae. Any advice would be much appreciated.

User Input Form
 

Thank you Tom - will check those out.
-----Original Message-----
The below two articles give you all the basics:

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling
UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples
for Controlling
UserForms in Microsoft Excel 97

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


http://support.microsoft.com/?id=166755
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu
Items


http://msdn.microsoft.com/library/default.asp?
url=/library/en-
us/odeopg/html/deovroffice2000visualbasicprogrammersguide.a
sp

--
Regards,
Tom Ogilvy



"Beth" wrote in
message
...
I have got a forecast that has data entered into it
monthly, and due to
the size of it, I'd like to be able to provide an input
form. I have another
file set up this way that someone else created, but I
can't reverse engineer
it as it is all protected and has hidden worksheets
(rats!). What I'm trying
to accomplish is to A) set up a custom toolbar with only
Input, Save, Print
Preview, and Print available; and B) establish pop-up
boxes that will allow
entries for the quantities of parts received, parts
shipped, and the value
of the parts shipped. Ideally, I'd like it to be like an
Access Form, but
linked to the correct cells in my Excel file to populate
them monthly with
the user input. This would also be a great way to prevent
users from
accidentally ruining my formulae. Any advice would be
much appreciated.


.