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" <(E-Mail Removed)> wrote in message
news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
>>> > 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" <(E-Mail Removed)> wrote in message
> news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
> >> > 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
> > news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
> >> 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" <(E-Mail Removed)> wrote in message
> >>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
> >>> > 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
> >>>
> >>> .
> >>>
> >
>
>
> .
>

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" <(E-Mail Removed)> wrote in message
news:5495FDFB-7F38-4882-9B52-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> >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" <(E-Mail Removed)> wrote in
>> > message
>> > news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
>> >> 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" <(E-Mail Removed)> wrote in
>> >>> message
>> >>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
>> >>> > 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
>> >>>
>> >>> .
>> >>>
>> >
>>
>>
>> .
>>

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" <(E-Mail Removed)> wrote in message
> news:5495FDFB-7F38-4882-9B52-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:(E-Mail Removed)...
> >> >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" <(E-Mail Removed)> wrote in
> >> > message
> >> > news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
> >> >> 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" <(E-Mail Removed)> wrote in
> >> >>> message
> >> >>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
> >> >>> > 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
> >> >>>
> >> >>> .
> >> >>>
> >> >
> >>
> >>
> >> .
> >>
>
>
> .
>

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" <(E-Mail Removed)> wrote in message
news:8851F69F-937B-4949-B00D-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:5495FDFB-7F38-4882-9B52-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in
>> >> message
>> >> news:(E-Mail Removed)...
>> >> >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" <(E-Mail Removed)> wrote in
>> >> > message
>> >> > news:8D737B97-F82C-4B3D-9C50-(E-Mail Removed)...
>> >> >> 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" <(E-Mail Removed)> wrote in
>> >> >>> message
>> >> >>> news:B3181A12-6EFE-460B-AE02-(E-Mail Removed)...
>> >> >>> > 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
>> >> >>>
>> >> >>> .
>> >> >>>
>> >> >
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>