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.
.
|