Fine Tune in Excel

[Guest]

Hi all,

How could I adjust position and/or size of a control using keyboard instead
of using Mouse?

Clara

 

[Guest]

Type in the values in the property window.

 

[Guest]

Hi Tom,

what i want is like in Access, i can use CTRL + Arrow or SHIFT + arrow.

Clara

 

[Peter T]

Hi Clara,

If you mean controls on a userform, Stephen Bullen's VBE Tools v2.0 can
resize & move them with shortcuts similar to those you mentioned.

http://www.oaltd.co.uk/VBETools/Default.htm

Regards,
Peter T

 

[Guest]

Peter T has provided a link to Stephen's code which gives you this capability
(further confirming that the capability is not built in). I wouldn't just
ignore the use of properties however. You may find it is not as tedious as
it may seem.

Also, if you select multiple controls, then right click, the popup contains
options for alignment and sizing of the controls.