Carriage return character shows in combobox

[SteveZmyname]

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

 

[Rick Rothstein]

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

 

[SteveZmyname]

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]

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.

 

[JLGWhiz]

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.

 

[SteveZmyname]

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.

 

[SteveZmyname]

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]

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]

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]

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.