This works
Please Login or Register to view this content.
And this doesn't
Please Login or Register to view this content.
Any ideas would be gratefully received
This works
Please Login or Register to view this content.
And this doesn't
Please Login or Register to view this content.
Any ideas would be gratefully received
Try to avoid Sendkeys. What exactly do you want to do?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi Roy
I was trying to assign some code to a button so that it popped up with the "find" dialog box (i.e. CTRL-F), but in addition to this that it defaulted to searching the workbook and not the worksheet as would be normal...........hence the sendkeys code.
I could use the above macro but when I assigned it to a button of any type it failed?!??!
I then decided to forget about the button and give it a shortcut key of CTRL-F but after doing that it didn't behave as it should. Whenever I did a search using CTRL-F it would give me about 50% of the results I should have got?????
I decided to give up on that idea as I was now in the twilight zone so I'm now looking for a neat solution to searching the whole workbook if you have any ideas????
Ctrl F should display the Find Dialog anyway.
This line should display the Dialog
Please Login or Register to view this content.
Last edited by royUK; 08-08-2007 at 05:15 AM.
Hi Roy
Thanks but as you can see above, that's what I used....
I don't understand your problem, that line of code works.Originally Posted by fry
fry,
Read your line and then read Roy's line very, very carefully.
Dean
Hi Dean
I know what you mean, mine is "value" and roys is "formula", both of which bring the find dialog box up and both of which aren't what I need.
I might in that case say to you, "read my first post very carefully"....
You still haven't said why you need Sendkeys!
Hi Roy
It's in my post above...
"I was trying to assign some code to a button so that it popped up with the "find" dialog box (i.e. CTRL-F), but in addition to this that it defaulted to searching the workbook and not the worksheet as would be normal...........hence the sendkeys code."
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks