nience.
>
> > Paul
>
> > - Original Message ----
> > > From: Herman Esmeijer
> > > To: excel-macros@googlegroups.com
> > > Sent: Wed, November 24, 2010 8:51:40 AM
> > > Subject: RE: $$Excel-Macros$$ Re: Long List problem
>
> >
> all.
>
> Sorry for the inconvenience.
>
> Paul
>
>
>
>
>
> - Original Message
> > From: Herman Esmeijer
> > To: excel-macros@googlegroups.com
> > Sent: Wed, November 24, 2010 8:51:40 AM
> > Subject: RE: $$Excel-Macros$$ Re: Long
- Original Message
> From: Herman Esmeijer
> To: excel-macros@googlegroups.com
> Sent: Wed, November 24, 2010 8:51:40 AM
> Subject: RE: $$Excel-Macros$$ Re: Long List problem
>
> Hi Paul,
>
>
> Please stop mailing me.
>
>
>
> Gr.
> Herman
>
&
Then
SortFlag = True
tmpVal = ValArray(R - 1)
ValArray(R - 1) = ValArray(R)
ValArray(R) = tmpVal
' Exit For
End If
Next R
Wend
On Error GoTo 0
Application.StatusBar = False
Do you already have the userform?
or should I start from the beginning?
Paul
- Original Message
> From: Manish Pansari
> To: MS EXCEL AND VBA MACROS
> Sent: Wed, November 24, 2010 5:52:04 AM
> Subject: $$Excel-Macros$$ Re: Long List problem
>
> Hi,
>
Hi,
Any help please
Thanks
On Nov 24, 11:17 am, Manish Pansari wrote:
> Hi All members,
>
> I have data in more than 2000 rows. I created drop down list through
> data validation option in excel. But its very hard and difficult to
> search the required name through long list.
> I want to crea
