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

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

What I am after is the ability to show the user not options for fonts, but
also the options for Number, Alignment, Border...

Is it possible to show that dialog box from a macro and then retreive the
value selected by the user and then apply that formatting to all the required
cells ?

Scott

"Gary Keramidas" wrote:

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

in vb help, search for this

Built-In Dialog Box Argument Lists

you'll see them all

--


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