Thread: Quote constant?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_3_] Charlotte E.[_3_] is offline
external usenet poster
 
Posts: 160
Default Quote constant?

I like this one :-)

Both makes the variable global, but also opens up for temporary use of
the variable for other purposes - as long as you remember to set it back :-)

Thanks,

CE


Den 13.04.2013 20:18, GS skrev:
I'd set this up as a global variable...

Public vbQuote$

...and initialize its value in my InitGlobals procedure at startup...

vbQuote = Chr(34)

...so in the Immediate Window, typing...

?vbquote

...returns

"