Re: Auto_expand on excel

Thanks Roger for your more explanation on using * character and how we narrow
down the selection. I appreciate if you could explain on how we can modify
the VBA to have the returned selection into sequence on the Unit Price
Column, coz we want to know the lowest price of supplier's quotations.

Again thanks in advance, we in developping country are benefited from you in
advanced country.

Frank

"Roger Govier" wrote:

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



.

Relevant Pages

  • Re: Identify page on which a bookmark is located
    ... previous character or next character and there are none at the beginning and ... "Collapse" produces nothing in VBA Help). ... for my GoTo Bookmark code. ... Collapses a range or selection to the starting or ending position. ...
    (microsoft.public.word.vba.general)
  • Re: How to replace a string of characters with the count of the ch
    ... Dim CharNum As Long ... Dim AlphabetCountString As String ... I prefer to work with Range objects instead of the Selection whenever ... character in the group is selected, whether I use Selection or Range. ...
    (microsoft.public.word.vba.general)
  • Re: Identify page on which a bookmark is located
    ... "Collapse" produces nothing in VBA Help). ... for my GoTo Bookmark code. ... Collapses a range or selection to the starting or ending position. ... character by using the MoveEnd method after the range is collapsed, ...
    (microsoft.public.word.vba.general)
  • GL -- I Remember Micheal Zazlow
    ... I remember Micheal Zazlow first got sick- I noticed right away, ... Michael Zaslow will always be Roger Thorpe to ... a character on the show earlier, and when he was let go from GL, OLTL ... Michael Zaslow was Roger Thorpe. ...
    (rec.arts.tv.soaps.cbs)
  • Re: GL -- I Remember Micheal Zazlow
    ... >I remember Micheal Zazlow first got sick- I noticed right away, ... Michael Zaslow will always be Roger Thorpe to ... > a character on the show earlier, and when he was let go from GL, OLTL ... Michael Zaslow was Roger Thorpe. ...
    (rec.arts.tv.soaps.cbs)