VBA functions

Not clear on your question?

If the selling rate of TT$ is 6.5, then surely the calculation should be US$ x 6.5? In which case, the function should look like:

Please Login or Register  to view this content.

Then the formula in C4 (and copied down) is:

Formula:

Please Login or Register  to view this content.

No idea if this helps, or answers your question (still not clear what you were actually asking...) ?

There's nothing wrong with the function. However, the workbook you have uploaded is not macro enabled and contains no code. That might be the root of your problem.

Once you have entered the code into the VBE, you need to save the workbook as a macro enabled workbook, .xlsm, or you will lose it.

Regards, TMS

When I try to save my vba i get the error msg:
"Be careful! part of your document may include personal information that cannot be removed by the document inspector


And TMS, I have saved it as a mcro enabled workbook, but I keep getting error msgs when I try to save in VBA OR EXCEL

I'm no Math Boffin, but shouldn't it be something like this?

Please Login or Register  to view this content.

Thanks for the math correction Rudis

still getting the error msg:
"Be careful! part of your document may include personal information that cannot be removed by the document inspector"

Hi,

Try one of these two actions..

1.
Go File, Info, Check for issues, and inspect document.
Keep everything checked and run it.
Test to see if the message is resolved.

If not, try this:

2.
Go to File in the upper left hand corner, then Options > Trust Center > Trust Center Settings > Privacy Options
Then uncheck the check box that says "Remove personal information from file properties on save", then hit OK.
Test to see if the message is resolved.

Also look at this link, the second reply at the bottom.
Try that too if the link they refer to is available.

See: http://stackoverflow.com/questions/2...-that-cannot-b

Thank you sooo much! I got it to save.
Now that I want to run it, I clicked run and I got a box to rename the macro, so do I just have to rename it and try running it again?

Hey, thanks I got my function to run. :D

excel girl,

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Originally Posted by excel girl

Thank you sooo much! I got it to save.
Now that I want to run it, I clicked run and I got a box to rename the macro, so do I just have to rename it and try running it again?

Hey, thanks I got my function to run. :D

Hi,

Just in case you're not sure, you don't actually "run" as function macro. A function macro is either called from VBA (by using its name and passing variables to it) or from Excel where you use it as a function. To access the function you can either type = and then the name of your user defined function (UDF) into a cell or you can click on the FX button in the formula bar and access the library of functions. Your UDF will be located under the User Defined category.

RudiS,

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc