option buttom (1 Viewer)

B

bhelmy

Registered User.

Local time

Today, 13:55

Joined

Dec 6, 2015

Messages

62

• Oct 2, 2018

• #1

hi
this my first time to use option buttom but i have one problem

i have 2 option (1 & 2 )

i need when user select 1 system auto unselect 2
and when user select 2 system auto unselect 1

However , i only selected


please

 

Minty

AWF VIP

Local time

Today, 11:55

Joined

Jul 26, 2013

Messages

10,371

• Oct 2, 2018

• #2

Did you use an Option Group ? If you did then the default behaviour is what you have described, so I'm slightly confused.

 

J

JHB

Have been here a while

Local time

Today, 12:55

Joined

Jun 17, 2012

Messages

7,732

• Oct 2, 2018

• #3

Look at the picture:

 

Attachments

• 
  Wizard1.jpg

  37.2 KB · Views: 108

B

bhelmy

Registered User.

Local time

Today, 13:55

Joined

Dec 6, 2015

Messages

62

• Oct 2, 2018

• #4

thx
I get it

 

B

bhelmy

Registered User.

Local time

Today, 13:55

Joined

Dec 6, 2015

Messages

62

• Oct 2, 2018

• #5

sorry but what is the value to true and false to write in VBA code (iF)

 

Minty

AWF VIP

Local time

Today, 11:55

Joined

Jul 26, 2013

Messages

10,371

• Oct 2, 2018

• #6

The option group will return the value of the selected item, you can then use that something like ;

Code:Copy to clipboard

SELECT CASE Me.YourOptionGroup 
     CASE 1              ' Option value 1
              Do something Here
     CASE 2               ' Option 2 
              Do something different here
      etc etc
END SELECT