How to go to a specific cell address from a ListBox selection and Highlight it

[simora]

I am populating a listbox like:



.RowSource = Worksheets("Sheet2").Range("A2", Range("H655").End(xlUp)).Address .
. ColumnWidths = "90;95;100;90;80;80;31;80"
.ListStyle = fmListStyleOption


When I make a listBox selection, how can I go to Column E of the selected row on the WorkSheet and highlight it temporarily; X Seconds
{ The Column E Cell Address }

[Paul_Hossler]

Give this a try

You'll have to change a lot of things, but should give you the general idea

[simora]

Paul_Hossler (http://www.vbaexpress.com/forum/member.php?9803-Paul_Hossler)

Thank You Sir.

BTW: If anyone is getting an error with the included code


Private Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


Change it to


Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


That should work.