I have two option buttons on a user form named OptionButton1 & OptionButton2. When I select OptionButton1, I want the range name PBITtrigger to be equal to 1, and when I select OptionButton2, I want the range name PBITtrigger to be equal to 2. Can someone help with the code for this?
Thanks in advance.
I have decided to use option buttons in Excel and not on the user form & then link the button to the cell which works fine. I thought when I added the option buttons to the user form, and linked the button to the cell, I would get a value of 1 etc. instead of True. It would be nice to know how to do this when the buttons are on the user form though?
perhaps
or even
Select Case True Case OptionButton1 Range("PBITtrigger").Value = 1 Case OptionButton2 Range("PBITtrigger").Value = 2 End Select
Range("PBITtrigger").Value = OptionButton1 * -1 + OptionButton2 * -2
Josie
if at first you don't succeed try doing it the way your wife told you to
Thank you Joseph. Much appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Aland2929 
Register To Reply
Bookmarks