+ Reply to Thread
Results 1 to 8 of 8

Can anyone fix this? Cannot filter numbers vba activex textbox

  1. #1
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Can anyone fix this? Cannot filter numbers vba activex textbox

    In the attached workbook, I cannot search in “textbox1” for a number. As soon as i type all the results disappear, and when i press the clear button it does nothing.

    The filter needs to be “greater than or equal to” the number typed into the box.

    I have this exact same code on another workbook but searching text and it all works just fine. Is it not running because they are numbers?

    Mickey
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    I think it should go like this-
    Please Login or Register  to view this content.
    EDIT- FORGOT TO PUT EQUAL TO SIGN
    Last edited by sourabhg98; 02-09-2016 at 12:42 PM.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    try this
    Please Login or Register  to view this content.

  4. #4
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    and for clear it should be
    Please Login or Register  to view this content.
    Check attached
    Attached Files Attached Files
    Last edited by sourabhg98; 02-09-2016 at 12:43 PM.

  5. #5
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    Thanks Guys, added reputation

  6. #6
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    Just out of interest, if I wanted to add a button to clear multiple command buttons in the same table, is this easy to do?

    Like in the example sheet if you duplicate column a a couple times and add a "clear all" command button at the end?

  7. #7
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    Please Login or Register  to view this content.
    something like this?

  8. #8
    Registered User
    Join Date
    01-28-2016
    Location
    Leamington Spa
    MS-Off Ver
    2007
    Posts
    14

    Re: Can anyone fix this? Cannot filter numbers vba activex textbox

    Excellent

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multi-Worksheet ActiveX Textbox to ActiveX Textbox Concatenate
    By HVE_Skynet in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2014, 02:11 PM
  2. ActiveX Textbox to ActiveX Textbox Concatentate
    By HVE_Skynet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2014, 05:22 PM
  3. [SOLVED] Converting text to numbers after using an ActiveX Textbox
    By Jason Eric in forum Excel General
    Replies: 2
    Last Post: 03-16-2013, 12:37 PM
  4. ActiveX - TextBox
    By hmgrts in forum Excel General
    Replies: 3
    Last Post: 03-10-2013, 08:44 PM
  5. TextBox (ActiveX).Value
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 05:35 AM
  6. [SOLVED] ActiveX TextBox Height
    By zplugger in forum Excel General
    Replies: 2
    Last Post: 01-17-2013, 10:00 AM
  7. Combobox - Filter auto-filter worksheets (ActiveX)
    By Darms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2011, 11:33 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1