Running macro with optional parameters

[dhregan]

Hello -

I have a macro with the following signature: Sub Create_Table (Optional ByVal WCP_Special As Boolean = True). While this macro is typically called from another macro most of the time, there are some occasions when I want to call it as a standalone. However, I am unable to do that through the VBA menu. Can this be done?

 

[Fluff]

Not that I'm aware of.

 

[Rick Rothstein]

Hello -

I have a macro with the following signature: Sub Create_Table (Optional ByVal WCP_Special As Boolean = True). While this macro is typically called from another macro most of the time, there are some occasions when I want to call it as a standalone. However, I am unable to do that through the VBA menu. Can this be done?

Technically, that is not a macro, rather, it is just a plain subroutine... macros always have no arguments.

When you say "VBA menu", so you mean the dialog box that appears when you press ALT+F8 which allows you to pick the macro you want to run? If so, then the only way I can think to do what you ask is to create a macro that calls your subroutine and call it when you want to not specify the argument. Something like this...

Sub Create_Table_True()
  Call Create_Table()
End Sub

 

[dhregan]

Thanks Rick. I was hoping to avoid that approach, but it seems to be the most common way to address it.