tiso
04-28-2006, 03:37 AM
I have a worksheet with about 200 columns of data. The first cell in every column contains a different name (all names are in the same row).
In order to avoid a lot of horizontal scrolling, I would like to be able to type a name in a messagebox, and then directly jump to the cell containing that name. An even better solution I guess would be to create a listbox with all the names, and then by choosing one of the names in the listbox, the cursor moves to the cell/column containing that name. I should add that all the cells containing names are locked.
Can anyone help me:dunno
In order to avoid a lot of horizontal scrolling, I would like to be able to type a name in a messagebox, and then directly jump to the cell containing that name. An even better solution I guess would be to create a listbox with all the names, and then by choosing one of the names in the listbox, the cursor moves to the cell/column containing that name. I should add that all the cells containing names are locked.
Can anyone help me:dunno