+ Reply to Thread
Results 1 to 13 of 13

Filter Column by TExtbox written data

  1. 10-07-2015, 11:48 AM #1
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Filter Column by TExtbox written data

    Hello all,

    QUESTION1:

    I need to write in a textbox (which is created and with the name: "txt_diadomapa") and according to date Written filter Column "PlaneamentoBolha" , which is Field48

    Please Login or Register  to view this content.
    I have this although it doesn't work, it seems to be impossible to filter by 1 specific date and with variables or textbox.

    Hope someone can help me out with this

    QUESTION2:
    And as well,
    How can i filter by 2 Textbox and get a range without.
    Let's say:

    Filter Column 48 from 06/10 till 10/10
    6 Octobre till 10

    Can i work in txtbox with DAY / MONTH ? instad of month/day
    Last edited by brainzlp; 10-07-2015 at 11:58 AM.
    Reply With QuoteRegister To Reply
  2. 10-07-2015, 12:13 PM #2
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Filter Column by TExtbox written data

    The value in the textbox is text, if you are trying to filter using it as a date then you need to convert it to a date value.

    You can do that using one of the conversion functions like CDate, DateValue, or even CDbl.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  3. 10-07-2015, 12:29 PM #3
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Quote Originally Posted by Norie View Post
    The value in the textbox is text, if you are trying to filter using it as a date then you need to convert it to a date value.

    You can do that using one of the conversion functions like CDate, DateValue, or even CDbl.
    Please Login or Register  to view this content.
    I have this at moment, can you help me out.

    I need to search by that textbox date by: DAY/MONTH
    And if no row is find, get a MsgBox sayinh ("NO row found, check again your date")
    Reply With QuoteRegister To Reply
  4. 10-07-2015, 12:31 PM #4
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Duplicated post. Sorry
    Last edited by brainzlp; 10-07-2015 at 03:35 PM.
    Reply With QuoteRegister To Reply
  5. 10-07-2015, 12:32 PM #5
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Duplicated post. Sorry
    Last edited by brainzlp; 10-07-2015 at 03:36 PM.
    Reply With QuoteRegister To Reply
  6. 10-07-2015, 12:35 PM #6
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Duplicated post. Sorry
    Last edited by brainzlp; 10-07-2015 at 03:35 PM.
    Reply With QuoteRegister To Reply
  7. 10-08-2015, 02:51 AM #7
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Can someone help me with this? I really need to Filter this way so my team can work. Hope someone can help me out
    Reply With QuoteRegister To Reply
  8. 10-08-2015, 02:59 AM #8
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Filter Column by TExtbox written data

    You need to post your workbook.

    ViewPic
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
    Reply With QuoteRegister To Reply
  9. 10-08-2015, 03:28 AM #9
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Hello,

    I will do a quick workbook. Cuz mine is more thamk 2mb and is full of password.

    I just need that what i write in a textbox is used as a date and filter a column with that.

    Then, If no information is showm get a msgbox
    Reply With QuoteRegister To Reply
  10. 10-08-2015, 04:20 AM #10
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    Quote Originally Posted by skywriter View Post
    You need to post your workbook.

    ViewPic
    Check the workbook in attach. What i need is in the Userform, at the last CommandButton you enter to another userform, and in there you choose in calender the date you want. Then click in "Usar Data" and after that click in cmd called "BOLHA".

    But in there i have to filter column 48, with my date and if no match is found get a msgbox.

    Please hope someone can help me it's really urgent
    Attached Files Attached Files
    Last edited by brainzlp; 10-08-2015 at 06:36 AM.
    Reply With QuoteRegister To Reply
  11. 10-08-2015, 05:33 AM #11
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516

    Re: Filter Column by TExtbox written data

    It can be used with a Date calender picker to select the date instead of checkbox. Just let me know whats the best and good way to do this
    Reply With QuoteRegister To Reply
  12. 10-08-2015, 01:05 PM #12
    skywriter
    skywriter is offline
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Filter Column by TExtbox written data

    You have marked this thread as solved?
    Reply With QuoteRegister To Reply
  13. 10-08-2015, 03:35 PM #13
    brainzlp
    brainzlp is offline
    Forum Contributor
    Join Date
    07-20-2015
    Location
    Covilhã
    MS-Off Ver
    2010
    Posts
    516
    Quote Originally Posted by skywriter View Post
    You have marked this thread as solved?
    Yes i did. Solved with datepicker calensar userform and 2 textboxs.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Filter data using textbox
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-28-2015, 04:28 PM
  2. Problem with display textbox when filter the data in listbox
    By lacromo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-27-2015, 08:28 AM
  3. Using filter with list stored in a column and process data for each filter selection
    By shailew in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2014, 10:55 AM
  4. Error 438 when running sort, filter, and copy across sheets (2003, written in 2010)
    By Jegres in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2011, 08:49 PM
  5. Take what is written in a textbox and put it in a cell on specific worksheet
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2011, 02:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1