Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: Office Excel
I'm a newbie to programming in Excel.
 
In excel I have a dropdown in which i want filtering of the data in it to be done.
 
Example:
consider the dropdown has the following values :
All Questions
All Answers
All Guests Welcome
All Answers Welcome
All Stand in Queue
When the user types "w" or "W" in the dropdown, the values in the dropdown need to be like the following:
All Guests Welcome
All Answers Welcome
I have already finished for filtering the First word in the list.
But i need the above scenario to be replicated for the other words in the list.
 
please give me a solution to solve the above problem.
 
Thanks in Advance..!
Posted 2-May-13 2:44am
Velrats1.3K
Edited 2-May-13 2:58am
(no name)105.8K
v3
Comments
Kenneth Haugland at 2-May-13 8:03am
   
I assume that this is VBA or?
Velrats at 2-May-13 8:40am
   
not in VBA, I'm doing it in MAcros
Kenneth Haugland at 2-May-13 9:07am
   
Well, VBA is in Macro, while VSTO is in .NET
Velrats at 2-May-13 9:23am
   
I want in Macros... in Excel not in .Net... Please let me know the solution if you know :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 190
2 Richard MacCutchan 135
3 Sergey Alexandrovich Kryukov 130
4 DamithSL 95
0 OriginalGriff 6,045
1 DamithSL 4,601
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,310


Advertise | Privacy | Mobile
Web03 | 2.8.141220.1 | Last Updated 2 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100