Format Painter Short Cut?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dave - 13 Oct 2004 02:11 GMT

Does anyone know the format painter short cut keys?
ty
dave

Reply to this Message

Jay Freedman - 13 Oct 2004 14:29 GMT

Hi Dave,

By default, it's Ctrl+Shift+C to copy the format at the highlight, and
Ctrl+Shift+V to paste that format at another location. Think "copy" (Ctrl+C)
and "paste" (Ctrl+V) with Shift to denote "formatting".

In the Tools > Customize and Tools > Customize > Keyboard dialogs, these are
listed under All Commands as CopyFormat and PasteFormat, respectively.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

> Does anyone know the format painter short cut keys?
> ty
> dave

Reply to this Message

Michael - 15 Nov 2004 14:39 GMT

Hi Jay

I can get that short cut to work in Word, but not in Excel, any clue why
that is?

Could be that Im using Excel 2002?

- Michael

"Jay Freedman" skrev:

> Hi Dave,
>
[quoted text clipped - 8 lines]
> > ty
> > dave

Reply to this Message

Jay Freedman - 15 Nov 2004 18:59 GMT

Hi Michael,

The original question was only about Word. There is no such shortcut in
Excel. For a workaround, see
http://groups.google.com/groups?threadm=45QwO0ILEHA.2192%40cpmsftngxa10.phx.gbl.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

> Hi Jay
>
[quoted text clipped - 26 lines]
>>> ty
>>> dave

Reply to this Message

Malik Al-Amin - 07 Dec 2004 18:14 GMT

Hi Dave,

Thanks for the feedback.
This is the code that I have in the ShowFileDialog:

Sub ShowFileDialog()
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog( _
FileDialogType:=msoFileDialogOpen)
With dlgOpen
.AllowMultiSelect = True
.Show
End With
End Sub

the .show method opens the dialog box but if I click on a file that file
doesn't open. Do I have to explicitly open it and if so how do I pass the
same name the user selected?

Thanks

Malik

> Hi Jay
>
[quoted text clipped - 19 lines]
> > > ty
> > > dave

Reply to this Message