ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Shift Key (https://www.excelbanter.com/excel-programming/390504-shift-key.html)

pan65

Shift Key
 
To move a shape object on a sheet only up and down or left and right, you can
hold the shift key down. Is there a way thru programming to set the shift
key as pressed so that any shape object moved with only move left or right or
up and down when selected?

Thanks

NickHK

Shift Key
 
As Shapes are not ActiveX objects, they do not trigger events. As such you
do not know when a user is moving a Shape.
You could kludge something with a Timer I suppose, but...

Maybe provide the user with Nudge Up/Down/Left/Right Buttons of Spinners.

NickHK

"pan65" wrote in message
...
To move a shape object on a sheet only up and down or left and right, you

can
hold the shift key down. Is there a way thru programming to set the shift
key as pressed so that any shape object moved with only move left or right

or
up and down when selected?

Thanks





All times are GMT +1. The time now is 12:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com