Button Appearence

  • Thread starter Thread starter Asif
  • Start date Start date
A

Asif

I've created three toggle buttons that run an applyfilter macro. When
I click on button_1 the records are filtered as they should be but
when I click on Button_2 although the records are filtered accordingly
button_1 still stays depressed. Is there anyway of changing this so
that only the active macro is depressed and not the others

Many Thanks
 
If they are part of an option group they will do so automatically.
Otherwise, you need to explicitly set each of them to True/False
depending on which was clicked - False being not depressed.
 
If they are part of an option group they will do so automatically.
Otherwise, you need to explicitly set each of them to True/False
depending on which was clicked - False being not depressed.

how do i go about doing that, do i have to write some vba code if so
what as i'm not very good in that area
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top