View Single Post
  #1   Report Post  
Posted to microsoft.public.access.formscoding,microsoft.public.excel.programming,microsoft.public.word.vba.userforms
Jürgen Germonpré Jürgen Germonpré is offline
external usenet poster
 
Posts: 1
Default How to create a ListBox with 'hyperlink'-like items in VBA ?

Hi all,

I'm busy programming a piece of code that does some text checking on an
Excel worksheet (MS Excel 2002 (xp)). It scans the complete worksheet and
then it should return all 'corrupt' cells in a listbox from which you can
easily jump to that cell by clicking the entry in the listbox.
I was a bit charmed by the new "Find All" dialog in Excel, it's that kind of
functionality i want.

I checked the controls on my system and none of them seems to have that
functionality.
Any suggestions ? Control to look for or programming a workaround would be
welcome.

Thanks,
JG