Newbie questions

[kirkm]

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

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

Thanks - Kirk

 

[NickHK]

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]

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

 

[NickHK]

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