Thread: Changing Name
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 468
Default Changing Name

Properties does not appear on right-clicking a Forms Option Button.


"Gary Brown" wrote:

right click on the option button, select PROPERTIES, change the 'Name'.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"JMay" wrote:

Using the Forms Toolbar after a few false starts (and with Excel
auto-assigning Controls using default names) I now have an Option Button 2
which shows up in the Name Drop Down box when I right-click on the actual
control.

I would like to change the name to Option Button 1 (since there isn't one)
In my standard module1 I see the

Sub OptionButton2_Click()

How can I go about doing this -- Performing a change klike this IS NOT
USER-FRIENDLY,,,

TIA,
Jim