Carriage return character shows in combobox
 

Hello
I'm using an Active-x combobox with about 8 selection possibilities. I need
to make it in a thin column so I'm trying to use two lines when a selection
is made. Unfortunately it's coming up with the carriage return character in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any reference
toward word wrap or multiline. In the text field of the properties it has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

Carriage return character shows in combobox
 

If I understand your question correctly... the edit field of the ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any reference
toward word wrap or multiline. In the text field of the properties it has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

Carriage return character shows in combobox
 

That's correct. I can't put in text then do an alt+enter. It just beeps at
me. And if I type enough text to go past the width of the combobox it just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any reference
toward word wrap or multiline. In the text field of the properties it has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.

Carriage return character shows in combobox
 

I may not have been clear in the way I stated my post... I wasn't asking you
to confirm if that is what happened, I was telling you that the ComboBox
cannot show multiple lines of text the way I think you want it to... to the
best of my knowledge, the control simply doesn't work that way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
That's correct. I can't put in text then do an alt+enter. It just beeps at
me. And if I type enough text to go past the width of the combobox it just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.

Carriage return character shows in combobox
 

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not work.

You can increase the width.



"Rick Rothstein" wrote in message
...
I may not have been clear in the way I stated my post... I wasn't asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want it
to... to the best of my knowledge, the control simply doesn't work that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
That's correct. I can't put in text then do an alt+enter. It just beeps
at
me. And if I type enough text to go past the width of the combobox it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.

Carriage return character shows in combobox
 

That's interesting I thought it could do this but I just wasn't doing it
properly.
I tried this...
Private Sub UserForm_Load()
ComboBox3.AddItem "xp32 SAS"
ComboBox3.AddItem "xp32 & Chr(10) & Chr(13) SAS"
End Sub

....and it isn't even loading the items via the additem method.

"Rick Rothstein" wrote:

I may not have been clear in the way I stated my post... I wasn't asking you
to confirm if that is what happened, I was telling you that the ComboBox
cannot show multiple lines of text the way I think you want it to... to the
best of my knowledge, the control simply doesn't work that way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
That's correct. I can't put in text then do an alt+enter. It just beeps at
me. And if I type enough text to go past the width of the combobox it just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.


.

Carriage return character shows in combobox
 

Not trying to be a wiseguy here just trying to understand.

So if I can increase the width but only one line can show at a time will it
just make that one line wider? Or, by increasing the width I can fit a second
line in?

Steve

"JLGWhiz" wrote:

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not work.

You can increase the width.



"Rick Rothstein" wrote in message
...
I may not have been clear in the way I stated my post... I wasn't asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want it
to... to the best of my knowledge, the control simply doesn't work that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
That's correct. I can't put in text then do an alt+enter. It just beeps
at
me. And if I type enough text to go past the width of the combobox it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in message
...
Hello
I'm using an Active-x combobox with about 8 selection possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.




.

Carriage return character shows in combobox
 

Increasing the width will allow you to read more of what you put on one
line. You cannot have a second line in a combobox display window where the
user makes input or the selection is shown. I do not know what you are
trying to do, but perhaps you should think about using a textbox or a label
to do it, if you must have a second line. You can always use code to write
messages for user interface. There is always an alternative method to
accomplish the end product.


"SteveZmyname" wrote in message
...
Not trying to be a wiseguy here just trying to understand.

So if I can increase the width but only one line can show at a time will
it
just make that one line wider? Or, by increasing the width I can fit a
second
line in?

Steve

"JLGWhiz" wrote:

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not
work.

You can increase the width.



"Rick Rothstein" wrote in message
...
I may not have been clear in the way I stated my post... I wasn't asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want it
to... to the best of my knowledge, the control simply doesn't work that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
That's correct. I can't put in text then do an alt+enter. It just
beeps
at
me. And if I type enough text to go past the width of the combobox it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
Hello
I'm using an Active-x combobox with about 8 selection
possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of
thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties
it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.




.

Carriage return character shows in combobox
 

Thanks for elaborating I have a better understanding now.
Maybe I should mention what I'm trying to do.
I need to use thin columns since this sheet is very wide and would like to
fit it all on one screen. Plus the nature of the information to display looks
better if it is on two lines. Also the user needs to be able to choose from a
list or add a selection to it. I thought the combobox would be the best way
to go but didn't see all these hurdles in the way.

