View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Problem with list

if Listbox2.Listindex < -1 then
Listbox2.list(listbox2.listindex)
End if

--
Regards,
Tom Ogilvy

"Robert Couchman" wrote in message
...
Hello all,

i have a listbox that when double clicked will open up a
record...

...BUT...

...if you have not selected a record and double click it
returns the error....

Listbox2.list(listbox2.listindex)

**apparently doesnt exist**

anyone know how to solve this problem?????

Thank you,

Robert Couchman