Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select adjustment tab in cell format dialog
i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1) using sendkey method only. *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
select adjustment tab in cell format dialog
Hi X Taol,
I am not sure which tab you want, but it should be possible to display the required tab by using the dialogs collection, without recourse to SendKeys, For example, if by 'adjustment tab' you mean the alignment tab, try: Application.Dialogs(xlDialogAlignment).Show The other tabs can each be accessed with one of the following instructions: Application.Dialogs(xlDialogFormatNumber).Show Application.Dialogs(xlDialogFormatFont).Show Application.Dialogs(xlDialogBorder).Show Application.Dialogs(xlDialogPatterns).Show Application.Dialogs(xlDialogProtectDocument).Show --- Regards, Norman "x taol" wrote in message ... i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1) using sendkey method only. *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
select adjustment tab in cell format dialog
thanks, but i want to do like that, because ctrl+z. namely undo function. sendkey is operated undo function. but your answer is not... *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell format dialog box will not open | Excel Discussion (Misc queries) | |||
cell color adjustment using vba | Excel Programming | |||
format cell tabs hidden in excel dialog box | Excel Discussion (Misc queries) | |||
3 format cell tabs hidden in excel dialog box | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |