Re: How to detect optionbutton being clicked?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: crapit (littlecramp_at_yahoo.com.sg)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 19:35:46 +0800

Thanks for your eventhough I got it before ur reply! Btw, is it possible to
hide/unhide the control on the active *** ?
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:ey91ADtXEHA.384@TK2MSFTNGP10.phx.gbl...
> active***.optionbuttons("Option Button 1").value = xloff
>
> --
>
> HTH
>
> Bob Phillips
> ... looking out across Poole Harbour to the Purbecks
> (remove nothere from the email address if mailing direct)
>
> "crapit" <littlecramp@yahoo.com.sg> wrote in message
> news:uzymjsqXEHA.1764@TK2MSFTNGP10.phx.gbl...
> > how do i set the optionbutton to be uncheck using vba?
> >
> > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > news:exdhWGqXEHA.2664@TK2MSFTNGP09.phx.gbl...
> > > When you create a control from the forms menu, you get an option to
> assign
> > a
> > > macro (you can also get the same option by selecting it and
> > right-clicking).
> > >
> > > Assign a macro, and clicking the control fires the macro. Hence the
> macro
> > > knows there has been a click.
> > >
> > > --
> > >
> > > HTH
> > >
> > > Bob Phillips
> > > ... looking out across Poole Harbour to the Purbecks
> > > (remove nothere from the email address if mailing direct)
> > >
> > > "crapit" <littlecramp@yahoo.com.sg> wrote in message
> > > news:e2sxf1pXEHA.1764@TK2MSFTNGP10.phx.gbl...
> > > > I dont get what you mean! I know that there is some kind of click
> > event,
> > > > but i dont know how to use!
> > > > "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> > > > news:uVXTkzpXEHA.2716@tk2msftngp13.phx.gbl...
> > > > > Because the macro will be entered if it is.
> > > > >
> > > > > --
> > > > >
> > > > > HTH
> > > > >
> > > > > Bob Phillips
> > > > > ... looking out across Poole Harbour to the Purbecks
> > > > > (remove nothere from the email address if mailing direct)
> > > > >
> > > > > "crapit" <littlecramp@yahoo.com.sg> wrote in message
> > > > > news:%23f2ohipXEHA.2520@TK2MSFTNGP12.phx.gbl...
> > > > > > I mean how to detect the optionbutton being clicked on it!
> > > > > > "papou" <cestpasbonprobin@çanonpluscg44.fr> wrote in message
> > > > > > news:%23K0NOfpXEHA.2844@TK2MSFTNGP12.phx.gbl...
> > > > > > > Hi crapit
> > > > > > > Right click on your option button and choose Assign macro
> (please
> > > note
> > > > > > this
> > > > > > > option may differ from yours - I am using a French version of
> > Excel)
> > > > > > > The macro thus assigned will fire each time your option button
> is
> > > > > clicked
> > > > > > >
> > > > > > > HTH
> > > > > > > Cordially
> > > > > > > Pascal
> > > > > > >
> > > > > > > "crapit" <littlecramp@yahoo.com.sg> a écrit dans le message de
> > > > > > > news:eM1dDapXEHA.2944@TK2MSFTNGP11.phx.gbl...
> > > > > > > > The option button i'm refering to is not on the userform or
> > > control
> > > > > box
> > > > > > > but
> > > > > > > > from the "forms" menu. Do I need to initialize anything?
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Quantcast