Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MK MK is offline
external usenet poster
 
Posts: 57
Default Creating Buttons using the Forms Tool bar.

Looking for Help..

I want to create 4 buttons with the forms toolbar.

but,

I want the first two to toggle (when one is clicked "ON" the other clicks
"OFF")
I want the second two to toggle (when one is clicked "ON" the other clicks
"OFF")

Right now, all four seem to be related so that if you click one of the four
buttons "ON", the other 3 Click OFF (all four seem to have the same cell
reference in Format Control.

Can someone help?

Thanks!

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,290
Default Creating Buttons using the Forms Tool bar.


Go back to the Forms toolbar and select the "Group Box" control.
Draw one around each set of two buttons.
That will isolate each set from the other - provided you are actually
referring to Option Buttons and not Buttons.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

..
Those buttons are either Option
"MK"
wrote in message
Looking for Help..
I want to create 4 buttons with the forms toolbar.
but,
I want the first two to toggle (when one is clicked "ON" the other clicks
"OFF")
I want the second two to toggle (when one is clicked "ON" the other clicks
"OFF")
Right now, all four seem to be related so that if you click one of the four
buttons "ON", the other 3 Click OFF (all four seem to have the same cell
reference in Format Control.
Can someone help?
Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forms buttons Trebor Retrac Excel Discussion (Misc queries) 3 September 11th 06 05:37 PM
check boxes from the forms tool bar heatmatt Excel Worksheet Functions 1 May 16th 06 06:06 PM
creating checkboxes from forms tool bar KB Excel Worksheet Functions 2 April 25th 06 03:53 AM
check boxes in the forms tool bar Kimberly Excel Worksheet Functions 1 April 19th 06 08:19 PM
Forms Buttons for use with macro - recolorable? Ms. Tude New Users to Excel 1 February 20th 06 10:59 PM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"