Solved

Automating as estimate

Posted on 2011-03-09
7
224 Views
Last Modified: 2012-05-11
Experts,
Here's my objective:
Using a command button(s) automate an estimated calculation based on exisitng data and undo without using the Undo button. I am willing to break this into as many individual questions as needed, I just need your help in moving to another questions.

Using a command button(s) so that when the user clicks, a function is called to create the estimate then adding the estimate to another cell. If the user elects not to accept the estimate, have another command button that reverses the first action.

I know how to create a command button but macro drive or Active X? I will need help I creating the functions.
0
Comment
Question by:Frank Freese
  • 4
  • 2
7 Comments
 
LVL 24

Expert Comment

by:StephenJR
ID: 35088701
Store the value of the cell before clicking the button and then you can decide whether to add the estimate or restore the original. Hard to be precise without knowing anything about what you are actually doing.
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35089728
Using an Active X button you can do something like this

Try it in the attached file

cheers,
Curt
Estimator.xls
0
 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35089794
This example may be a bit better

Curt
Estimator-2.xls
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 18

Expert Comment

by:Curt Lindstrom
ID: 35089834
This example has one Active X control button and one Form control button. Both buttons are calling the same macro in module 1. The difference is that the Active X control button is using a "Click" macro which is stored in the Sheet1 module to call the macro.

Cheers,
Curt
Estimator-3.xls
0
 
LVL 18

Accepted Solution

by:
Curt Lindstrom earned 500 total points
ID: 35089899
With Undo button added

Cheers,
Curt
Estimator-4.xls
0
 

Author Comment

by:Frank Freese
ID: 35090736
thanks - I'm eye sore so will look at in detail tomorrow
0
 

Author Closing Comment

by:Frank Freese
ID: 35095250
looks like it answered a lot of my questions - good job and thank you
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now