+ Reply to Thread
Results 1 to 2 of 2

commandbutton check values in combobox of another userform

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    34

    commandbutton check values in combobox of another userform

    Hi
    I have a scenario that I don't know how to explain it. But I do my best!
    The problim is:
    I have five userforms. three (UserForm1, UserForm2,UserForm3)of them have comboBox to select data and two(UserForm4,UserForm5) have text to input data.
    In userform3 when I select value in combobox2(For Exp. "Name"),combobox3 show 2 or 1 value ( "Company" or"team" or both of them),when I click on commandbutton I going to userform4 to fill out "company"`s information or in somecase going to userform5 to fill out "team"`s information. But some times there are 2 values in combobox3 inestead of 1 and I want to check that in userform4 or 5 ( after click on save commandbutton), if there is another value in combobox3, the MsgBox pop up and notice that to fill out "Company" or "team" information.

    I`m trying to use this code but it doesn't work

    Please Login or Register  to view this content.


    I hope its clear to undestand!

  2. #2
    Registered User
    Join Date
    05-24-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: commandbutton check values in combobox of another userform

    hum? nothing?

+ 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] Userform combobox to populate RowSource for new values in combobox
    By Stratfordoaks in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 12-17-2013, 01:18 PM
  2. Userform: Unique Values to ComboBox
    By dinosaur1993 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-21-2013, 03:09 AM
  3. [SOLVED] Changed userform combobox to listbox, unable to get userform to retrieve datasheet values
    By dragonabsurdum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2013, 01:38 PM
  4. [SOLVED] 5 ComboBox's .... 1 CommandButton ?
    By dannac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-05-2012, 10:48 AM
  5. Replies: 4
    Last Post: 11-28-2012, 06:09 PM
  6. [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
  7. Commandbutton in userform to execute code based on a previous commandbutton choice?
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 03:28 PM
  8. Check Blank Textbox & Combobox on UserForm
    By smart_as in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2011, 11:09 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