listbox not showing or not scrolling last value in Excel

It is for Excel programming like Macro, function, formula, Pivot and other platform support..
forum_admin
Site Admin
Posts: 183
Joined: Wed Jul 16, 2014 9:22 pm
Contact:

listbox not showing or not scrolling last value in Excel

Postby forum_admin » Fri Aug 15, 2014 6:41 pm

I can't figure out why the last item of a listbox is not showing up properly in Excel VBA worksheet.
Excel listbox that can't scroll the last element into view. I mean i am not able to see he last value in Listbox. I can see it but less than half or nothing.
Is vba code changing the height?


Guest

Re: listbox not showing or not scrolling last value in Excel

Postby Guest » Fri Aug 15, 2014 8:15 pm

it may happen as your listbox size is varying. you can add below logic when you fill the values in listbox

Code: Select all

ActiveSheet.Shapes("ListBox").Select
        Selection.ShapeRange.LockAspectRatio = msoFalse
        Selection.ShapeRange.Height = 66.75
        Selection.ShapeRange.Width = 177.75


Return to “Microsoft Excel and VBA Forum”

Who is online

Users browsing this forum: No registered users and 0 guests