Text box format

[ChrisM]

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.

 

[Stopher]

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.

 

[ChrisM]

ChrisM wrote:

I am using one check box. When it is checked it runs a function that
converts measurments for imperial to metric on the sheet. What I am
needing to do is have the check box stay checked until the user
unchecks it even if the sheet is closed. Then I have two List boxes the
user uses to select the manufacture and model of an item. Once that is
done the demensional information is returned from the sheet to the text
boxes on the form. I need to format the returned value to read "Value",
"MM" or "Value", "Inches" based on the imperial or metric check box.

 

[Tom Ogilvy]

could you elaborate, I haven't ever seen checkboxes have that behavior.
Optionbuttons, but not checkboxes.

 

[Tom Ogilvy]

Link the checkbox to a cell (perhaps the cell underneath the checkbox).
Save the workbook before closing.


Assume that linked cell is Cell B9

in the cells that compute the final values returned

=Current Formula & if(B9, " MM"," Inches")