ChrisM wrote:
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.

Are your check boxes grouped, If so you can give them an output cell,
this will display either a 1 or 2 depending on which one is
selected/ticked. With this little number you can have a seperate index
sheet that has the 2 selections you want. Then a simple index function
in any cell will return the selection from the indexed list. I hope
this is what your meaning.