how to put tab character into textbox?

  • Thread starter Thread starter Vasant Nanavati
  • Start date Start date
Hello

Is there a way to insert a string with enclosed tab characters into a
textbox?
I tried with chr(9) but i don't get a tab only a placeholder for an
unprintable character.

Thanks
 
Hi Bob:

I was confused because a TextBox is a control in which one (generally)
manually enters data. What would be the purpose of having a preformatted tab
chatracter in there? But maybe I've just lived a sheltered life ... ;-)

Regards,

Vasant.
 
Hi Vasant, Bob,

As far as I know, there's no problem putting tab characters into an
MSForms TextBox. I'm assuming that the OP is talking about a TextBox drawing
object on a worksheet?

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Hi Rob:

I just took the OP's word for what was happening (Chr(9) was producing a
placeholder character rather than a tab), but of course you are correct. So
quite possibly the OP is indeed talking about a drawing object textbox on a
worksheet.

I didn't bother to test it because I still can't conceive of a good reason
to use a tab character within a textbox, but as I said earlier, I probably
have a limited imagination <g>.

Regards,

Vasant.
 
The textbox (drawings object) is placed on a chart and the content is
generated by code from other places in the document. The purpose is to align
the data in several lines.
 
Hi Rob, Vasant,

I agree that this is the case.

When I replied to Vasant, I wasn't suggesting what could and what couldn't
be done, I was just saying that I could understand the OP's request, because
tabs are generally used to space data and align multiple lines. Might be odd
in a textbox as we generally think of this as a way of capturing/displaying
singleton items, but seems quite easy to understand why someone might want
to, even if the advice was to use some other way.

Regards

Bob
 
Back
Top