ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   create columns within a text box (https://www.excelbanter.com/excel-discussion-misc-queries/194967-create-columns-within-text-box.html)

Lynn

create columns within a text box
 
If a text box has been created within Excel - can colums be inserted. I have
tried but no luck. Tab also does work - the only way seems to be spacing over
which is time consuming.

FSt1

create columns within a text box
 
hi
a text box control is for text. it does not have a column count property
that i am aware of. a list box has a column count property but a list box is
very different from a text box. you didn't say much about what the perpose of
the text box was for so i can only suggest an alternative knowing that the
alternative may be unsuitable for your situation.

regards
FSt1

"Lynn" wrote:

If a text box has been created within Excel - can colums be inserted. I have
tried but no luck. Tab also does work - the only way seems to be spacing over
which is time consuming.


Lynn

create columns within a text box
 
Hi:
Thanks for the quick response. I was just trying to cut down on space within
the text box - instead of listing the points I was trying to place them side
by side. I solved the problem by placing two same size text boxes side by
side - the solution is the same - the process just a little longer.

Thanks again.



"FSt1" wrote:

hi
a text box control is for text. it does not have a column count property
that i am aware of. a list box has a column count property but a list box is
very different from a text box. you didn't say much about what the perpose of
the text box was for so i can only suggest an alternative knowing that the
alternative may be unsuitable for your situation.

regards
FSt1

"Lynn" wrote:

If a text box has been created within Excel - can colums be inserted. I have
tried but no luck. Tab also does work - the only way seems to be spacing over
which is time consuming.


FSt1

create columns within a text box
 
hi
good that you are hangin in there. mark of a good programmer. sorry i could
not provide a viable solution to your delima but it seems you have worked
that out on your own. but a year from now, if you're like most programmers,
while re-reading your code, you will be asking yourself......"what was i
thinking when i wrote this crap."

regards
FSt1

"Lynn" wrote:

Hi:
Thanks for the quick response. I was just trying to cut down on space within
the text box - instead of listing the points I was trying to place them side
by side. I solved the problem by placing two same size text boxes side by
side - the solution is the same - the process just a little longer.

Thanks again.



"FSt1" wrote:

hi
a text box control is for text. it does not have a column count property
that i am aware of. a list box has a column count property but a list box is
very different from a text box. you didn't say much about what the perpose of
the text box was for so i can only suggest an alternative knowing that the
alternative may be unsuitable for your situation.

regards
FSt1

"Lynn" wrote:

If a text box has been created within Excel - can colums be inserted. I have
tried but no luck. Tab also does work - the only way seems to be spacing over
which is time consuming.



All times are GMT +1. The time now is 02:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com