Reply to thread

Message: [QUOTE="tommo_blade, post: 6346124"] Hi, I have some code in my Excel spreadsheet that pops up a listbox when a certain cell is selected, the contents of that listbox are pulled from a hidden sheet within the excel workbook. My problem is in getting the last row of data visible in the list box, it is just visible at the bottom of the listbox but the vertical scroll will not scroll down any further, if I go into the code and adjust the 'height' property then go back to the screadsheet and select the cell I can see the last row of data ok, when I save the changes, close down excel & re-open again the problem has re-occurred, here are the listbox properties I am using:- MidfieldersListBox.Visible = True MidfieldersListBox.Left = 354 MidfieldersListBox.Width = 531 MidfieldersListBox.Height = 300 MidfieldersListBox.Top = 10 I seem to be able to get the last row of data visible by altering either the width or height property but as described above it is lost when I close/open the spreadsheet - is this a know issue and is there a workaround. thanks in advance, Mark. [/QUOTE]