Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form buttons and macros
Is it possible to assign 2 different macros to one form button. Ex. when check box is checked perform 1 macro, then if the checkbox i unchecked to perform a seperate macro? Any help welcome Cadbur ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form buttons and macros
No, you cannot assign two macros to one control.
BUT, you can use conditional statement, such as IF-THEN to achieve the task. For example, if you got a checkbox called "CheckBox1". The IF-TEHN can look like: If CheckBox1.Value = True Then 'Do something Else 'Do some other things End If ----- cadbury wrote: ----- Is it possible to assign 2 different macros to one form button. Ex. when check box is checked perform 1 macro, then if the checkbox is unchecked to perform a seperate macro? Any help welcome Cadbury ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
Form Buttons | Excel Discussion (Misc queries) | |||
Form buttons vs. ActiveX Buttons | Excel Discussion (Misc queries) | |||
Form buttons | Excel Worksheet Functions | |||
Macros And Buttons | Excel Discussion (Misc queries) |