Fine Tune in Excel
 

Hi all,

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

Clara
--
thank you so much for your help

Fine Tune in Excel
 

Type in the values in the property window.

--
Regards,
Tom Ogilvy



"clara" wrote:

Hi all,

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

Clara
--
thank you so much for your help

Fine Tune in Excel
 

Hi Tom,

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

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Type in the values in the property window.

--
Regards,
Tom Ogilvy



"clara" wrote:

Hi all,

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

Clara
--
thank you so much for your help

Fine Tune in Excel
 

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

"clara" wrote in message
...
Hi Tom,

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

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Type in the values in the property window.

--
Regards,
Tom Ogilvy



"clara" wrote:

Hi all,

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

Clara
--
thank you so much for your help

Fine Tune in Excel
 

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.

--
Regards,
Tom Ogilvy


"clara" wrote:

Hi Tom,

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

Clara
--
thank you so much for your help


"Tom Ogilvy" wrote:

Type in the values in the property window.

--
Regards,
Tom Ogilvy



"clara" wrote:

Hi all,

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

Clara
--
thank you so much for your help