move the cursor to a button

[Joachim Geschinsky]

Hi all,

I use Win XP and XL2000

I want to move the cursor to a defined button on my sheet called
"Auswertung" when I activate this sheet.

How to solve this with vba ?

Can somebody help me ?

Achim

 

[Rob van Gelder]

Insert this code on that sheet:

Private Sub Worksheet_Activate()
Shapes("Auswertung").Select
End Sub

 

[Harald Staff]

Hi Achim

Moving the mouse pointer to this position (which will vary from one time to another) is
very complicated to do, and it is not good programming practice to "hijack" the input
devices like that.

 

[Joachim Geschinsky]

Is there no reason to use something like Range("A1").Select for BUTTONS
(llike CommandButton1.Select) ?
Achim

 

[Harald Staff]

Hi Achim

I suggest you do a few simple experiments. Here's a start:

Sub test1()
Sheet1.CommandButton1.Select
End Sub

Sub test2()
Sheet1.CommandButton1.Activate
End Sub