View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Paige Paige is offline
external usenet poster
 
Posts: 270
Default Setting # of Spaces for vbTab

Thanks guys!!!

"sebastienm" wrote:

Hi,
i don't think you can size the display of a vtab in this context.
You could use the Space( ) function instead.
dim myTab as string
myTab = Space(3)
However if you use this output somewhere else, having 3 spaces instead of a
tab may be an issue if a tab is expected.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Paige" wrote:

I'm using vbTab in a message box to line up columns. Is there a way to set
vbTab so that each time it is invoked it tabs only 2 spaces over versus 5?