Distance Calculator

N

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
 
N

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
 
R

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
Click to expand...

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
 
M

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
 
Top