LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Filter numbers with textbox using 123132*

Hi Dave,

Thanks for the suggestions. I figured it out as I tired what wrote in
the last message.

I set a cell to contain the number of characters in a cell (z3)
and then used =left(B6,$Z$3) in a dummy column and used autofilter on
that column.

Cheers

Marc

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format numbers in Textbox stickandrock Excel Discussion (Misc queries) 1 October 4th 05 08:41 PM
Searching for text or numbers in textbox Ian[_13_] Excel Programming 2 December 10th 04 08:36 AM
Class module to filter textbox entry Shawn[_9_] Excel Programming 7 August 20th 04 12:53 PM
limit textbox to numbers or spaces? CAA[_14_] Excel Programming 2 January 22nd 04 01:47 PM
Creating Userforms and textbox numbers Bruccce Excel Programming 0 July 31st 03 04:22 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"