Thread: VBA ListBox
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 1,071
Default VBA ListBox

Check the ListIndex property. It will be -1 if no selection has been
made. For more, check the VBA help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Can anyone please tell me how to check that the user has made a selection in
a VBA ListBox - I need to warn them if no selection has been made

Thanks

TAM