View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default move the cursor to a button

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

--
HTH. Best wishes Harald
Followup to newsgroup only please.

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



"Joachim Geschinsky" schrieb im Newsbeitrag
...
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