Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Option Button Help | Excel Worksheet Functions |