Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search input box
Is there a way to construct a 'search' input box that acceps a string (eg
BoatName='OceanDance') and a column paramter eg (Column=C) and then returns the rows relating to that user criteria.... Very much appreciated Jason |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search input box
Try using the Autofilter under the Data=Filter menu. If you need code,
turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy wrote in message ... Is there a way to construct a 'search' input box that acceps a string (eg BoatName='OceanDance') and a column paramter eg (Column=C) and then returns the rows relating to that user criteria.... Very much appreciated Jason |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search input box
Will these macros work across all machines.....?
Isn't there a problem with mouse vs keystroke macros... Many thanks Jason "Tom Ogilvy" wrote in message ... Try using the Autofilter under the Data=Filter menu. If you need code, turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy wrote in message ... Is there a way to construct a 'search' input box that acceps a string (eg BoatName='OceanDance') and a column paramter eg (Column=C) and then returns the rows relating to that user criteria.... Very much appreciated Jason |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search input box
If you record the macro on the earliest version of Excel that will need to
use it, you should have no problems. As recorded, the macro will need to be enhanced to allow dynamic selection of a value - using the inputbox function as an example and substituting the result in the Autofilter command. Or you might find that instructing your users how to use Autofilter may eliminate the need for macros. -- Regards, Tom Ogilvy wrote in message ... Will these macros work across all machines.....? Isn't there a problem with mouse vs keystroke macros... Many thanks Jason "Tom Ogilvy" wrote in message ... Try using the Autofilter under the Data=Filter menu. If you need code, turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy wrote in message ... Is there a way to construct a 'search' input box that acceps a string (eg BoatName='OceanDance') and a column paramter eg (Column=C) and then returns the rows relating to that user criteria.... Very much appreciated Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
input in number form is being multiplied by 1000 when i input. | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
Input one criteria to search in 5 fields | Excel Discussion (Misc queries) | |||
Excel VBA- Get user input, search the for match, output to text file | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |