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

What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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

Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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.




"Bob Phillips" wrote in message
...
Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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 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 *


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.




"Bob Phillips" wrote in message
...
Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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 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.


"Rob Bovey" wrote in message
...
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 *


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.




"Bob Phillips" wrote in message
...
Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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 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

"Rob Bovey" wrote in message
...
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 *


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
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.




"Bob Phillips" wrote in message
...
Same purpose as a tab character in a document?

Bob

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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

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.


"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
What would be the purpose of putting a tab character in a TextBox?

--

Vasant


"Dirk" <dirk.kapusta@reply_in_newsgroup wrote in message
...
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