Format Painter Short Cut?

[dave]

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

 

[Jay Freedman]

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.

 

[Michael]

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:

 

[Jay Freedman]

Hi Michael,

The original question was only about Word. There is no such shortcut in
Excel. For a workaround, see
http://groups.google.com/[email protected].

 

[Malik Al-Amin]

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