Formatting a radio button

[Iriemon]

I am trying to resize/reformat a radio button.

I inserted a radio button but when I edit the test, it comes out on one line
only:

Jones, Fred, Manager

I would like the button text formatted (wrap text) to be:

Jones, Fred
Manager


Is there a method of wrapping the text in a radio button?

 

[Jacob Skaria]

One way./..

--Try this formula in a cell
="Jones, Fred," & CHAR(10) & "Manager"

--Copy the cell>PasteSpecial>Values
--Now copy the contents of the cell. F2..select the text and copy
--Edit the Radio button text>Paste and adjust the height

If this post helps click Yes

 

[Iriemon]

Can't seem to get it to function properly using the method below

:-(

 

[Jacob Skaria]

Is 'WrapText' set to True

Try this
Enter Jones, Fred,
and then press Alt+Enter and then continue
typeing Manager which will be in the next line...

Now press F2 and copy paste the contents to the caption...

If this post helps click Yes

 

[Dave Peterson]

What kind of optionbutton is this?

Is it on a worksheet--if yes, is it from the Control toolbox toolbar or from the
Forms toolbar?

Or is on a userform?