PC Review


Reply
Thread Tools Rate Thread

Command Buttons and Auto-Filter

 
 
=?Utf-8?B?S2F0aWU=?=
Guest
Posts: n/a
 
      31st May 2007
Hey All-

I was trying to alter a command button to auto-filter based on input from
the user in cell C1. (Which is actually a merged cell of four other cells)

The data range is A4:BJ3500 and this is what I'm using but it returns no
results even if I put in a number that I'm certain is in column "A" - field
1.

Any ideas greatly appreciated!

Private Sub CommandButton1_Click()
Range("A4:BJ3500").Select
Selection.AutoFilter Field:=1, Criteria1:="=*" & Range("C1").Value _
& "*"
End Sub


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Adding command buttons to filter and reset Allen Browne Microsoft Access Forms 1 23rd Dec 2006 01:37 AM
Filter a text box with command buttons Roger Withnell Microsoft Access 1 21st Aug 2005 01:25 PM
Filter command buttons =?Utf-8?B?Sm9Q?= Microsoft Access Forms 1 2nd Aug 2004 04:04 PM
Filter by form using command buttons SAC Microsoft Access 1 29th Jun 2004 08:35 PM
Filter by Form/Apply Filter Command Buttons Chris Microsoft Access Forms 1 9th Jan 2004 03:22 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:50 PM.