Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare Column to Inbput Box Variable
User's Group
This is only the second time I have ever worked with Excel so please have patience. I need to enter Filtering Criteria from an Input Box. Then match the contents of that variable to Column L (Will always be Column L) Because of what I eventually have to do I cannot use Autofilter. TestClass = InputBox("Enter ACT, International, S.A.T. or TAKS Classification") ? = What is the Format(Syntax) to compare the contents of TestClass to Column L. There will be eventually more code, I have to convert from another software application (That I have little knowledge of) to Excel. Thanks to all of ya' for assistance Granny |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data in column A with column B to find duplicates | Excel Discussion (Misc queries) | |||
compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
compare dates using a variable | Excel Worksheet Functions | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
compare data from one column with another and compare result to yet another | Excel Programming |