View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Use of Forms Command-button on Worksheet

Just normal click it to get the button selected (I am never sure if this is
left or right button I use a left-handed mouse), and then when it is
selected, use the normal mouse button to highlight the text, just as you
would if you highlighted pat of a formula, part of code, etc. When
highlighted, you can edit.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"JMay" wrote in message
...
Bob - how do I select it without clicking it?

I just left-clicked holding down the mouse for a few seconds wondering
what I might be able to do in conjuction with this <<but gave up so
I release my mouse and the code associated with the button ran..



"Bob Phillips" wrote:

Just select the button , so the grey shading is around it, then

highlight
the text using the mouse, and amend it.

Holding your mouth fright? <G

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Jim May" wrote in message
...
I created several buttons - Now I wish to edit the
text that I originally put in. When I right-click on
any of the buttons (thinking this is how one would
get into edit mode) NOTHING happens; Even if I
View, Toolbars, Forms,, still nothing.. Holding
down the Control key while right clicking... NOthing;

I must not be holding my mouth right.. Can someone
tell me the magic abra-cadabra - that I might be able
to gain access to edit the text (caption)?

I'd prefer not having to delete the buttons, but then again
this isn't a problem since I don't know how this is done.

My sheet or workbook is not protected.

TIA,