ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using arrow keys to move form objects (https://www.excelbanter.com/excel-programming/368911-using-arrow-keys-move-form-objects.html)

Post Tenebras Lux

Using arrow keys to move form objects
 
I'm used to Access form design where <CTRL Arrow key will move a form
object, such as a textbox or control object, by one pixel. I've just started
designing forms in the Excel VBE, and find that I'm unable to make the form
object move with those key strokes.

Is it possible to "nudge" the form object in Excel design using keystrokes,
or is this only an Access feature? I know I can select and drag, but the
movements are too big.

Thanks!


Die_Another_Day

Using arrow keys to move form objects
 
Try Stephen Bullen's Nudge Tool. I've not used my self but heard that
it is great.
http://www.oaltd.co.uk/vbetools/

Die_Another_Day
Post Tenebras Lux wrote:
I'm used to Access form design where <CTRL Arrow key will move a form
object, such as a textbox or control object, by one pixel. I've just started
designing forms in the Excel VBE, and find that I'm unable to make the form
object move with those key strokes.

Is it possible to "nudge" the form object in Excel design using keystrokes,
or is this only an Access feature? I know I can select and drag, but the
movements are too big.

Thanks!



Post Tenebras Lux

Using arrow keys to move form objects
 
Thanks. It's excellent. Just what I needed.

Are you implying that you cannot use the arrow keys to move form objects in
Excel?

"Die_Another_Day" wrote:

Try Stephen Bullen's Nudge Tool. I've not used my self but heard that
it is great.
http://www.oaltd.co.uk/vbetools/

Die_Another_Day
Post Tenebras Lux wrote:
I'm used to Access form design where <CTRL Arrow key will move a form
object, such as a textbox or control object, by one pixel. I've just started
designing forms in the Excel VBE, and find that I'm unable to make the form
object move with those key strokes.

Is it possible to "nudge" the form object in Excel design using keystrokes,
or is this only an Access feature? I know I can select and drag, but the
movements are too big.

Thanks!





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

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