Tuesday, August 24, 2010

How do i use the options buttons on the control box in excel?

It is like regular VB options buttons





You may only need to group them in one Frame control





Again, it is like VB controls and required VB code to work





Group each group of option buttons into one frame to act togeter





Enjoy my profile, I am the VBAXLManHow do i use the options buttons on the control box in excel?
If I understand what your asking:





Right click the option button and choose ';Format Control鈥?quot;


Insert a cell address in the ';cell link:'; like $A$1 for example.





Now click on the option button and you will see a 1 in the linked cell





Create another option button to toggle between values
  • makeup help
  • No comments:

    Post a Comment