Macro Button Instead of Pressing Enter
Good Morning,
I have a text search Cell In H7 that works great. I type in my criteria
and press enter, and it highlights what Im looking for.
I would like to have a grey button next to it (CELL I7)that emulates me pressing enter key when i click the mouse on it.
Can this be done?
Thankyou
If you type something in a cell, then click anywhere on the sheet including on a button that does nothing, that would enter the text in the cell.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I agree with Alpha. You would need to press enter to have the data put into the cell, I dont see how how having a button to click would speed anything up?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It wouldn't... as a matter of fact, it would slow things up. The user is typing a value in the cell so his hands are on the keyboard. Instead of reaching over with his/her pinky and pressing the Enter Key, the OP is asking the user to take his/her hand off of the keyboard, grab the mouse, slide the cursor until it is over the button and then press the left button on the mouse in order to click the button on the screen. And then if the user is going to input more data, he/she has to let go of the mouse and put his/her hand back on the keyboard where it originally was.Originally Posted by FDibbins
Rick, those where my thoughts too, I just didnt feel like doing all that typing LOL
(also, had the thought of a user being a left-handed typist and right-handed mousist)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks