Syntax Error

[#1]

Can anyone help fix the syntax on this macro? If the answer=6, then I want to run the macro called "format".

sub ShowPopup



Answer=MsgBox("Do you want to export search results to Excel?",4,"Export Search Results")



If Answer=6 Then

Run "format"

Else

Exit Sub     



End Sub

[MayilVahanan]

HI,

Sub ShowPopup

x=MsgBox("Would you like to export search results to Excel?",4,"Export Excel")

if x = 6 Then call exportToExcel("CH01", "C:\Export.xls")

End Sub

[#3]

Instead of exporting to Excel in the Macro, what would the syntax be to just run the macro called "format"? Sorry, the question in the message box was misleading.

[MayilVahanan · Accepted solution]

Hi,

     Use like this,

     Call Format() or call Format

     Hope it helps

[#5]

Thanks!!