+ Reply to Thread
Results 1 to 5 of 5

Check if ComboBox contains text not working quite how I want

  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Methuen, Massachusetts
    MS-Off Ver
    2016
    Posts
    15

    Check if ComboBox contains text not working quite how I want

    Hello all,

    I have a code I want to execute:

    I want the code to check if a Combobox has a value(s), if it does, add it to a cell in combination with another Combobox. If it doesn't, I want it to do nothing and move on. Here is what I have:

    Please Login or Register  to view this content.
    Even if the Combobox1 is empty, the code still adds the Hyphen to the next empty cell. How can I improve upon this?

    Thank you all,
    Matthew

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: Check if ComboBox contains text not working quite how I want

    How about
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    01-03-2018
    Location
    Fukuoka, Japan
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Check if ComboBox contains text not working quite how I want

    To check if the value is selected or not in ComboBox1...

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-14-2018
    Location
    Methuen, Massachusetts
    MS-Off Ver
    2016
    Posts
    15

    Re: Check if ComboBox contains text not working quite how I want

    SOLVED!

    Thank you Fluff13 & yujin!

    ~Matthew

  5. #5
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,073

    Re: Check if ComboBox contains text not working quite how I want

    Glad we could help & thanks for the feedback

+ 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. [SOLVED] Combobox AfterUpdate Check
    By dougman824 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2017, 11:11 AM
  2. [SOLVED] VBA UserForm.Value Check If User Form Buttons checked Not Working. Check Button on Open.
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-11-2016, 05:55 PM
  3. Combobox Text Align left not working
    By Schwizer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-16-2013, 01:31 PM
  4. [SOLVED] Check for specific text in ComboBox value on userform
    By lday75 in forum Excel General
    Replies: 2
    Last Post: 08-24-2012, 08:00 AM
  5. Filling Combobox Based on another combobox.text value.
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 02-18-2012, 01:20 AM
  6. Check if combobox exists
    By leonidas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2006, 12:26 PM
  7. check box and combobox
    By men in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2005, 09:35 PM

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