View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default moving controls in X & Y axis

hmmm, too bad, it is quite cumbersome, quicker just to move it freehand, and
realign with the other control...
thanks.


"Rick Rothstein (MVP - VB)" wrote:

In the compiled version of VB, the IDE allows you to move controls using the
arrow keys coupled with the Ctrl key; however, it seem the IDE designers in
VBA did not implement that very useful key combination. The only way I could
find to do what you want is somewhat cumbersome to do and it assumes you
have your "Align Controls to Grid" option enabled. Let's say you want to
move you control horizontally... click on Tools/Options on the menu bar,
click the General tab and change the Grid Units Height to 60 (make sure
there is a check mark in the "Align Controls to Grid" CheckBox) and then
press OK. You will now be able to move your control left and right without
worrying about vertical movement. To move your control vertically instead of
horizontally, do the same as above except set the Grid Units Height to 60
instead.

Rick


"Charlie" wrote in message
...
Is there a hotkey that you can use when moving a control on a userform
that
will only allow X or Y axis movement, so if you've already aligned it up
with
another control, you don't have to realign it again if you need to move it
closer?