Curious if I am thinking about this right.

[bplus]

Ha! even less work

Code: (Select All)

Const Conv# = 25.4 '25.4 mm every inch

Dim op% ' 1 if desired conversion is from inches to mm else vise versa

Dim num As Double ' a number to convert

Input "Enter a Number to convert "; num

Input "Enter 1 for conversion to mm from inches any other does vice versa "; op%

Print _IIf(op% = 1, num * Conv#, num / Conv#)

Wouldn't this mean that you would not be able to convert from 1 mm to 0.0393701 inches?

well let's see
   

I just hit enter for the 2nd input for op%