Highlight 1 row in listbox per VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I want to highlight a row in one listbox per VBA code. I tried this
cat_I.Value containing the actual value (bound column):

List10.Selected(cat_I.Value) = False
List10.Selected(cat_I.Value - 1) = True
refresh

The value of list10 is now cat_I.Value - 1 but the highlighted row is still
cat_I.Value
Can anyone help me please
Thanks
 
hallo
thanks for the message, if i take away the refresh the list will not be
resorted
 
In that case try running the refresh before setting the list box line number

List10.Requery
List10.Selected(cat_I.Value) = False
List10.Selected(cat_I.Value - 1) = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Revision to form VBA Error 6
invalid date syntax when using findfirst 2
Problem with list box 2
List/Form/SQL Help 1
Selecting Listbox items in code 2
Clear Multiselect listbox 14
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
clear/remove highlight from selected items in listbox? 2

Back
Top