Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
I am trying to figure out a way to invoke this macro:
Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but Im not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
Public Sub YourCode()
...code end sub then: Private Sub cmdSend_Click() Call YourCode End Sub and similarly call it from the other worksheet event? "ryguy7272" wrote: I am trying to figure out a way to invoke this macro: Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but Im not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
And the cmdSend button is on a different sheet?
You know the codename of that sheet that holds that button, right? Application.Run "'" & ThisWorkbook.Name & "'!sheet1.cmdSend_Click" Replace sheet1 with the codename for worksheet that owns that commandbutton. Another way if you know the sheetname, but not its codename: thisworkbook.Worksheets("Sheetnamehere").cmdSend.V alue = True ryguy7272 wrote: I am trying to figure out a way to invoke this macro: Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but Im not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
Thanks Sam! I want to be able to use this code without clicking a button,
which is what I did before. Does this allow me to run something like button_click() from another macro? Thanks again! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Sam Wilson" wrote: Public Sub YourCode() ...code end sub then: Private Sub cmdSend_Click() Call YourCode End Sub and similarly call it from the other worksheet event? "ryguy7272" wrote: I am trying to figure out a way to invoke this macro: Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but Im not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
The idea is to take the code that usually runs inside the button_click() sub,
and place it inside a public sub. Once you've done that, you can change the button_click() sub to call the new, public, macro, but also call the same macro form wherever you choose. Sam "ryguy7272" wrote: Thanks Sam! I want to be able to use this code without clicking a button, which is what I did before. Does this allow me to run something like button_click() from another macro? Thanks again! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Sam Wilson" wrote: Public Sub YourCode() ...code end sub then: Private Sub cmdSend_Click() Call YourCode End Sub and similarly call it from the other worksheet event? "ryguy7272" wrote: I am trying to figure out a way to invoke this macro: Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but Im not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a cmdSend_Click macro; non-click interaction
Wow! Application.Run "'" & ThisWorkbook.Name & "'!sheet1.cmdSend_Click"
That's very clever; never thought of that before. Thanks, both of you! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Dave Peterson" wrote: And the cmdSend button is on a different sheet? You know the codename of that sheet that holds that button, right? Application.Run "'" & ThisWorkbook.Name & "'!sheet1.cmdSend_Click" Replace sheet1 with the codename for worksheet that owns that commandbutton. Another way if you know the sheetname, but not its codename: thisworkbook.Worksheets("Sheetnamehere").cmdSend.V alue = True ryguy7272 wrote: I am trying to figure out a way to invoke this macro: Private Sub cmdSend_Click() €¦code End Sub As it is now, action is driven by a click event. I am using propriety software which may require some kind of click event, but I€„¢m not sure about that. How can I call this macro from another macro, without requiring a user to interact by clicking the button. This macro will be called by a worksheet event, which is triggered by a change in a range of cells on another sheet. Thanks! Ryan-- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro interaction | Excel Discussion (Misc queries) | |||
Call Macro using right click menu | Excel Programming | |||
Function like =HYPERLINK(xxx) - Mouse interaction - "On Click Event" | Excel Programming | |||
How to call a sub defined in macro when double click a cell? | Excel Programming | |||
Call Userfor and click button with macro | Excel Programming |