I hope I explain this right.
In the process of displaying information on a sheet I have created a
form that displays measurments in different text boxes. These values
are looked up as you enter manufature and model number into a couple of
combo boxes.

I also use a check box to switch the values on the worksheet between
metric and imperial measurments.

What I need to do is format my text boxes to read ("looked up Value"
Inches) and then switch the format to read ("looked up Value" MM) based
on the check box selection.

I also need to make the check box for metric stay checked until it is
unchecked by the user even if the work book is closed.

Can you guys help me out.