May 18, 2005 #1 f64 Technical User May 23, 2003 24 US Is it possible to use the Selected property to select a row in a listbox programmatically from code?
May 18, 2005 #2 bclt Programmer Mar 13, 2005 363 GR Add a listbox (name:listbox1) and add this code: Private Sub ListBox1_Click() Dim x As Integer x = ListBox1.List(ListBox1.ListIndex) Sheet1.Rows(x & ":" & x).Select End Sub Upvote 0 Downvote
Add a listbox (name:listbox1) and add this code: Private Sub ListBox1_Click() Dim x As Integer x = ListBox1.List(ListBox1.ListIndex) Sheet1.Rows(x & ":" & x).Select End Sub