Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Bessel Functions in Visual Basic

Status
Not open for further replies.

bomber1

Technical User
Nov 7, 2001
5
US
Does anyone know how to bring in the Bessel Functions that can be used on the Excel Worksheets into Visual Basic code?
I've tried typing WorksheetFunction.BesselJ(x,n) but still it is not recognized by Visual Basic. Please Help.
 
Dear Bomber1,

Not all worksheet functions are available to Visual Basic. For a list of the ones that are, enter "list of worksheet functions available to visual basic" into the Answer Wizard in VB Help. A workaround is to enter the values and formulas into cells:

c1.Value = x
c2.Value = y
c3.Formula = "=Besselj(x,y)"
MyVar = c3.Value

Gregg
groberts1@austin.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top