Format Cells Dialog from a Macro

  • Thread starter Thread starter scott56hannah
  • Start date Start date
S

scott56hannah

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
 
in vb help, search for this

Built-In Dialog Box Argument Lists

you'll see them all
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Macro... 8
Do Until Macro 6
Conditional Formatting macro: simple, but doesn't work 6
Conditional format if difference in cell values greater than 0.50% 1
Excel Conditional Formatting Removal 7
conditional formatting for a variable range 1
Format Cells Dialog Box 3
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top