View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_6_] kirkm[_6_] is offline
external usenet poster
 
Posts: 156
Default Newbie questions

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