<div>
Yes it is. &nbsp;I'm just trying to get an idea as to how to call that particular function in vba is all. &nbsp;Thanks
</div>


Yes it is.  I'm just trying to get an idea as to how to call that particular function in vba is all.  Thanks

<div>
Oh I forgot to mention. &nbsp;I'm going to store the outcome in a textbox so would it be Textbox1 = application.forecast([d7],<wbr /> [e3:e4], [e7:e8]) ? &nbsp;and how does it know to point to Sheet1 for this?
</div>


Oh I forgot to mention.  I'm going to store the outcome in a textbox so would it be Textbox1 = application.forecast([d7], [e3:e4], [e7:e8]) ?  and how does it know to point to Sheet1 for this?

<div>
Assuming you set a variable of type Worksheet...<br />
<br />
Textbox1 = application.forecast(ws.[d<wbr />7], ws.[e3:e4], ws.[e7:e8]) 
</div>


Assuming you set a variable of type Worksheet...

Textbox1 = application.forecast(ws.[d7], ws.[e3:e4], ws.[e7:e8])

<div>
<div class="content wysiwyg-content">
I would to use the FORECAST function in excel VBA. &nbsp;I have a spreadsheet called &quot;Sheet1&quot; that has the information I need. &nbsp;Forecast requires X, known_y's, known_x's &nbsp; So for X Sheet1 has cell D7 that contains this value. &nbsp;For known_y's Sheet1 has E3 to E4 for this. &nbsp;And known_x's has E7 to E8. &nbsp;Can someone show me how to code this in VBA?<br />
<br />
Regards,
</div>
</div>


I would to use the FORECAST function in excel VBA.  I have a spreadsheet called "Sheet1" that has the information I need.  Forecast requires X, known_y's, known_x's   So for X Sheet1 has cell D7 that contains this value.  For known_y's Sheet1 has E3 to E4 for this.  And known_x's has E7 to E8.  Can someone show me how to code this in VBA?

Regards,

Forecast function in Excel VBA

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.