hi, i need help writing a VBA Function to retrieve data from one worksheet to another?

[lildesidiva]

Book2.xlsm
I have never written a vBA codeor any codes
Write VBA functions to retrieve relevant data for an arbitrary species and test
them with the following cell calling sequences for carbon dioxide.
Tc(“CO2”) Critical temperature (C)
Pc(“CO2”) Critical pressure (bar)
Vc(“CO2”) Critical volume (cm/mol)
Tmin(“CO2”) Minimum temperature for the Shomate equation (C)
Tmax(“CO2”) Maximum temperature for the Shomate equation C)
(2) Write VBA function to calculate the standard heat capacity, enthalpy, and
entropy as functions of temperature for an arbitrary chemical species. Test these
functions with the following cell calling
sequences for carbon dioxide with the
temperature in degrees Celsius.
Cp0(“CO2”,500)
H0(“CO2”,500)
S0(“CO2”,500)
(3) Write a VBA function to calculate the molar volume (cm
3/mol) of an arbitrary species as a function of P (bar) and T̊C). This will require using bilinearinterpolation of the Lee/Kessler tables. In your Excel worksheet, call this functionas follows for carbon dioxide:
MolarVolume(“CO2”,10,100)
MolarVolume(“CO2”,40,295)
MolarVolume(“CO2”,70,30)

[Richard Buttrey]

Hi,

What makes you think you need a VBA macro?

If you can manually add some results to your workbook and tell us where the results are and in narrative form explain how you have calculated the results we'll be in a better position to assist.

[TMS]

I guess that, if you're using Excel/VBA as part of your course, they will have provided some tuition and will be expecting YOU to use VBA to produce the functions ... not the members of an on-line forum.

Tell us what code you have produced and what it does and what it does not do ... and we'll try to help you make it work.

Regards, TMS

[TMS]

@RB: I guess that would be because the textbook says he needs a VBA macro

[Richard Buttrey]

@TMS

Good point! Must be getting tired and missed that. Isn't it time you were in bed anyway?

[lildesidiva]

programing class was not listed as a requirement for this course by mistake and we dont use textbooks for this course. he just sowed us the basic macros.

[lildesidiva]

i did not even know what macros or vba codes were before this class. i tried search engine but did not get any results

[lildesidiva]

i will try

[lildesidiva]

i really need to do the 1st question in order to do the second question . so, can you please help me.

[MrShorty]

I don't know exactly what you are expected to do for this. As a chemist myself, I created a workbook/add-in very similar to this that uses VBA UDF's to retrieve property data for chemicals. Obviously, I can't just give you the code for this, you need to do this yourself for practice. At the heart of my code are Excel's built in lookup functions. My suggestion for doing this:

1) Do it first in the spreadsheet without VBA using Excel's lookup functions: http://office.microsoft.com/en-us/ex...670.aspx?CTT=1 VLOOKUP() is probably the most commonly used lookup function.

2) Once you can see how the lookup functions work, then you can learn how to access them from VBA: http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

This assumes that you're allowed to use Excel functions in VBA for this assignment. If you must code your own lookup function, then come back and we can talk about lookup/search algorithms.

[lildesidiva]

thank you so much