+ Reply to Thread
Results 1 to 9 of 9

ComboBox visible if excel cell has value

  1. 05-23-2018, 12:02 PM #1
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    ComboBox visible if excel cell has value

    I have a userform with a ComboBox that I only want visible if cell "D2" has a value of "TRUE". Below is my code that is NOT working currently.

    I'd appreciate any assistance please.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 05-23-2018, 12:14 PM #2
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    Re: ComboBox visible if excel cell has value

    I'm sorry, it's a CheckBox, NOT a ComboBox
    Reply With QuoteRegister To Reply
  3. 05-23-2018, 12:20 PM #3
    ag273n
    ag273n is offline
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: ComboBox visible if excel cell has value

    try this

    Please Login or Register  to view this content.
    the condition here is that if Range D2 contains something.
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.
    Reply With QuoteRegister To Reply
  4. 05-23-2018, 12:20 PM #4
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: ComboBox visible if excel cell has value 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 05-23-2018, 12:26 PM #5
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    Re: ComboBox visible if excel cell has value

    Did not work unfortunately.
    Reply With QuoteRegister To Reply
  6. 05-23-2018, 12:30 PM #6
    nigelog
    nigelog is offline
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: ComboBox visible if excel cell has value

    Is your userform called FrmIT?
    Does it have a checkbox number 36?
    And does Sheet5.Range("d2") have a value of TRUE?
    Reply With QuoteRegister To Reply
  7. 05-23-2018, 12:30 PM #7
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    Re: ComboBox visible if excel cell has value

    nigelog, this did not work either.
    Reply With QuoteRegister To Reply
  8. 05-23-2018, 12:31 PM #8
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    Re: ComboBox visible if excel cell has value

    nigelog, yes to all 3 and I have data being pulled into this form from this spreadsheet for other items, I just can't get this checkbox to become visible if that dell has text in it.

    I have 3 labels getting their captions from 3 different cells as well as the caption for the frame and that all works perfect.
    Reply With QuoteRegister To Reply
  9. 05-23-2018, 12:37 PM #9
    Tarena
    Tarena is offline
    Registered User
    Join Date
    06-02-2016
    Location
    Windsor, Wisconsin
    MS-Off Ver
    2016
    Posts
    35

    Re: ComboBox visible if excel cell has value

    ag273n and nigelog, what ag273n suggested did work once I change "CheckBox36.Value" to "CheckBox36.Visible"

    Thank you both so much!!! I will give "Reputation"!!!!
    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] ComboBox Doesn't Show Values When Made Visible
    By VinchinzoB in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 04-13-2018, 02:20 PM
  2. [SOLVED] Populate ComboBox with unique and Visible from column B
    By luismalave in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-08-2015, 07:36 PM
  3. Excel Userform to utlize only visible cells in a combobox
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2014, 10:48 PM
  4. Combobox remains visible as scroll down Excel sheet
    By crow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-29-2012, 07:32 AM
  5. How can i make visible or invisible groupobjects using a combobox
    By drodriguez93 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 02:22 AM
  6. Visible frames based on combobox
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2010, 07:57 AM
  7. make textbox visible on condition of combobox selection
    By zebra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2009, 10:48 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