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

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

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

.

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

.

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

.

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

.




.

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

.


.