select adjustment tab in cell format dialog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

x taol - 22 Jan 2006 00:48 GMT

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

Reply to this Message

Norman Jones - 22 Jan 2006 03:31 GMT

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

> i want to select(focus) 'adjustment' tab in cell format dialog(ctrl+1)
> using sendkey method only.
>
> *** Sent via Developersdex http://www.developersdex.com ***

Reply to this Message

x taol - 22 Jan 2006 04:31 GMT

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

Reply to this Message