Function Help

[aalibhai1]

I have created multiple option buttons on the first worksheet whcih
call the input worksheet. All of the Option buttons are placed withi
specific groups. For example there are two option buttons within
group called "EYE SITE". The Option Buttons for that group are labele
as "Positive" and "Negative". I want to summarize on the secon
worksheet where it writes the text "Positive or Negative" depending o
which option has been clicked on the previous worksheet.

I was trying to do a logical IF statement but i am not sure how i ca
use that function. Basically i want to be able to say that i
Positive has been clicked, then say POSITIVE on my summary workshee
and if Negative has been clicked, then say NEGATIVE on my summar
worksheet.

PLEASE HELP. Thank

 

[Jeff Kulp]

You could do it using vba. Double click the button you
created while in design mode and you will be taken to
visual basic. Add this code Worksheets("sheet1").Range
("a1") = "Positive" when you exit design mode and click
the button it will put Positive in cell A1. After you get
that working just change the name of the sheet, range and
Positive/Negative and it should do the trick.

HTH

-----Original Message-----

I have created multiple option buttons on the first worksheet whcih i
call the input worksheet. All of the Option buttons are placed within
specific groups. For example there are two option buttons within a
group called "EYE SITE". The Option Buttons for that group are labeled
as "Positive" and "Negative". I want to summarize on the second
worksheet where it writes the text "Positive or Negative" depending on
which option has been clicked on the previous worksheet.

I was trying to do a logical IF statement but i am not sure how i can
use that function. Basically i want to be able to say that if
Positive has been clicked, then say POSITIVE on my summary worksheet
and if Negative has been clicked, then say NEGATIVE on my summary
worksheet.

PLEASE HELP. Thanks


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by

step guide to creating financial statements