not sure if this is what you want or not.

application.dialogs(xlDialogActiveCellFont).Show

--


Gary


"scott56hannah" wrote in message
...
Hi,

Is there anyway to call the Format Cells Dialog from within a Macro so that
you can ask the user what format they want to apply to a cell and then apply
it programatically ?

I have searched in a few places and I cannot find any reference or pointer
on how to do this ?

Thanks
Scott