"JLGWhiz" wrote:

Increasing the width will allow you to read more of what you put on one
line. You cannot have a second line in a combobox display window where the
user makes input or the selection is shown. I do not know what you are
trying to do, but perhaps you should think about using a textbox or a label
to do it, if you must have a second line. You can always use code to write
messages for user interface. There is always an alternative method to
accomplish the end product.


"SteveZmyname" wrote in message
...
Not trying to be a wiseguy here just trying to understand.

So if I can increase the width but only one line can show at a time will
it
just make that one line wider? Or, by increasing the width I can fit a
second
line in?

Steve

"JLGWhiz" wrote:

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not
work.

You can increase the width.



"Rick Rothstein" wrote in message
...
I may not have been clear in the way I stated my post... I wasn't asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want it
to... to the best of my knowledge, the control simply doesn't work that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
That's correct. I can't put in text then do an alt+enter. It just
beeps
at
me. And if I type enough text to go past the width of the combobox it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
Hello
I'm using an Active-x combobox with about 8 selection
possibilities. I
need
to make it in a thin column so I'm trying to use two lines when a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of
thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the properties
it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.




.



.

Carriage return character shows in combobox
 

ComboBox and ListBox controls are good for listing things like part numbers,
names and other types of data that can be displayed in columns of manageable
width. They do not really lend themselves to narrative strings, although
some folks do use them for that type of data by estending the width of the
control. My personal preference is to use the worksheet for lengthy
narrative data and to arrange the worksheet layout so that less lengthy data
can be used to index the narrative data. This allows the use of controls
with underlying code to use the indexed data to locate the length narrative
data if needed. A little planning goes a long way in this type exercise.



"SteveZmyname" wrote in message
...
Thanks for elaborating I have a better understanding now.
Maybe I should mention what I'm trying to do.
I need to use thin columns since this sheet is very wide and would like to
fit it all on one screen. Plus the nature of the information to display
looks
better if it is on two lines. Also the user needs to be able to choose
from a
list or add a selection to it. I thought the combobox would be the best
way
to go but didn't see all these hurdles in the way.

"JLGWhiz" wrote:

Increasing the width will allow you to read more of what you put on one
line. You cannot have a second line in a combobox display window where
the
user makes input or the selection is shown. I do not know what you are
trying to do, but perhaps you should think about using a textbox or a
label
to do it, if you must have a second line. You can always use code to
write
messages for user interface. There is always an alternative method to
accomplish the end product.


"SteveZmyname" wrote in message
...
Not trying to be a wiseguy here just trying to understand.

So if I can increase the width but only one line can show at a time
will
it
just make that one line wider? Or, by increasing the width I can fit a
second
line in?

Steve

"JLGWhiz" wrote:

Hi Rick, I will paraphrase you.

Trying to put more than one line in a combobox display window will not
work.

You can increase the width.



"Rick Rothstein" wrote in
message
...
I may not have been clear in the way I stated my post... I wasn't
asking
you to confirm if that is what happened, I was telling you that the
ComboBox cannot show multiple lines of text the way I think you want
it
to... to the best of my knowledge, the control simply doesn't work
that
way.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
That's correct. I can't put in text then do an alt+enter. It just
beeps
at
me. And if I type enough text to go past the width of the combobox
it
just
keeps goes out of sight.

"Rick Rothstein" wrote:

If I understand your question correctly... the edit field of the
ComboBox
does not support multiple lines of text.

--
Rick (MVP - Excel)


"SteveZmyname" wrote in
message
...
Hello
I'm using an Active-x combobox with about 8 selection
possibilities. I
need
to make it in a thin column so I'm trying to use two lines when
a
selection
is made. Unfortunately it's coming up with the carriage return
character
in
the selection. I guess that's what it is a backwards P sort of
thing.

Looking through the properties for the control I didn't see any
reference
toward word wrap or multiline. In the text field of the
properties
it
has
little rectangle boxes that I can't delete.

Any way to make this ugly backwards P go away?
I tried a few things such as...

sub combobox1_Click()
char(10)
End Sub

.




.



.