Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I am using radio buttons (from the control toolbox) for a survey.
How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG |
#2
![]() |
|||
|
|||
![]()
You mean you want to hide TRUE/FALSE in the linked cell?
Try giving it a format of: ;;; (3 semicolons) It'll hide it in the cell, too--but you'll be able to see it in the formula bar. Bethie at CLG wrote: I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG -- Dave Peterson |
#3
![]() |
|||
|
|||
![]()
No, the semicolons didn't work, thanks for trying.
Bethie "Dave Peterson" wrote: You mean you want to hide TRUE/FALSE in the linked cell? Try giving it a format of: ;;; (3 semicolons) It'll hide it in the cell, too--but you'll be able to see it in the formula bar. Bethie at CLG wrote: I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG -- Dave Peterson |
#4
![]() |
|||
|
|||
![]()
"Bethie at CLG" wrote...
No, the semicolons didn't work, thanks for trying. .... They should have. The custom number format ;;; *ALWAYS* hides cell contents on the display and in printout. |
#5
![]() |
|||
|
|||
![]()
Yes, you are correct. It did work. I misunderstood the formatting of
"custom". When I formatted the cells to "custom" and typed in the 3 semicolons, it worked. THANKS!!!!!! "Harlan Grove" wrote: "Bethie at CLG" wrote... No, the semicolons didn't work, thanks for trying. .... They should have. The custom number format ;;; *ALWAYS* hides cell contents on the display and in printout. |
#6
![]() |
|||
|
|||
![]()
Yes, you are correct. It did work. I misunderstood the formatting of
"custom". When I formatted the cells to "custom" and typed in the 3 semicolons, it worked. THANKS!!!!!! Bethie at CLG "Bethie at CLG" wrote: I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG |
#7
![]() |
|||
|
|||
![]()
Whew!
Glad you got it working. Bethie at CLG wrote: Yes, you are correct. It did work. I misunderstood the formatting of "custom". When I formatted the cells to "custom" and typed in the 3 semicolons, it worked. THANKS!!!!!! Bethie at CLG "Bethie at CLG" wrote: I am using radio buttons (from the control toolbox) for a survey. How do I hide the text "true" and "false" from the properties of the radio button so they do not show up when I print the survey? Bethie at CLG -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help Text for Radio Buttons | Excel Discussion (Misc queries) | |||
"RADIO BUTTON" | Excel Discussion (Misc queries) | |||
Can I copy radio buttons so that the second set is independent of. | Excel Discussion (Misc queries) | |||
Radio Buttons | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |