+ Reply to Thread
Results 1 to 3 of 3

Blocking/Allowing Entries to a Textbox Based on Contents of Another Control

  1. #1
    Forum Contributor
    Join Date
    04-23-2014
    Location
    Liverpool...ish
    MS-Off Ver
    Excel 2013
    Posts
    126

    Blocking/Allowing Entries to a Textbox Based on Contents of Another Control

    How would you prevent a textbox from accepting an entry if a combobox equalled a particular text?
    Example if combobox1 = “Good” then Textbox1 would accept an entry but Textbox2 would not but if the Combobox1 = “Bad” then Textbox1 would be blocked and Textbox2 would accept an entry.

    Regards

    Scott

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Blocking/Allowing Entries to a Textbox Based on Contents of Another Control

    Something like this...

    Place this code on Form Module.

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    04-23-2014
    Location
    Liverpool...ish
    MS-Off Ver
    Excel 2013
    Posts
    126

    Re: Blocking/Allowing Entries to a Textbox Based on Contents of Another Control

    Some times my the answers I get are so elementary I have to ask myself.... "Just how dumb can I be?"

    Thank You for the lesson

    Scott
    Last edited by TheScott; 05-17-2015 at 02:49 AM.

+ 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. Blocking Ads in a Microsoft Webbrowser Control (ActiveX)
    By Jakecaustin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2015, 12:26 PM
  2. Userform Minimize Button Code Blocking Focus for First TextBox in Frame
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 12:57 PM
  3. not allowing duplicate entries from a list
    By Kevska in forum Excel General
    Replies: 9
    Last Post: 02-14-2011, 08:11 PM
  4. blocking entries with data validation
    By jcavigli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2008, 05:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1