ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Last item in listbox not getting displayed.- - Excel VBA appln. (https://www.excelbanter.com/excel-programming/343209-last-item-listbox-not-getting-displayed-excel-vba-appln.html)

Nazhat Aysha

Last item in listbox not getting displayed.- - Excel VBA appln.
 
In an Excel VBA Application we have a Listbox(Activex Control).the last item
though physically present is invisible (just doesn't show up though using the
down arrow key we can reach it).
We assign the list box items during run time.

for ex, if we assign 10 items to the list box the last item is not visible
though it is present there


Is there a solution to this problem ? Any pointers to the solution will also
be highly appreciated.

Tom Ogilvy

Last item in listbox not getting displayed.- - Excel VBA appln.
 
I have never had the problem, but as I recall, suggestions for this involve
the IntegralHeight property.

Try each setting (true or false) and see if either helps.

--
Regards,
Tom Ogilvy


"Nazhat Aysha" wrote in message
...
In an Excel VBA Application we have a Listbox(Activex Control).the last

item
though physically present is invisible (just doesn't show up though using

the
down arrow key we can reach it).
We assign the list box items during run time.

for ex, if we assign 10 items to the list box the last item is not visible
though it is present there


Is there a solution to this problem ? Any pointers to the solution will

also
be highly appreciated.





All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com