GOTO inside a CALL Excel VBA

remeng · Apr 13, 2021

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?

Code:

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 · Apr 13, 2021

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 · Apr 13, 2021

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 · Apr 13, 2021

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 · Apr 13, 2021

Change your second function to a class.

Call a method.

combo · Apr 13, 2021

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

combo

mintjulep · Apr 13, 2021

Combo said:
Mind the stack

You should copyright that.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

GOTO inside a CALL Excel VBA

remeng

Technical User

Andrzejek

Programmer

remeng

Technical User

Andrzejek

Programmer

mintjulep

Technical User

combo

Technical User

mintjulep

Technical User

Similar threads

Part and Inventory Search

Sponsor