Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box

2011-10-21 Thread ajjw123 
THANK YOU VERY MUCH

On Oct 18, 8:11 am, Bé Trần Văn  wrote:
> 2011/10/17 NOORAIN ANSARI 
>
>
>
>
>
>
>
>
>
> > Please share your worksheet with us.
>
> > On Mon, Oct 17, 2011 at 6:44 AM, ajjw123  wrote:
>
> >> can anybody help me with auto complete feature incorporation in drop
> >> down list or in a combo box.thanks
>
> >> --
>
> >> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >>http://twitter.com/exceldailytip
> >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> >> To post to this group, send email to excel-macros@googlegroups.com
>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> Like our page on facebook , Just follow below link
> >>http://www.facebook.com/discussexcel
>
> > --
> > Thanks & regards,
> > Noorain Ansari
> >  *http://excelmacroworld.blogspot.com/*
> > *http://noorain-ansari.blogspot.com/*
>
> > --
>
> > --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> *List and Find*
>
> *Step 01. Create dynamic Name:*
>
> a. Name the sheet contains a list of names DataList.
>
> b. Create dynamic Name: select the area containing the *Data* (eg, B6: B20),
> from the menu click Insert> Name> Define .. Define Name window appears.
>
> In the Name in Book: Name and name is the Data frame Refers to type the
> function
>
> = OFFSET ($ B $ 6 DataList!,,, COUNTA (DataList! $ B: $ B) -1)
>
> Click the Add button done OK.
>
> *Step 02: Create a Form.*
> Create a Search Form Name is set, the caption SEARCHFORM.
> Place the objects on the form:
> - Used to create 04 Label header.
> - Use the Text box 01: there is TxtFind Name, TabIndex is: 1
>
> (You can change the Text box with conboBox, there is cbxFind Name, TabIndex
> is: 1, Rowsource is: Data)
>
> - Use List box 02:
>         + List box1: Name is: LstData, TabIndex is: 0, Rowsource is: Data
>         + List box2: Name is: Lst Results, TabIndex is: 2
>
> *Step 03: write code.*
>
> Code for Form:
>
> Private Sub TxtFind_Change()
>
>     Lst Results.Clear
>
>     Lst Results.List = Filter(WorksheetFunction.Transpose _
>
> (Range("Data")), TxtFind.Text, True, vbTextCompare)
>
>   ‘Change the TxtFind with cbxFind
>
>  ‘Data is Create dynamic Name
>
>     If TxtFind = "" Then Lst Results.Clear
>
> End Sub
>
> Code for Module1:
>
> Sub ShowForm()
>
>     Search.Show
>
> End Sub
>
> Code for Commanbutton The Form:
>
> Private Sub CommandButton1_Click()
>
> Search.Show
>
> End Sub
>
>  List and Find.xls
> 54KViewDownload

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box

2011-10-17 Thread NOORAIN ANSARI 
Please share your worksheet with us.

On Mon, Oct 17, 2011 at 6:44 AM, ajjw123  wrote:

> can anybody help me with auto complete feature incorporation in drop
> down list or in a combo box.thanks
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ auto complete feature in drop down list or combo box

2011-10-17 Thread dguillett1 



You can tie to a worksheet_change event in the sheet module. More info 
and/or share a file


Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: ajjw123

Sent: Sunday, October 16, 2011 8:14 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ auto complete feature in drop down list or combo 
box


can anybody help me with auto complete feature incorporation in drop
down list or in a combo box.thanks

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip

2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel 


--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ auto complete feature in drop down list or combo box

2011-10-16 Thread ajjw123 
can anybody help me with auto complete feature incorporation in drop
down list or in a combo box.thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel