select adjustment tab in cell format dialog

[x taol]

i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1)
using sendkey method only.

 

[Norman Jones]

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

 

[x taol]

thanks, but i want to do like that, because ctrl+z. namely undo
function.
sendkey is operated undo function. but your answer is not...