Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
The option button i'm refering to is not on the userform or control box but
from the "forms" menu. Do I need to initialize anything? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
Hi crapit
Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
I mean how to detect the optionbutton being clicked on it!
"papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
Because the macro will be entered if it is.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
I dont get what you mean! I know that there is some kind of click event,
but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
When you create a control from the forms menu, you get an option to assign a
macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
how do i set the optionbutton to be uncheck?
"Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
how do i set the optionbutton to be uncheck using vba?
"Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
activesheet.optionbuttons("Option Button 1").value = xloff
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
Thanks for your eventhough I got it before ur reply! Btw, is it possible to
hide/unhide the control on the active sheet ? "Bob Phillips" wrote in message ... activesheet.optionbuttons("Option Button 1").value = xloff -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
Of course
activesheet.optionbuttons("Option Button 1").Visible = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... Thanks for your eventhough I got it before ur reply! Btw, is it possible to hide/unhide the control on the active sheet ? "Bob Phillips" wrote in message ... activesheet.optionbuttons("Option Button 1").value = xloff -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
So for dropdown form control is it
activesheet.dropdown("drop down 1").Visible = False If there are 3 columns of merge cell i.e A1 (A1 & A2), B1 (B1 & B2), C1 ( C1 & C2 ) can i refer it as range("a1:c1") "Bob Phillips" wrote in message ... Of course activesheet.optionbuttons("Option Button 1").Visible = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... Thanks for your eventhough I got it before ur reply! Btw, is it possible to hide/unhide the control on the active sheet ? "Bob Phillips" wrote in message ... activesheet.optionbuttons("Option Button 1").value = xloff -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
I 'm unable to get this to work correctly,
ActiveSheet.DropDowns("dropdown143").Visible = True It give unable to get the dropdown property of the class What's wrong with it? "Bob Phillips" wrote in message ... Of course activesheet.optionbuttons("Option Button 1").Visible = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... Thanks for your eventhough I got it before ur reply! Btw, is it possible to hide/unhide the control on the active sheet ? "Bob Phillips" wrote in message ... activesheet.optionbuttons("Option Button 1").value = xloff -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to detect optionbutton being clicked?
It works for me. Is it a Forms dropdown?
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I 'm unable to get this to work correctly, ActiveSheet.DropDowns("dropdown143").Visible = True It give unable to get the dropdown property of the class What's wrong with it? "Bob Phillips" wrote in message ... Of course activesheet.optionbuttons("Option Button 1").Visible = False -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... Thanks for your eventhough I got it before ur reply! Btw, is it possible to hide/unhide the control on the active sheet ? "Bob Phillips" wrote in message ... activesheet.optionbuttons("Option Button 1").value = xloff -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... how do i set the optionbutton to be uncheck using vba? "Bob Phillips" wrote in message ... When you create a control from the forms menu, you get an option to assign a macro (you can also get the same option by selecting it and right-clicking). Assign a macro, and clicking the control fires the macro. Hence the macro knows there has been a click. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I dont get what you mean! I know that there is some kind of click event, but i dont know how to use! "Bob Phillips" wrote in message ... Because the macro will be entered if it is. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "crapit" wrote in message ... I mean how to detect the optionbutton being clicked on it! "papou" wrote in message ... Hi crapit Right click on your option button and choose Assign macro (please note this option may differ from yours - I am using a French version of Excel) The macro thus assigned will fire each time your option button is clicked HTH Cordially Pascal "crapit" a écrit dans le message de ... The option button i'm refering to is not on the userform or control box but from the "forms" menu. Do I need to initialize anything? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicked NO to save, should have clicked YES | Excel Discussion (Misc queries) | |||
How can I detect that an excel cell has been clicked | Excel Discussion (Misc queries) | |||
optionbutton in userform | Excel Programming | |||
optionbutton in userform | Excel Programming | |||
getting focus on an optionbutton | Excel Programming |