BostonBob
asked on
Cannot call subs in different sheets
Hi All,
I am "self voting" this my most provincial question to date but I can't figure it out. I have tried youtube and the usual places to get this kind of question asked.
I have a huge spreadsheet filled with VBA code from one end to the other.
In sheet19 I am trying to call a sub (not private) that is in sheet2.
My code goes something like this:
my sub()
'code here
'code here
'code here
call SubS2 'Sub from Sheet2 and it is not private so it should work
End Sub
So I know that I am doing something so silly that it hurts.
I have tried call sheet2.SubS2....and that does not work.
Any help is much appreciated.
Any cheap shots are surely warranted. :)
thanks for your help!
I am "self voting" this my most provincial question to date but I can't figure it out. I have tried youtube and the usual places to get this kind of question asked.
I have a huge spreadsheet filled with VBA code from one end to the other.
In sheet19 I am trying to call a sub (not private) that is in sheet2.
My code goes something like this:
my sub()
'code here
'code here
'code here
call SubS2 'Sub from Sheet2 and it is not private so it should work
End Sub
So I know that I am doing something so silly that it hurts.
I have tried call sheet2.SubS2....and that does not work.
Any help is much appreciated.
Any cheap shots are surely warranted. :)
thanks for your help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Not sure why you'd have code attached to every sheet, but it should still work. I prefer to put nearly everything in modules, but that's just a preference.
I also suggest prefixing public functions with public, just for readability.
If in sheet1 you have
Open in new window
and in sheet 2 you have
Open in new window
if you fun CallTheThingFromOne, it should display "From Sheet 1" in a message box.
Test that out for us?
If that doesn't work, or if you need more help, attach a sample.