Calling a routine (XP02)

Topic

New Reply

In XL97 I used a private sub with the following line of code: Call Sheet3.Start

Since I switched to XP the line of code errors out.

Any suggestions?
Thanks,
John

Reply | Quote

Replies

Obviously “Call” is not part of the Object Library.

Are you trying to Select Sheet3 or Activate? Or is this another macro? If so, you can just use the macro name, and it will run at that point.

Reply | Quote

Obviously “Call” is not part of the Object Library.

Are you trying to Select Sheet3 or Activate? Or is this another macro? If so, you can just use the macro name, and it will run at that point.

Reply | Quote

Neither. The Microsoft Excel Object named Sheet3 contains “Sub Start()”. I’m trying to call or run “Sub Start()” from that object. There is a UserForm button that is clicked to call the sub-routine.

John

Reply | Quote

Should be able to use just the name “Start” (without the quotes, although “Start” may be a inadvisable name to use for macro)

Reply | Quote

Should be able to use just the name “Start” (without the quotes, although “Start” may be a inadvisable name to use for macro)

Reply | Quote

Neither. The Microsoft Excel Object named Sheet3 contains “Sub Start()”. I’m trying to call or run “Sub Start()” from that object. There is a UserForm button that is clicked to call the sub-routine.

John

Reply | Quote

I can’t test on XP ( I still use XL97), but did you try:

[Sheet3].start

Steve

Reply | Quote

Steve,

Your suggestion worked but XP gave me issues along the way. I had to take the code out of the XL sheet object, paste it into a new module and then cut/paste it back to the XL object.

Yikes!!
John

John

Reply | Quote

Steve,

Your suggestion worked but XP gave me issues along the way. I had to take the code out of the XL sheet object, paste it into a new module and then cut/paste it back to the XL object.

Yikes!!
John

John

Reply | Quote

I can’t test on XP ( I still use XL97), but did you try:

[Sheet3].start

Steve

Reply | Quote