If Currcell = "" Then (newbie ?)

If Currcell = "" Then
MsgBox ("Could not close session, line not found.")
Else
Instead of a msgbox here, I'd like to run a private sub called
"drawingbegin()". Can someone please help me accomplish this? TIA

 

Use the "Call" statement....
If Currcell = "" Then
Call drawingbegin
Else

HTH,
Jeff

 

If Drawingbegin is in the same project, then

If Currcell = "" Then
drawingbegin
else

otherwise, same as above, but reference the project that contains
drawingbegin

Keep in mind that control will return immediately after the End If once
drawingbegin is finished.

 

Just for my own FYI,, I thought Call had gone the way of Let, and wasn't
required anymore?

 

Yeah, it's an old habit of many.
I feel better using CALL, it's easier when you're doing a visual debugging
and makes code alot easier to read.

 

Hi,

Although I never use it myself as it requires extra typing, one advantage of
Call is that the parameters are always required to be placed in brackets so
your typing conventions can be more consistent.

Given:
Function MyMacro (Parameter1, Parameter2) as Integer
.....
End Function

The three lines below are viable
MyMacro Parameter1, Parameter2
ReturnedInteger = MyMacro (Parameter1, Parameter2)
CALL MyMacro (Parameter1, Parameter2)
while the three below here aren't
MyMacro (Parameter1, Parameter2)
ReturnedInteger = MyMacro Parameter1, Parameter2
CALL MyMacro Parameter1, Parameter2


Laurie Comerford
CADApps
www.cadapps.com.au

 

Yes, you are correct.!
That's another reason why I like to use the CALL statement

 

Thanks Jeff..............You're kinda everywhere,aren't you?

 

Thanks everyone.......maybe I can get there from here.

 

Heh, you're welcome, and yeah, I look everywhere I can learn or might
even help someone else to learn......

Jeff