How do I set a goalseek value via an input box using vba macro
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?
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 . . .
' BalancePC Macro
' Macro recorded 24/03/2009 by Alan G Lloyd
Worksheets("Financial Statement").Range("M37").GoalSeek _
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:= _
Application.CutCopyMode = False
Range("G22").GoalSeek Goal:=4500, ChangingCell:=Range("G17")
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?
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
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).
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).
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.
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.
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