If Currcell = "" Then (newbie ?)

If Currcell = "" Then (newbie ?)

Anonymous
Not applicable
730 Views
9 Replies
Message 1 of 10

If Currcell = "" Then (newbie ?)

Anonymous
Not applicable
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
0 Likes
731 Views
9 Replies
Replies (9)
Message 2 of 10

Anonymous
Not applicable
Use the "Call" statement.... If Currcell = "" Then Call drawingbegin Else HTH, Jeff "rewilson" wrote in message news:13934741.1077918568829.JavaMail.jive@jiveforum1.autodesk.com... > 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
0 Likes
Message 3 of 10

Anonymous
Not applicable
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. -- Ben - cheesy creamy cheesy My mother called me that once.... once! ------------------------------------------------------------------------ Ben's Profile: http://www.vbdesign.net/expresso/member.php?action=getinfo&userid=201 View this thread: http://www.vbdesign.net/expresso/showthread.php?threadid=59845
0 Likes
Message 4 of 10

Anonymous
Not applicable
Just for my own FYI,, I thought Call had gone the way of Let, and wasn't required anymore? -- Ben - cheesy creamy cheesy My mother called me that once.... once! ------------------------------------------------------------------------ Ben's Profile: http://www.vbdesign.net/expresso/member.php?action=getinfo&userid=201 View this thread: http://www.vbdesign.net/expresso/showthread.php?threadid=59845
0 Likes
Message 5 of 10

Anonymous
Not applicable
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. -- Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica (sorry, phony e-mail, SPAM made me do it) "Ben" wrote in message news:Ben.12b2fy@vbdesign.net... > > Just for my own FYI,, I thought Call had gone the way of Let, and wasn't > required anymore? > > > -- > Ben - cheesy creamy cheesy > > My mother called me that once.... once! > ------------------------------------------------------------------------ > Ben's Profile: http://www.vbdesign.net/expresso/member.php?action=getinfo&userid=201 > View this thread: http://www.vbdesign.net/expresso/showthread.php?threadid=59845 >
0 Likes
Message 6 of 10

Anonymous
Not applicable
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 "Jorge Jimenez" wrote in message news:403fce94_1@newsprd01... > 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. > > -- > Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica > (sorry, phony e-mail, SPAM made me do it) > > "Ben" wrote in message > news:Ben.12b2fy@vbdesign.net... > > > > Just for my own FYI,, I thought Call had gone the way of Let, and wasn't > > required anymore? > > > > > > -- > > Ben - cheesy creamy cheesy > > > > My mother called me that once.... once! > > ------------------------------------------------------------------------ > > Ben's Profile: > http://www.vbdesign.net/expresso/member.php?action=getinfo&userid=201 > > View this thread: > http://www.vbdesign.net/expresso/showthread.php?threadid=59845 > > > >
0 Likes
Message 7 of 10

Anonymous
Not applicable
Yes, you are correct.! That's another reason why I like to use the CALL statement -- Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica (sorry, phony e-mail, SPAM made me do it) "Laurie Comerford" wrote in message news:403fd1d0_1@newsprd01... > 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 > > > "Jorge Jimenez" wrote in message > news:403fce94_1@newsprd01... > > 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. > > > > -- > > Saludos, Ing. Jorge Jimenez, SICAD S.A., Costa Rica > > (sorry, phony e-mail, SPAM made me do it) > > > > "Ben" wrote in message > > news:Ben.12b2fy@vbdesign.net... > > > > > > Just for my own FYI,, I thought Call had gone the way of Let, and wasn't > > > required anymore? > > > > > > > > > -- > > > Ben - cheesy creamy cheesy > > > > > > My mother called me that once.... once! > > > ------------------------------------------------------------------------ > > > Ben's Profile: > > http://www.vbdesign.net/expresso/member.php?action=getinfo&userid=201 > > > View this thread: > > http://www.vbdesign.net/expresso/showthread.php?threadid=59845 > > > > > > > > >
0 Likes
Message 8 of 10

Anonymous
Not applicable
Thanks Jeff..............You're kinda everywhere,aren't you?
0 Likes
Message 9 of 10

Anonymous
Not applicable
Thanks everyone.......maybe I can get there from here.
0 Likes
Message 10 of 10

Anonymous
Not applicable
Heh, you're welcome, and yeah, I look everywhere I can learn or might even help someone else to learn...... Jeff "rewilson" wrote in message news:19146346.1077937866647.JavaMail.jive@jiveforum2.autodesk.com... > Thanks Jeff..............You're kinda everywhere,aren't you?
0 Likes