getting a variable's name

  • Thread starter Thread starter Philipp
  • Start date Start date
P

Philipp

Hello
I'm tired of writing debug code like:
debug.print "myValue = " & myValue

Is it possible to write a function to get a variable name and display it
with its value as above?

Thanks Phil
 
You can use the watch window in the VBE and step through the code.

You can put in a breakpoint.

See Excel VBA help for details.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top