Hi,

I think this may not be possible but I thought I would ask just in
case.

Can I get the results from a built in dialog box?

for example if I show the xlDialogActiveCellFont dialog box and then
the user selects which font, size etc they want, can I pass the
results to variables to be used at a later date? I have worked out
that I can evaluate the results after the user has changed the font by
using the following code:

Sub test()
Range("A1").Select
Application.Dialogs(xlDialogActiveCellFont).Show
font1 = Range("A1").Font.Name
End Sub

The problem is that I don't want the spreadsheet changed at all until
a later date. So before I go off and create my own user forms i
thought I would check to see if this is possible?

Cheers in advance.

James