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''.
|