Unit conversion

[hollanu]

Let's say I have two cells, A1 and C1, that are designed to contain
inches and millimeters, respectively. I want a way that someone could
enter a value in A1 and it would be converted to millimeters in C1.
Conversely, they could enter a value in C1 and it would be converted
to inches in A1. The conversion isn't the issue; I know how to do
that. But if someone enters a value in A1, that value will overwrite
any formula I may have in that cell, and mean that any subsequent
value entered in cell C1 would not give the required conversion in
the previously overwritten A1. Is there a way I can have these two
related cells always give the desired conversions, without losing the
formulas and without the formulas being considered circular?

thanks!

[jasoncw]

This can be accomplished with VBA.

Right-click on the worksheet tab, select View Code, and copy the following code:

Please Login or Register  to view this content.

HTH

Jason

[hollanu]

fantastic!

works perfectly.


Thanks a lot

~hollanu~

[jasoncw]

No problem. Glad I could help.

Jason

[hollanu]

need more help.

the code above works great, but I have multiple cells requiring the same treatment that are not necessarily one after another. i.e. A1, A6, B9, C2, etc. I'm new to VBA, so I just tried copying the above code for each of the new cell pairs, but received the following error message "Ambiguous Name Detected".

thanks again in advance

[hollanu]

nevermind, I think I have figured it out.

Thanks anyway

[jasoncw]

If you need more help on it, be sure to post up a full copy of the revised procedure, or, if able, a copy of the workbook, so that someone can help you out.

Jason

[WS6FirebirdTA00]

Is there a way to do this in the same cell?

Right now I have data entry in A2, and a drop down in A1 that says Metric or Imperial. I want the data in A2 to change depending on what is selected in A1 for the units. Is this possible, do either of you know?

[walterst]

Is there a way that I could use the below code to calculate a multiple imput formula that would calculate in multiple directions. For example if I have the equation--vehicle speed=rpm x gear ratio x tire size--I would like to be able to imput any combination of three variables and have the fourth one calculated.

This can be accomplished with VBA.

Right-click on the worksheet tab, select View Code, and copy the following code:

Please Login or Register  to view this content.

HTH

Jason

[arlu1201]

walterst,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[walterst]

thank you I saw this as being the same question with a minor adjustment and thought this would be an appropriate approach. i will comply with your direction