View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default getting a variable's name

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.

--
Regards,
Tom Ogilvy

"Philipp" wrote in message
...
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