Prev: Sorting the data in descending order
Next: Hiding and unhiding rows with if statement macro
From: JMay on 1 Apr 2010 14:24
Thanks Luke, I was able to change like you suggested.

"Luke M" wrote:

> In XL, select your object (you said, form, but the presence of code
> indicates a control). In the name box (to the left of formula bar) change
> the name to whatever you want. Note that if you already have code written,
> you will need to reflect these changes here as well.
>
> --
> Best Regards,
>
> Luke M
> "JMay" <JMay(a)discussions.microsoft.com> wrote in message
> news:B9EB0851-9381-4C50-84FF-2E3C190DD4B1(a)microsoft.com...
> > 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
>
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Sorting the data in descending order
Next: Hiding and unhiding rows with if statement macro