Thread: listbox
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
redeagle redeagle is offline
external usenet poster
 
Posts: 12
Default listbox

Hi tbailey-

If you are familiar with VBA, try using somthing like:

Sheet1.ListBox1.ListIndex = Sheet1.ListBox1.ListCount - 1

John



"tbailey" wrote:

Hi all i have a listbox that shows all that data enterd on a sheet1 the
listboxs just shows it but , i would like the listbox to go to that last
entery in the list , the list is long that way you dont have to sroll-down
the list to see what you just enterd .