Last Item of Listbox not getting displayed
 

Dear All

I have a serious problem with the lisbox. I have placed the listbox in an
excel sheet and have populated the listbox in Workbook Open Event. The
problem is that the last item of the listbox is not getting displayed when
the user wants to select it. The same can be accessed by pressing the
beginning key and using arrow keys. But the scroll is not reaching to the
bottom.

I have tried various possibilities and used combinations of altering height,
integralheight, listbox type etc. etc. But nothing seems to work out.

Your help is urgently required.

Regards

Last Item of Listbox not getting displayed
 

How are you populating the listbox?
What is the "beginning key?"
What "arrow keys" -- the keyboard up and down arrow?
Show us some code.

LA

"Raj" wrote in message
...
Dear All

I have a serious problem with the lisbox. I have placed the listbox in an
excel sheet and have populated the listbox in Workbook Open Event. The
problem is that the last item of the listbox is not getting displayed when
the user wants to select it. The same can be accessed by pressing the
beginning key and using arrow keys. But the scroll is not reaching to the
bottom.

I have tried various possibilities and used combinations of altering
height,
integralheight, listbox type etc. etc. But nothing seems to work out.

Your help is urgently required.

Regards