Can a text box have columns, like a list box?

Must a list box always have an item (or row) selected?

Thanks - Kirk

Kirk,
1 - Basically, no. But you can fake it yourself with a fixed-width font and
spaces/tabs, but it's likely to get messy.

2 - No. Set its .ListIndex=-1

NickHK

"kirkm" wrote in message
...

Can a text box have columns, like a list box?

Must a list box always have an item (or row) selected?

Thanks - Kirk

On Fri, 2 Mar 2007 16:35:14 +0800, "NickHK"
wrote:


1 - Basically, no. But you can fake it yourself with a fixed-width font and
spaces/tabs, but it's likely to get messy.

2 - No. Set its .ListIndex=-1

Thanks - that sounds highly promising. But I can't see a ListIndex
option in the listbox properties.

I tried

Private Sub UserForm_Initialize()
List1.ListIndex = -1
End Sub

...but that didn't seem to do anything.

I'd like to use a listbox as a text display only, without anything
highlit and any user input ignored. Except Close and scroll.

Is that possible?

Thanks - Kirk

Kirk,
Sorry, I was thinking of a ComboxBox.

With a ListBox, you have to .Clear it.

However, if you only need 1 line of text, a text or label box may be better.
TextBox1.Text="Column one" & Space(4) & "Column two" & Space(4) & "Column
three"

Depends if you need the columns to line up with anything external.

NickHK

"kirkm" wrote in message
...
On Fri, 2 Mar 2007 16:35:14 +0800, "NickHK"
wrote:


1 - Basically, no. But you can fake it yourself with a fixed-width font
and
spaces/tabs, but it's likely to get messy.

2 - No. Set its .ListIndex=-1

Thanks - that sounds highly promising. But I can't see a ListIndex
option in the listbox properties.

I tried

Private Sub UserForm_Initialize()
List1.ListIndex = -1
End Sub

..but that didn't seem to do anything.

I'd like to use a listbox as a text display only, without anything
highlit and any user input ignored. Except Close and scroll.

Is that possible?

Thanks - Kirk