Macro to Hit Control Button

[Travis]

Is there a way to make a macro click a control button named "Image1"

 

[Corticus]

Hi,

I assume you want to click the button to execute the code attached to the click event.

Just put this code in a new macro, and it will, in effect, 'click' it.

You can also use:
Image1.SetFocus

so the image is selected.

edit:
What's a control button?

HTH,

_________________<EMBED width="118" height="52" src="http://dacypha0.tripod.com/Images/Corticus.swf"></EMBED>
This message was edited by Corticus on 2002-11-07 12:22

 

[Juan Pablo González]

Use something like this:<pre>Private Sub CommandButton1_Click()
Call Image1_Click
End Sub

Private Sub Image1_Click()
MsgBox "Clicked on me!"
End Sub</pre>

 

[Andrew Poulsom]

Or:

Sub Test()
    Sheet1.CommandButton1.Value = True
End Sub

 

[Juan Pablo González]

On 2002-11-07 12:20, Corticus wrote:
Hi,

I assume you want to click the button to execute the code attached to the click event.

Just put this code in a new macro, and it will, in effect, 'click' it.

You can also use:
Image1.SetFocus

so the image is selected.

edit:
What's a control button?

HTH,

The SetFocus method won't fire the Click event... did you edit that part Corticus ?

 

[Corticus]

I didn't really mean to say that setfocus was clicking the button, I was just saying to take the code that was triggered by pushing the button, put it where you wanted to put the command to push the button, and at the end of the code, use setfocus to make it look like the button was pushed.

Fortunately, the MVP's showed up to set things straight

Sorry for any confusion,
Corticus