SQUIDD
Well-known Member
- Joined
- Jan 2, 2009
- Messages
- 2,126
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi.
So i have a user form with image placeholder(and an image in the properties)
i have a mouse down event on this image
how can i call the code above to run without the user having to click the button. But the button does need to remain to let them click it.
its a save button, but sometimes the save needs to run without them needing to know.
I guess i could have a seperate macro with the save code, and call that, and also tell the save button to call that, just wondering if an easier way?
thanks
dave
So i have a user form with image placeholder(and an image in the properties)
i have a mouse down event on this image
VBA Code:
Private Sub Image4_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
how can i call the code above to run without the user having to click the button. But the button does need to remain to let them click it.
its a save button, but sometimes the save needs to run without them needing to know.
I guess i could have a seperate macro with the save code, and call that, and also tell the save button to call that, just wondering if an easier way?
thanks
dave