T
tommo_blade
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.
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.