Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
returning values application.dialogs(...).show
is there any way to maybe return any other (besides the boolean) value from,
for example Application.Dialogs(xlDialogFormatNumber)? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
returning values application.dialogs(...).show
Select a cell (on a new temporary worksheet???)
show the dialog rectrieve the numberformat for that cell delete the worksheet Pringles. wrote: is there any way to maybe return any other (besides the boolean) value from, for example Application.Dialogs(xlDialogFormatNumber)? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
returning values application.dialogs(...).show
Dave -
Excellent. I had the same question, and this little sequence works great. Function GetFormat(Optional sDefault As String = "") Dim b As Boolean Dim s As String Dim ws As Worksheet Application.ScreenUpdating = False Set ws = Workbooks.Add.Worksheets(1) If Len(sDefault) 0 Then ActiveCell.NumberFormat = sDefault End If b = Application.Dialogs(xlDialogFormatNumber).Show s = ActiveCell.NumberFormat Application.DisplayAlerts = False ws.Parent.Close False Application.DisplayAlerts = True Application.ScreenUpdating = True GetFormat = s End Function - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave Peterson" wrote: Select a cell (on a new temporary worksheet???) show the dialog rectrieve the numberformat for that cell delete the worksheet Pringles. wrote: is there any way to maybe return any other (besides the boolean) value from, for example Application.Dialogs(xlDialogFormatNumber)? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Application.Dialogs(xlDialogPrint).Show - prints too soon | Excel Discussion (Misc queries) | |||
are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "? | Excel Programming | |||
Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen) | Excel Programming | |||
Problems with application.Dialogs(xlDialogFormulaFind).Show | Excel Programming | |||
How to disable the Application Dialogs | Excel Programming |