[VBA] "Pick" a Worksheet Tab and save it to a variable

[PeteWright]

Hi all,
I've been deeply searching for this, but couldn't find an answer anywhere.
There is like a gazillion of topics, but none of the posted codes work for me.

So what I need is a user input (like prompt or something - or just a Mouse Pointer) to "pick" a Worksheet Tab from the bottom tabs and save it's reference to a variable.

The only thing that comes close which I found is the Application.InputBox "object" which unfortunately doesn't seem to handle all possible user inputs but a few (e.g. String, Boolean, Range) and can't cope with a selected tab.

This is one of my many code snippets which only gives me the error "Excel found a problem with one or more Formula References in this worksheet."

Sub Zero()
   Debug.Print Application.InputBox("Select a Worksheet Tab", "Select Tab", , , , , , 8)
End Sub

Any ideas on this?

 

[Domenic]

Break on Unhandled Errors is the default setting. So, unless the user changes this setting, you shouldn't have a problem.

 

[PeteWright]

Many thanks!
Then I got this fixed with your help.

 

[Domenic]

You're very welcome, I'm glad I could help.

Cheers!