You are here: HomeExcelTutorials
Facebook Twitter Reddit More...

How do I set a goalseek value via an input box using vba macro

How do I set a goalseek value via an input box using vba macro

Price: FREE

= Range("J22").GoalSeek Goal:=myNum = Application.InputBox("Enter a number"), ChangingCell:=Range("C5")
The input box will fire up but will not use the input value as the value in the goal seek calc.

Visit publisher's web-site: How do I set a goalseek value via an input box using vba macro

Category and Tags: ExcelTutorials : : Functions

Related Tutorials

Goalseek gives incorrect results

Free: Yes
Tags: Excel ›

Using =PMT formula, I input B1=pmt(14.5%/12,60,A1) and in GoalSeek, I set
cell B1 to 500 by changing cell A1 and I get 212,510.21 as the result
whereas simply seen 500 in one year would be 60K and in 5 years it would be 300K. For small values it provides proper results but not for this one. What
wrong am I doing?

Macro Does not Work on Button

Free: Yes
Tags: Excel ›

I have recorded a GoalSeek macro in Excel 97 SR2, which works when called from the Tools | Macro menu, but when I call it from a button on the spreadsheet then the macro fails in the GoalSeek command.
My macro is . . .
Sub BalancePC()
' BalancePC Macro
' Macro recorded 24/03/2009 by Alan G Lloyd
Worksheets("Financial Statement").Range("M37").GoalSeek _
Goal:=0, _
ChangingCell:=Worksheets("Financial Statement").Range("I25")

Goalseek macro

Free: Yes
Tags: Excel › VBA

I am trying to write a macro where when I click the button the macro is attached to, is copies cell C22, paste the value in D22, and then when I do the goal seek, I want it to take the value in D22 as the goal, rather than the 4500 as shown below. Please help! Thanks
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Range("G22").GoalSeek Goal:=4500, ChangingCell:=Range("G17")

User Input Box, Multiple Entries

Free: Yes
Tags: Excel › VBA

I am writing a Macro and I would like to add a user input box where it could have multiple places where the user can input.
The Input box will ask the user for Name, Last Name, Company name, start date. etc.
How can I have an input box where all of these can be asked at the same time?

Using VBA to Create Input Box with Browse Button

Free: Yes
Tags: Excel ›

I am using VBA to input data from csv datafile. Currently, I have to use the InputBox function and type in the name of the file I want to use. Because typos are abundant (at least with me), I would like to use a box that allows me to browse the files on my hard drive. I see the box when I select "Start" and "Run" in windows, so I know it can be done, but I can't find it in VBA help. Anybody have

Related Applications & Scripts

Pickled: Display Dynamic Form Data

Free: No

Do you have an input box, where you would like to help your user type in some data? Pickled can help you, in an unobtrusive way!
By default pickled is designed to display a floating select box underneath the input box is was added on. The default data is the 24h time of day (00:00, 00:30, 01:00 etc).

search input component

Free: No
Tags: Flash › Excel Flex Forms

This component allows you to add a search input text in your applications. Input change events are dispatched so you can implement your own searching methods. Border and text input can be easily skinned with a flex css stylesheet (see preview for some examples).

My Latest Tweets! - A Pure Javascript Twitter Box

Free: No
Tags: JavaScript › Excel Twitter

My Latest Tweets is a simple and easy customizable Pure Javascript Twitter display. No PHP needed! With My Latest Tweets you can:
Display tweets from a specified user;
Display tweets with a specified #hashtag;
Display tweets with a specified word or sentence;
Set the number of tweets in your box;
Set the language of tweets;
Very easy and simple CSS , customize your box in minutes.

Digital Numeric Counter

Free: No
Tags: Flash › Excel Date and Time

Usage: Click the Start button to start the counting down (one step each second) Click the Pause button to pause the counting down. Click the Pause button again to resume the counting down.
Type in the number in the starting number input box for the number to start.
Type in the number in the ending number input box for the number to end.

Smart XML Combo Box - Drop Down

Free: No
Tags: Flash › Excel Drop Down Menus

XML driven slider component. Suitable for contact forms, quizzes,...
- Width of the slider can be set in xml
- Colors are set in XML file
- Slider returns id and value on built in events
- Very easy to customize
- All data editable through XML is well documented

© 2014 Contact us - Privacy Policy - Terms of use - Add Listing