-
Hi Russ, welcome!
I'm not sure what your Private Sub is for, but for the first one you could change your syntax to something like this:
[vba]Sub testoosie()
Dim HI As String
Dim gregg As String
Dim sayhi As String
gregg = vbCr & "Gregg"
HI = "Russell says Hello"
sayhi = HI & gregg
MsgBox sayhi
End Sub[/vba]
It works for me. You can call it from another sub like this:
[vba]Call testoosie[/vba]
But if it's private, you've gotta call it from the same module, else I'd just take that private off of there. Does that help any?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules