state of option button
 

I have 2 option button. How do I get the state of the option button? (The
optionbutton is not on the userform)

state of option button
 

If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the option
button? (The
optionbutton is not on the userform)

state of option button
 

I'm using forms toolbar. Does the "optionsbutton(1)" refer to the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the option
button? (The
optionbutton is not on the userform)

state of option button
 

The "optionbuttons(1)" refers to the first (earliest created)
option button on the sheet. Alternatively, you can use the name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)" refer to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the
option
button? (The
optionbutton is not on the userform)

state of option button
 

Do I put the code within the sub function itself? E.g the groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest created)
option button on the sheet. Alternatively, you can use the name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)" refer to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the
option
button? (The
optionbutton is not on the userform)

state of option button
 

Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest created)
option button on the sheet. Alternatively, you can use the
name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)" refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the
option
button? (The
optionbutton is not on the userform)

state of option button
 

but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest created)
option button on the sheet. Alternatively, you can use the
name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)" refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of the
option
button? (The
optionbutton is not on the userform)

state of option button
 

Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest
created)
option button on the sheet. Alternatively, you can use
the
name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code
like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code
like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of
the
option
button? (The
optionbutton is not on the userform)

state of option button
 

is there a way to trace which optionbutton is insert 1st?
"Chip Pearson" wrote in message
...
Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest
created)
option button on the sheet. Alternatively, you can use
the
name
of the option button. E.g.,

Debug.Print ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the "optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code
like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use code
like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I have 2 option button. How do I get the state of
the
option
button? (The
optionbutton is not on the userform)

state of option button
 

Your best bet is to give specific names to your option buttons
rather than rely on index numbers.


"crapit" wrote in message
...
is there a way to trace which optionbutton is insert 1st?
"Chip Pearson" wrote in message
...
Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g
the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest
created)
option button on the sheet. Alternatively, you can
use
the
name
of the option button. E.g.,

Debug.Print
ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the
"optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code
like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use
code
like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in
message
...
I have 2 option button. How do I get the state
of
the
option
button? (The
optionbutton is not on the userform)

state of option button
 

I get this error "Unable to get OptionButtons property of the worksheet
class"
"Chip Pearson" wrote in message
...
Your best bet is to give specific names to your option buttons
rather than rely on index numbers.


"crapit" wrote in message
...
is there a way to trace which optionbutton is insert 1st?
"Chip Pearson" wrote in message
...
Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself? E.g
the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first (earliest
created)
option button on the sheet. Alternatively, you can
use
the
name
of the option button. E.g.,

Debug.Print
ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in message
...
I'm using forms toolbar. Does the
"optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in message
...
If the button is from the Forms toolbar, use code
like

Debug.Print ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar, use
code
like

Debug.Print
ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in
message
...
I have 2 option button. How do I get the state
of
the
option
button? (The
optionbutton is not on the userform)

state of option button
 

You'll get this error if you attempt to use a name that doesn't
exist. Be sure you are using the correct name of the option
button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I get this error "Unable to get OptionButtons property of the
worksheet
class"
"Chip Pearson" wrote in message
...
Your best bet is to give specific names to your option
buttons
rather than rely on index numbers.


"crapit" wrote in message
...
is there a way to trace which optionbutton is insert 1st?
"Chip Pearson" wrote in message
...
Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself?
E.g
the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first
(earliest
created)
option button on the sheet. Alternatively, you
can
use
the
name
of the option button. E.g.,

Debug.Print
ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in
message
...
I'm using forms toolbar. Does the
"optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in
message
...
If the button is from the Forms toolbar, use
code
like

Debug.Print
ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar,
use
code
like

Debug.Print

ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in
message
...
I have 2 option button. How do I get the
state
of
the
option
button? (The
optionbutton is not on the userform)

state of option button
 

I still got the error!
The following are the codes:
Sub Group1119_Click()
x = ActiveSheet.OptionButtons("optionbutton1").Value

If x = 1 Then
Range("e1").Select
ActiveCell.Value = "Remove"
Else
Range("e1").Select
ActiveCell.Value = "Insert"
End If

End Sub

"Chip Pearson" wrote in message
...
You'll get this error if you attempt to use a name that doesn't
exist. Be sure you are using the correct name of the option
button.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in message
...
I get this error "Unable to get OptionButtons property of the
worksheet
class"
"Chip Pearson" wrote in message
...
Your best bet is to give specific names to your option
buttons
rather than rely on index numbers.


"crapit" wrote in message
...
is there a way to trace which optionbutton is insert 1st?
"Chip Pearson" wrote in message
...
Do something like

Dim V as Long
V = ActiveSheet.OptionButtons(1).Value
If V = 1 Then
' button is true
Else
' button is false
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"crapit" wrote in message
...
but how do i get it to store to a variable?
"Chip Pearson" wrote in message
...
Yes, put the code in the sub itself.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"crapit" wrote in message
...
Do I put the code within the sub function itself?
E.g
the
groupname of the
2 optionbutton is "Group19"
Sub group19_click()
<Should the code be put here?
End sub

"Chip Pearson" wrote in message
...
The "optionbuttons(1)" refers to the first
(earliest
created)
option button on the sheet. Alternatively, you
can
use
the
name
of the option button. E.g.,

Debug.Print
ActiveSheet.OptionButtons("TheButton").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"crapit" wrote in
message
...
I'm using forms toolbar. Does the
"optionsbutton(1)"
refer
to
the name of
the optionbutton or something else?
"Chip Pearson" wrote in
message
...
If the button is from the Forms toolbar, use
code
like

Debug.Print
ActiveSheet.OptionButtons(1).Value

If the button is from the Controls toolbar,
use
code
like

Debug.Print

ActiveSheet.OLEObjects("OptionButton1").Object.Val ue


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"crapit" wrote in
message
...
I have 2 option button. How do I get the
state
of
the
option
button? (The
optionbutton is not on the userform)