GOTO inside a CALL Excel VBA

[remeng]

Hi,

I have 2 different macros and I want to call a specific line in the second macro from the first. Is this possible? Is there way to perform a GOTO inside a Call?

Sub reset_control_panel_defaults()

Call default_veneer_file_name (reset_file_name) 'I want it to GOTO line reset_file_name inside the default_veneer_file name macro

End Sub

Sub default_veneer_file 

'Some Code

reset_file_name:

'Some more Code

End Sub

Thanks,

Mike

 

[Andrzejek]

Avoid GoTo's (Except [tt]On Error GoTo SomeErrorHandler[/tt])

Create a new [tt][blue]Sub Reset_File_Name[/blue][/tt] and you can call it from both of your Sub's

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[remeng]

Hi Andy,

I'd like to avoid having another macro if possible. Any other ideas? Worst case I can do another common macro.

Thanks,

Mile

 

[Andrzejek]

Looks like "it's not possible to use GoTo to call code in another sub" according to this place

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[mintjulep]

Change your second function to a class.

Call a method.

 

[combo]

... or add argument to procedure. And mind the stack.

combo

 

[mintjulep]

Mind the stack

You should copyright that.