View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K[_2_] K[_2_] is offline
external usenet poster
 
Posts: 557
Default List Box Last Item

On Feb 17, 11:14*pm, Libby wrote:
Hello K,

I too have experienced problems with last-items in listboxes, namely not
being able to scroll down far enough to see them.
The solution that worked for me was to add a couple of blanks at the bottom
(listbox1.additem "")
This give a couple of lines of space and you can cater for them in any event
code for the listbox so that nothing happens if they're selected etc.

Libby



"K" wrote:
Hi all, I have List Box on my Sheet and the problem with the List Box
is that it not displaing the last item properly. *Please can any
friend can suggest that how can I correct this without changing its
Hight and Width.- Hide quoted text -


- Show quoted text -


Thanks Libby. I'll do the same