Replace the CTRL + F command with a button
Solved
Faust.78
-
Faust.78 -
Faust.78 -
Hello,
I am currently working with Excel 2007, and I’ve built a kind of CMMS for users who know nothing about computers. Indeed I’ve already created my table, etc., so they can find elements easily with a simple CTRL + F, but the problem is for those who don’t bother to remember CTRL + F.
I would like to know if it’s possible to create a button in my table which, when they click it, opens the search window that normally opens with CTRL + F.
OR, second possibility if the first is too complicated:
Make it so that IF the user types "Z" in the "X" cell, it searches all the cells in the table for cells containing this "Z" inside. (In short, the Find function.)
Use case for solution 1: The user wonders if there are bearings in stock; they press the "Search for part" cell which opens the search window (CTRL + F) and types "Bearing," which takes them directly to the relevant cell containing the word "Bearing."
Use case for solution 2: The user types directly in the appropriate cell (Z1) "Bearing," and that takes them directly to the relevant cell containing the word "Bearing"; note that if they clear the contents of the cell (Z1), the search is reset.
Thanks in advance for your response/time.
Faust.
Configuration: Windows 7 / Firefox 25.0
I am currently working with Excel 2007, and I’ve built a kind of CMMS for users who know nothing about computers. Indeed I’ve already created my table, etc., so they can find elements easily with a simple CTRL + F, but the problem is for those who don’t bother to remember CTRL + F.
I would like to know if it’s possible to create a button in my table which, when they click it, opens the search window that normally opens with CTRL + F.
OR, second possibility if the first is too complicated:
Make it so that IF the user types "Z" in the "X" cell, it searches all the cells in the table for cells containing this "Z" inside. (In short, the Find function.)
Use case for solution 1: The user wonders if there are bearings in stock; they press the "Search for part" cell which opens the search window (CTRL + F) and types "Bearing," which takes them directly to the relevant cell containing the word "Bearing."
Use case for solution 2: The user types directly in the appropriate cell (Z1) "Bearing," and that takes them directly to the relevant cell containing the word "Bearing"; note that if they clear the contents of the cell (Z1), the search is reset.
Thanks in advance for your response/time.
Faust.
Configuration: Windows 7 / Firefox 25.0
5 answers
Do you not think that it infantilizes people, that you preset assumes they won't even be able to recognize an icon in the shape of binoculars?
You don't help them improve their use of the computer!
--
It's good, retirement! Especially in the Antilles ... :-)
☻ Raymond ♂
You don't help them improve their use of the computer!
--
It's good, retirement! Especially in the Antilles ... :-)
☻ Raymond ♂
Hello, Faust.
Why reinvent the wheel?
This button exists : It’s an icon that represents a pair of binoculars, in Edition/Search and select, far right.
You can even add it to the Quick Access Toolbar.
http://www.excel-online.net/excel2007/interface07.htm
Best regards.
--
That’s nice, retirement! Especially in the Caribbean ... :-)
☻ Raymond ♂
Why reinvent the wheel?
This button exists : It’s an icon that represents a pair of binoculars, in Edition/Search and select, far right.
You can even add it to the Quick Access Toolbar.
http://www.excel-online.net/excel2007/interface07.htm
Best regards.
--
That’s nice, retirement! Especially in the Caribbean ... :-)
☻ Raymond ♂
Hello
in VBA
Sub test()
Application.CommandBars("Edit").Controls.Item("Rechercher...").Execute
End Sub
A+
Maurice
in VBA
Sub test()
Application.CommandBars("Edit").Controls.Item("Rechercher...").Execute
End Sub
A+
Maurice
Hello and thank you for your responses.
I’m not trying to reinvent the wheel, it’s just that it’s "too complicated for users who don’t know the software to search for the search button"
So, Foo thanks for your macro I assigned it to a shape that with written "PRESS HERE TO PERFORM A SEARCH"
Thanks anyway,
Best regards!
I’m not trying to reinvent the wheel, it’s just that it’s "too complicated for users who don’t know the software to search for the search button"
So, Foo thanks for your macro I assigned it to a shape that with written "PRESS HERE TO PERFORM A SEARCH"
Thanks anyway,
Best regards!