Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
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 . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Yes i work with VBA the list box is on a userform.
that code it tryed it did not work. do i need to put this code in the Initialize, "redeagle" wrote: 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 . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Hi tbailey-
If you are using a userform then replace "sheet1" with "Me" and "ListBox1" with whatever the name of the listbox is on your form. You should place this code after the code that adds an item to the list box. John "tbailey" wrote: Yes i work with VBA the list box is on a userform. that code it tryed it did not work. do i need to put this code in the Initialize, "redeagle" wrote: 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 . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
thank you for that part. now i just need it to stop at the first empty cell,
it go all the way to 65536 "redeagle" wrote: Hi tbailey- If you are using a userform then replace "sheet1" with "Me" and "ListBox1" with whatever the name of the listbox is on your form. You should place this code after the code that adds an item to the list box. John "tbailey" wrote: Yes i work with VBA the list box is on a userform. that code it tryed it did not work. do i need to put this code in the Initialize, "redeagle" wrote: 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 . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select "tbailey" wrote: thank you for that part. now i just need it to stop at the first empty cell, it go all the way to 65536 "redeagle" wrote: Hi tbailey- If you are using a userform then replace "sheet1" with "Me" and "ListBox1" with whatever the name of the listbox is on your form. You should place this code after the code that adds an item to the list box. John "tbailey" wrote: Yes i work with VBA the list box is on a userform. that code it tryed it did not work. do i need to put this code in the Initialize, "redeagle" wrote: 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 . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
listbox
Sheet1.ListBox1.ListIndex = Sheet1.ListBox1.ListCount - 1
Range("A1").selection Ramge(Selection, Selection.End(xlDown)).Select will go to 65536 to i may need to have the listbox not show empty cell in it like this Sheet1.ListBox1.ListIndex = Sheet1.ListBox1.ListCount - 1 if cells = 0 dont show for the list box , i dont knoe the code for this? "redeagle" wrote: Range("A1").Select Range(Selection, Selection.End(xlDown)).Select "tbailey" wrote: thank you for that part. now i just need it to stop at the first empty cell, it go all the way to 65536 "redeagle" wrote: Hi tbailey- If you are using a userform then replace "sheet1" with "Me" and "ListBox1" with whatever the name of the listbox is on your form. You should place this code after the code that adds an item to the list box. John "tbailey" wrote: Yes i work with VBA the list box is on a userform. that code it tryed it did not work. do i need to put this code in the Initialize, "redeagle" wrote: 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |