preselect listbox item

[greg kramer]

I know that you can select an item or preselect an item with the following syntax:

listbox.selected(1) = true

but how would one convert the 1 to text from another source so that it would work the same way

that is,

listbox.selected("word")=true

probably not formulating the question very well but any thoughts would be appreciated.

 

[Rasm]

LOL - No biggie - I prefer Timmy's coffee - I am in Canada - if you get a type mismatch make sure that it is a string comparison (how did you dimension your value" - maybe poste a bit of the code - just to illustrate the problem.

 

[Norie]

Greg

Is the value you want to preselect definitely going to be in the list?

Dim dftIndex
 
Dim DftIndex
Dim DftValue As String
 
    DftValue = Range("DefaultValue").Value

    DftIndex = Application.Match(DftValue, Range(ListBox1.ListFillRange), 0)
 
    If Not IsError(DftIndex) Then
        ListBox1.Selected(DftIndex - 1) = True
    End If

 

[greg kramer]

Thank you all for your assistance!

Was able to get some code working.

Hope I'm able to start being contributer rather than a taker soon.

Regards,

Greg