Auto Highlight selected field on userform

[cmxulb]

Hello,
How can you auto higlight selected field on userform?

So basicly I need this line to be highlighted (Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1)


ListBox1.BackColor = RGB(153, 153, 255) ??????

[CODE=xls]

[/CODE]

 

[cmxulb]

Hello,
How can you auto higlight selected field on userform?

So basicly I need this line to be highlighted (Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1)


ListBox1.BackColor = RGB(153, 153, 255) ??????

 

[cmxulb]

vba

 

[Fluff]

What exactly are you trying to do?
If you just want to select the last item try

   Me.ListBox1.ListIndex = Me.ListBox1.ListCount - 1

 

[cmxulb]

Selecting the last item is working, I would like to have it highlighted to this color BackColor = RGB(153, 153, 255)

What exactly are you trying to do?
If you just want to select the last item try

   Me.ListBox1.ListIndex = Me.ListBox1.ListCount - 1

,

 

[Fluff]

Do you mean you want to change the highlight colour for the selected item?

 

[cmxulb]

Do you mean you want to change the highlight colour for the selected item?

How can I add this code BackColor = RGB(153, 153, 255 to this code Me.ListBox1.ListIndex = Me.ListBox1.ListCount - 1

 

[cmxulb]

How can I add this code BackColor = RGB(153, 153, 255 to this code Me.ListBox1.ListIndex = Me.ListBox1.ListCount - 1

it is selecting the last item entered but is not highlighted

 

[Fluff]

Can you please answer my question?

 

[cmxulb]

Do you mean you want to change the highlight colour for the selected item?

No