Wednesday, April 25, 2012 9:11 AMSince my team started using Using the Find dialog (CTRL + F) or Find and Replace (CTRL + H) tool in Excel 2010 Professional everyone has experienced problems with the dialog box immediately losing focus and text cannot be entered into the "Find what:" or replace boxes at all. Even clicking on the dialog does not remedy the problem. Infact the only way we have been able to use this function is to extremely quickly copy/paste text into each box when the dialog pops up. As you can imagine this has rendered an extremely useful function completely useless and dealing with data has become quite frustrating.
Thursday, April 26, 2012 7:36 AMModerator
It seems to be caused by the VBA code, please determine if some codes were written with Worksheet_SelectionChange event in the workbook. I would suggest disable and debug it.
TechNet Community Support
Thursday, May 03, 2012 10:03 AMUnfortunately this is not the answer. I do have some macros however none which touch the Worksheet_SelectionChange event. Also the behavior is exhibited on fresh workbooks with no macros at all. The same workbooks/macros etc to not have this problem when using Excel 2007.
Friday, May 04, 2012 1:40 AMModerator