LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with saving user input in an Excel Form. University of Maine student Excel Discussion (Misc queries) 0 March 14th 06 07:31 PM
User Form/Input box problem Peter[_39_] Excel Programming 1 April 21st 04 10:37 PM
create a user input form Travis Excel Programming 2 January 6th 04 04:13 PM
Detecting Input Change on User Form Don Wiss Excel Programming 3 December 2nd 03 02:09 AM
Help with a User Input Form Cody Dawg[_2_] Excel Programming 3 October 9th 03 10:08 PM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"