+ Reply to Thread
Results 1 to 5 of 5

Disable button if more textboxs are empty or input text

  1. #1
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Disable button if more textboxs are empty or input text

    Hello, I want to disable a OK command button if 3no textboxs are empty or input any text(non-number),
    with ISTextBox.value<=OOSTextBox.value. I write the code as following but not work at same time by all textboxs,
    what wrong and how to do it? thanks and help.....
    P.S. I had take false on enable item of OK command button

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Disable button if more textboxs are empty or input text

    Hello alee001,

    Are you trying to make it so that the ok command button is disabled is all three text boxes are empty as once? What is one of them is empty and another has a value do you want it to be disabled still or enabled?

    Thanks,

    RVASQUEZ

  3. #3
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: Disable button if more textboxs are empty or input text

    Hi rvasquez, I designed open dialogue box then 3 textboxs prior are empty with disable OK button, OK button will enable after fill in all(3 not 1 or 2) textboxs with right condition at same time. how to do it? .....OK button always enable by fill any ONE textbox.

  4. #4
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Disable button if more textboxs are empty or input text

    Hi alee001
    Perhaps this
    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Forum Contributor
    Join Date
    03-31-2012
    Location
    Hong Kong
    MS-Off Ver
    Excel 2010
    Posts
    140

    Re: Disable button if more textboxs are empty or input text

    I solved the problem as following CODE by other, thks a lot

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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