SubGoal_Seek2()DimA As LongDimFinalAvgAsRangeDimReferenceAsRangeDimTargetAs IntegerTarget = 50ForA = 3To7SetFinalAvg = Cells(9, A)SetReference = Cells(7, A)NextAEnd Sub Step 10:At last, apply the VBA Goal Seek with proper syntax as shown below. Code: SubGoal_Seek2()DimA As LongD...
Excel VBA Course - From Beginner to Expert 200+ Video Lessons 50+ Hours of Video 200+ Excel Guides Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.) ...
{"__ref":"ForumReplyMessage:message:4119608"},"subject":"Re: Combining the power of goal seek and scenario analysis in a VBA Userform","moderationData":{"__ref":"ModerationData:moderation_data:4119870"},"body":"The Exit event does not allow set...
We have a dataset that contains the names of some projects in the rangeB7:B15and the hours required to finish those projects in the rangeC7:C15. We will input the project’s progress in cellG7. The code will use Goal Seek to assign the same value in the rangeD7:D15. The VBA code...
I have used "genetik201" with some success for this, although I have now written my own. Cheers Greg Locock Upvote 0 Downvote Aug 9, 2003 #6 dsi Mechanical Jul 20, 2000 574 Jkaen, If you want to try a VBA routine, give me some specs (cell numbers) and I can ...
MacroShowVba MailLogoff MailLogon MailOpen MailPostDocument MailProjectMailCustomize MailRoutingSlip MailSend MailSendProjectMail MailSendScheduleNote MailSession MailSystem MailUpdateProject MakeFieldEnterprise MakeLocalCalendarEnterprise ManageSiteColumns MapEdit MenuBarApply MenuBarEdit MenuBars Message N...
{"__ref":"Forum:board:ExcelGeneral"},"subject":"Re: Combining the power of goal seek and scenario analysis in a VBA Userform","readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:4121480"},"parent":{"__ref":"AcceptedSolutionMessage...
I’m building a userform (and a module) for a more flexible Goal Seek. I’ve had recurring uses for something like this at work, where I need Goal Seek’s functionality mixed in with some “what if analy... JKPieterseThat's unfortunate. I've given up on locking the ...
I’m building a userform (and a module) for a more flexible Goal Seek. I’ve had recurring uses for something like this at work, where I need Goal Seek’s functionality mixed in with some “what if analysis” sensitivity table power. ...