the drop down is on a sheet. the data validation is looking at another tab
Jim Wagner
On Wednesday, November 6, 2013 1:12 PM, Paul Schreiner <schreiner_paul@att.net> wrote:
By "drop down box",
do you mean on a sheet or userform?
In a userform, I've used a change event to execute filters (or lookups, or...)
upon each keystroke.
In one panel, As I type, it looks up record values in an Oracle database.
If it finds a match, it updates radio buttons on the form and changes the Caption on the button.
You could do the same thing with filters.
however, I don't know if there is a "change" event for drop-downs on a worksheet.
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
From: "luvmymelody@yahoo.com" <luvmymelody@yahoo.com>
To: ExcelVBA@yahoogroups.com
Sent: Wednesday, November 6, 2013 2:15 PM
Subject: [ExcelVBA] Drop Down question
Hello all,Is there a way of having a user type in a drop down box and the values of the drop down filter as you type?Thank YouJim Wagner
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (5) |
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
.
__,_._,___
Tidak ada komentar:
Posting Komentar