| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fine tune scroll amount | Excel Discussion (Misc queries) | |||
| Fine tune the counting area by setting up parameters | New Users to Excel | |||
| Excel 2002 : Can I fine tune the Subtotal Table ? | Excel Discussion (Misc queries) | |||
| Fine-Tune Multi-Condition Formula | Excel Worksheet Functions | |||
| Want to fine tune VLOOKUP formula given last week | New Users to Excel | |||
Linear Mode
