View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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