macro trouble for excel

[tex1014]

I am trying to create a macro with parameters:

Sub FormatColumns(Optional fUnderscore As Boolean = False)

...

End Sub

Once the argument is added, the macro name disappears from the macro selection screen once I hit alt + F8. When I take the argument out, the macro is there. I don't want to create a duplicate macro when I could set the Boolean variable to optional.

Thanks,
Programmer Novice

 

[AlphaFrog]

You could have a 2nd macro that appears in the macro list. That 2nd macro simply calls FormatColumns

[COLOR=darkblue]Sub[/COLOR] FormatColumns_Default()
    FormatColumns
[COLOR=darkblue]End[/COLOR] [COLOR=darkblue]Sub[/COLOR]

[COLOR=darkblue]Sub[/COLOR] FormatColumns([COLOR=darkblue]Optional[/COLOR] fUnderscore [COLOR=darkblue]As[/COLOR] [COLOR=darkblue]Boolean[/COLOR] = [COLOR=darkblue]False[/COLOR])

[COLOR=green]'...[/COLOR]

[COLOR=darkblue]End[/COLOR] Sub

 

[tex1014]

AlphaFrog,

Thanks, but it is the first macro I am creating. There are no other macros on my computer.

Novice Programmer