When I am designing a VBA form, I can edit the caption of a button from directly
inside the button, as well as from a properties window.
One of the things I can do when editing the caption directly inside the button
is insert an explicit line break to split the caption onto two or more lines
where I want it, rather than where Excel wants to do it. I insert the line
break with Shift-Enter.
Now, if I put a command button directly onto a worksheet, I don't seem to be
able to edit the caption from directly inside the button. (Shift-Enter in the
caption in a properties window doesn't insert a line break.)
I've also tried copy/paste of the break information and of the whole caption
from the caption of the button on the form to the button on the worksheet, but
the paste is ignored or I get just the first line of the caption.
I've also tried to copy/paste the whole button from the form to the worksheet,
but the paste is ignored.
Two questions:
(1) does anyone know how to put a line break into a caption of a button that is
directly in a worksheet?
(2) does anyone know how to copy a button off a VBA form and paste it directly
onto a worksheet?
(3) (yeah, I know I said 2) does anyone know of any other way of doing this at
design time (not run time) short of adding spaces until you get a line overflow?