Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box format
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box format
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box format
Stopher wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text box format
could you elaborate, I haven't ever seen checkboxes have that behavior.
Optionbuttons, but not checkboxes. -- Regards, Tom Ogilvy "Stopher" wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel |