J
jestercat
I have a large worksheet with many columns.
I've already got some code running to highlight the row that the cursor is
currently on (making it easier for the user to see the row).
I'm trying to figure out a better way to conduct a search (for any string in
the worksheet) that doesn't use the built in CTRF-F. I find CTRL-F
cumbersome as you have to close the FIND pop-up to swtch to another workbook,
or use the scroll bars, etc. And although it finds what I am looking for, I
lose the row highlight feature until I close the FIND pop-up window, and
click on the worksheet again....
I'm open to suggestions but would prefer a userform that could be anchored
somewhere on the document (always visible).
Thanks in advance!
I've already got some code running to highlight the row that the cursor is
currently on (making it easier for the user to see the row).
I'm trying to figure out a better way to conduct a search (for any string in
the worksheet) that doesn't use the built in CTRF-F. I find CTRL-F
cumbersome as you have to close the FIND pop-up to swtch to another workbook,
or use the scroll bars, etc. And although it finds what I am looking for, I
lose the row highlight feature until I close the FIND pop-up window, and
click on the worksheet again....
I'm open to suggestions but would prefer a userform that could be anchored
somewhere on the document (always visible).
Thanks in advance!