Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Phil Sanchez   on Jan 25 In MS Office Category.

  
Question Answered By: Darrel Nelson   on Jan 25

I forgot to put "Optional" in. :-(

For the following .........

Option Explicit
Sub subMain()
subOptP1AsString
End Sub
' ------------------------------------
Sub subOptP1(Optional p1)

End Sub
' ------------------------------------
Sub subOptP1AsVariant(Optional p1 As Variant)

End Sub
' ------------------------------------
Sub subOptP1AsString(Optional p1 As String)
MsgBox "\"
End Sub

........... When I look at Tools/Macros..
subMain
subOptP1
subOptP1AsVariant

.......... All show up

But subOptP1AsString don't!

Curious don't you think.

Share: 

 

This Question has 20 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Removing the VBA SourceCode from the Workbook Or get search suggestion and latest updates.


Tagged: