Distance Calculator

[Neuther]

I want to make a Distance calculator. So if i put 1 mile in to cell a
and want the answer in ft. then push the total button i would 5280.
so 2 miles would be double and so on. also want to go between feet an
yards like 2 miles is how many yards. i was thinking i could use v
and the options buttons somehow but i couldn't think of how to do it.
Has anyone already made 1 i could use or tell me how to make a good 1.


Than

 

[martialtiger]

I gave it a shot and created 1 in couple of minutes.

Feel free to tweak it

Attachment filename: length conversion.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61475

 

[Rollin_Again]

Here's another. This one convert both feet and yards. I used a for
instead of the actual spreadsheet.

Rolli

Attachment filename: distance conversion.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61477

 

[Neuther]

that's pretty cool, but i'm looking to be able to go both ways too.
want to also be able to say 5280' = 1 mile. I'm trying to figure ou
how to change the miles part also. that's where i run into problems

 

[Ron Rosenfeld]

I want to make a Distance calculator. So if i put 1 mile in to cell a1
and want the answer in ft. then push the total button i would 5280.
so 2 miles would be double and so on. also want to go between feet and
yards like 2 miles is how many yards. i was thinking i could use vb
and the options buttons somehow but i couldn't think of how to do it.
Has anyone already made 1 i could use or tell me how to make a good 1.


Thanx

You could use the CONVERT worksheet function.

If this function is not available, and returns the #NAME? error, install and
load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.

--ron

 

[Rollin_Again]

Here you go! This workbook has conversion from Miles to Feet, Miles t
Yards, Feet to Miles, and Feet to Yards. I hope this works fo
you....lemme know if you want more




Rolli

Attachment filename: distance conversion.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61480

 

[martialtiger]

Here's a cleaner attempt at it. Hope it's what you needed.

Good luck! ;

Attachment filename: length conversion.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61484

 

[martialtiger]

Rolling,

I love how you did the form. Would you be so kind as to indulge me i
how to create forms like that? Is there any resources I can read u
on, etc.?

Best regards,

Jona

 

[Rollin_Again]

Here are some basic tutorials:

http://spreadsheets.about.com/od/excelmacrosandvba/

http://tinyurl.com/2ynrc




Rolli

 

[martialtiger]

Thanks Rollin