PDA

View Full Version : Display results of CTRL+F in the middles of the screen



r8chris
01-06-2010, 06:49 AM
Hi,

When ever I use the ctrl+F to find something in a cell the results are displayed anywhere they are found on the screen. I am wandering if it is possilbe to have some VBA code to always display the result in the same position, preferably centered in the middle of the screen. Can this be done.
I am using XP, with office 2003.

Cheers

rbrhodes
01-06-2010, 08:42 PM
Hi r8,

Do you want a message box or userform with the location of the found item? Or simply to scroll to where the found item is?

r8chris
01-07-2010, 02:49 AM
Hi r8,

Do you want a message box or userform with the location of the found item? Or simply to scroll to where the found item is?
Thanks for your help and sorry I did not make it clear. I would like to be able to simply scroll down to the cell where the item is and have it displayed in the centre of the screen if this is possible.

markmrw
01-07-2010, 05:34 AM
http://www.vbaexpress.com/kb/getarticle.php?kb_id=195

this kb entry by Md might be helpful to you

r8chris
01-07-2010, 05:58 AM
Thanks Markmrw, I will have a look and see if this could work.