#1   Report Post  
Bethie at CLG
 
Posts: n/a
Default Radio Buttons

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   Report Post  
Dave Peterson
 
Posts: n/a
Default Radio Buttons

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   Report Post  
Bethie at CLG
 
Posts: n/a
Default Radio Buttons

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   Report Post  
Harlan Grove
 
Posts: n/a
Default Radio Buttons

"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   Report Post  
Bethie at CLG
 
Posts: n/a
Default Radio Buttons

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   Report Post  
Bethie at CLG
 
Posts: n/a
Default Radio Buttons

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   Report Post  
Dave Peterson
 
Posts: n/a
Default Radio Buttons

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Text for Radio Buttons Autumn Excel Discussion (Misc queries) 2 July 9th 05 03:58 AM
"RADIO BUTTON" Ian Shere Excel Discussion (Misc queries) 1 July 4th 05 10:59 PM
Can I copy radio buttons so that the second set is independent of. pd4him Excel Discussion (Misc queries) 1 February 9th 05 12:34 AM
Radio Buttons nir020 Excel Worksheet Functions 1 December 17th 04 03:23 PM
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True Mcasteel Excel Worksheet Functions 2 October 29th 04 07:06 PM


All times are GMT +1. The time now is 05:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"