I have this line of code which used to "pause" a running routine, display the find dialog, and continue on with the routine when I closed it:
If Application.Dialogs(xlDialogFormulaFind).Show Then
On Windows Vista, Excel 2007 this ran as expected. However, since I've upgraded to Windows 7 and re-installed Excel 2007, the dialog that is popped up has changed. It no longer has the "Within" option which I need, if I guessed I would say it has reverted back to the older style find dialog. When I end the routine and try to pop up the find dialog via ctrl+f or the button on the ribbon, nothing happens. I have to restart excel to see it again.
Ctrl+f normally pops up the correct dialog, so I have no idea why my line of code doesn't. If I try to use SendKeys "^f" it doesn't pause the routine (which is behaviour that might seem unorthodox but is easiest for me, as a beginner).
Thanks in advance for any advice you could offer.
-jt
Hello jaytea,
I am moving your question to our Windows 7 Help forum. Someone there should be able to answer your question.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Jaytea,
Your problem seems weird as migrating your excel file from Vista to Win 7 should have no problem.
I would bet that your file is damaged whether during edit, got some power fluctuation, or your harddisk sector which contain the file is replaced by CHKDSK during improper shutdown.
You can try open that file in another computer. I think the result would be the same. It's damaged in the file. Not because of Windows
Blastranger, you may want to read the post date on several of your responses recently, as they are responses to posts that are several months old and the original poster has not come back to respond.
Some of them aren't even real posts, as these non-Office related forums were actually seeded with questions when they were created.
Good effort though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks