Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with saving user input in an Excel Form. | Excel Discussion (Misc queries) | |||
User Form/Input box problem | Excel Programming | |||
create a user input form | Excel Programming | |||
Detecting Input Change on User Form | Excel Programming | |||
Help with a User Input Form | Excel Programming |