Newbie questions
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
|