Format Cells Dialog from a Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scott56hannah - 28 May 2008 07:24 GMT

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

Reply to this Message

Gary Keramidas - 28 May 2008 07:54 GMT

not sure if this is what you want or not.

application.dialogs(xlDialogActiveCellFont).Show

Signature

Gary

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks
> Scott

Reply to this Message

scott56hannah - 28 May 2008 08:05 GMT

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

> not sure if this is what you want or not.
>
[quoted text clipped - 11 lines]
> > Thanks
> > Scott

Reply to this Message

Gary Keramidas - 28 May 2008 07:58 GMT

in vb help, search for this

Built-In Dialog Box Argument Lists

you'll see them all

Signature

Gary

> Hi,
>
[quoted text clipped - 7 lines]
> Thanks
> Scott

Reply to this Message