LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
JAY JAY is offline
external usenet poster
 
Posts: 7
Default Referring to an option button in formula...?

Hello.

I have been tinkering with Excel and would really like to
learn how to utilize the controls features such as the
option button or check box. I see a use for the option
button where I have a series of rows of information that
perform a calculation unique to each row. I would like to
have an option button at the front of the row which allows
the user to dictate which type of calculation the cells in
that row should perform.

So essentially I would like the formulas in the row to use
the option button to collect logic information about which
calculation it should perform. The task seems straight
forward, but I do not know how to reference the option
button in my formulas. If you have a suggestion on how I
could find out more about this procedure I would be very
grateful.

Regards,
-Jay

 
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
Referring to Option Button in If then statement Mike Excel Discussion (Misc queries) 3 May 17th 08 03:44 PM
Option Button help Excel Discussion (Misc queries) 4 November 2nd 06 04:08 PM
Using Option Button to populate formula Archgrad Excel Discussion (Misc queries) 0 August 8th 06 10:47 PM
keep source formatting is not an option in paste option button Tina Excel Discussion (Misc queries) 0 February 20th 06 09:58 PM
Getting value of Option button BG Excel Worksheet Functions 2 September 27th 05 01:47 PM


All times are GMT +1. The time now is 07:28 AM.

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"