I have an excel spreadsheet that has several listboxes. Each listbox selection is hidden and appears when you click on a particular cell and the entry is tied to a cell; I then have code that automatically hides/unhides sets of rows based upon that selection.
What I need to do, is to have the listbox automatically move up or down in the worksheet as if the location is tied to a particular row, so that when the user clicks on the cell, the listbox is right next to it.
I've been searching for hours and I truly hope that somebody can help me with this.
What I need to do, is to have the listbox automatically move up or down in the worksheet as if the location is tied to a particular row, so that when the user clicks on the cell, the listbox is right next to it.
I've been searching for hours and I truly hope that somebody can help me with this.