I have a List box embedded in my spreadsheet. When I execute a macro to move down to data which is defined below my main viewing area and separated by freezing the frames, and then use another macro to go back to the top, my list box contents including the scroll arrows, disappear. All I see are the columns underneath. The List box is linked to another
sheet in my workbook.
If I click the sheet tab for the other sheet, then the tab for my current sheet, the contents of the list box re-appear.
Can't I anchor the List Box, it's linking etc. so that it remains intact no matter how I move around on the rest of the sheet. I've tried just putting the reference to both sheets in my macro using [Sheets("Blah").Select] to switch sheets but this does not work. Only if I manually do it.
Does anyone know why this happens and is there a fix for it.
Cheers.
sheet in my workbook.
If I click the sheet tab for the other sheet, then the tab for my current sheet, the contents of the list box re-appear.
Can't I anchor the List Box, it's linking etc. so that it remains intact no matter how I move around on the rest of the sheet. I've tried just putting the reference to both sheets in my macro using [Sheets("Blah").Select] to switch sheets but this does not work. Only if I manually do it.
Does anyone know why this happens and is there a fix for it.
Cheers.