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]

 

[Fluff]

In that case is you listbox multi or single select?

 

[cmxulb]

In that case is you listbox multi or single select?

single

 

[Fluff]

Then the last item in the listbox should be selected & highlighted.

 

[cmxulb]

Then the last item in the listbox should be selected & highlighted.

No not with this code

Me.lstDatabase.TopIndex = Me.lstDatabase.ListCount - 1

 

[Fluff]

That is not what I suggested.

 

[cmxulb]

Correction, it not selecting it just scroll to the last item entered

 

[Fluff]

Have you tried the code I suggested?

 

[cmxulb]

Have you tried the code I suggested?

Did not see it. it works thank you

 

[Fluff]

You're welcome & thanks for the feedback.