Re: Auto_expand on excel
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 30 May 2007 10:34:49 +0100
Hi Frank
Glad you got it running.
Typing VA on its own, would be looking for items beginning with VA (not
case sensitive). Typing VA** would do exactly the same. *VA would look
for items where any word contained the letters VA.
The code keeps the cursor in the same cell to make it easy to add more
characters to your search.
So you could enter V for all entries staring with V, then VA which would
limit it to those starting VA, then VAL etc. to narrow down the
selection
The code is merely setting the parameters for Autofilter, without having
to use the steps of selecting the dropdown>Custom>begins with etc.
On Excel versions up to 2002, the dropdown on Autofilter was quite
short, but it has expanded with later versions making the choosing of
options slightly more laborious, that's why I wrote the code.
The capabilities therefore, are still those of Autofilter itself. Yes,
it will deal with the full list of 65536 rows of XL versions to 2003,
but there is an inbuilt limitation, that Autofilter will not display
more than 1000 rows for any filter applied.
Debra Dalgleish has some methods for getting around this limitation on
her site at
http://www.contextures.com/xlautofilter02.html#Limits
--
Regards
Roger Govier
"Frank Situmorang" <frank.situmorang@xxxxxxxxxxxx> wrote in message
news:50C2D440-26EA-4E00-941C-2D20332A07E4@xxxxxxxxxxxxxxxx
Thank you very much Roger, It works infact. It is because I did not
put the
wild character such as "VA**, I just typed VA, so it showed blank. It
works
perfectly now. My question is how many rows that it can handle. Is it
possible for 65,000 rows?
Thanks a lot
Frank
"Frank Situmorang" wrote:
Hello:
I have data auto filterin excel, when I wanted to find a record it
can only
jump into the first character. Is it possible to have an auto expland
like in
access data base??. For example I want to search in filter for Valve
when I
typed VA it will auto expand to Valve, varina, etc....
Thanks for any idea
Frank
.
- Follow-Ups:
- Re: Auto_expand on excel
- From: Frank Situmorang
- Re: Auto_expand on excel
- Prev by Date: Re: Formatting a Range
- Next by Date: Re: Data Entry Form
- Previous by thread: Re: Auto_expand on excel
- Next by thread: Re: Auto_expand on excel
- Index(es):
Relevant Pages
|
