Results 1 to 3 of 3

two userform comboboxs depend each other by value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-15-2012
    Location
    beirut
    MS-Off Ver
    Excel 2007
    Posts
    215

    two userform comboboxs depend each other by value

    Dear All ;
    i have a userform contain two comboboxs ( Combobox1 contain Names Exist in Column B and Combobox2 contain Invoice No. in Column C ) . i need to do the followin :
    1-List of Combobox1 must be the names in column B , and List of Combobox2 must be the Invoice No. in column C.
    2- Macro , when i select the name from combobox1 and press the Tab button on keybord i should get the Invoice No. ( or Invoices No. if mor than 1 to the same Name ) in combobox2 , and if i select typed the Invoice No. in combobox2 and press Tab Button i should get the name in combobox1.

    see attched file as example.

    Thanks for your help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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