User Input Form

[Guest]

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.

 

[Tom Ogilvy]

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/d...eovroffice2000visualbasicprogrammersguide.asp

--
Regards,
Tom Ogilvy

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.

 

[Beth]

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
url=/library/en-
us/odeopg/html/deovroffice2000visualbasicprogrammersguide.a
sp

--
Regards,
Tom Ogilvy



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.


.