Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
move the cursor to a button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
move the cursor to a button
Insert this code on that sheet:
Private Sub Worksheet_Activate() Shapes("Auswertung").Select End Sub "Joachim Geschinsky" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
move the cursor to a button
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. -- HTH. Best wishes Harald Followup to newsgroup only please. "Joachim Geschinsky" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
move the cursor to a button
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move cursor on one sheet moves cursor on all sheets | Excel Discussion (Misc queries) | |||
Move cursor to next row | Excel Discussion (Misc queries) | |||
Move Cursor to A1 | Excel Discussion (Misc queries) | |||
How to get Control M to move cursor down | Excel Programming | |||
HOW TO MOVE CURSOR | Excel Programming |