Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On an MS site, it referred to a document called "Writing a user-defined
worksheet function". I am a long-time Excel user, but don't have VB experience. I want to create my own finctions that will calculate various chemical parameters from user input arguements. Can anyone point me int he right direction? My needs are pretty simple; I'd like to do things like create a function to calculate the vapor pressure of water at a specified temperature, so I can just type "=Pw(25)" to get the answer for 25 °C Pw=760*EXP(11.8571-(3840.7/(T+273.15))-(216961/(T+273.15)^2)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User defined function returns imprecise value when used in worksheet | Excel Discussion (Misc queries) | |||
User Defined Function use any worksheet | Excel Discussion (Misc queries) | |||
Using dcount function within user-defined worksheet function | Excel Programming | |||
Error messages from user defined Excel worksheet function | Excel Programming | |||
Automatic calculation of user-defined worksheet function | Excel Programming |