+ Reply to Thread
Results 1 to 3 of 3

How do I link commandbuttons to combobox selection?

  1. #1
    Registered User
    Join Date
    12-20-2018
    Location
    North Carolina
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    3

    How do I link commandbuttons to combobox selection?

    I'm hoping someone can help me figure out how to code some functions that are a little beyond my abilities. What I'm trying to do is b able to click command buttons and have Excel determine where to place letters on the workbook based on what is selected in the combobox.

    So for example, if I choose 710300A, that SKU on the workbook is in cell C3. Start (S). Finished (F). Published (P).

    So if I click 360 Start while the Product SKU has 710300A selected, an "S would appear in cell E3. If I clicked Reviews Finalized, an "F" would appear in cell I3.

    If I changed the ProductSKU selection to 708287A, located in cell C14 on the worksheet and clicked 360 Start, Excel would know to place an "S" in cell E14.

    I've attached the workbook I have so far, as well as an image reiterating this scenario.

    Thank you for any help you can provide!!
    Last edited by ERG1982; 12-31-2018 at 02:32 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: How do I link commandbuttons to combobox selection?

    Are you sure the columns are correct? Why would a value be placed in column I when there is no header for that table in your attachment?

    BSB

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,604

    Re: How do I link commandbuttons to combobox selection?

    Change the combobox properties:
    BoundColumn=0
    ColumnCount=1

    Add the below to the very top of Module1

    Please Login or Register  to view this content.
    Modify the form's button codes as was done with Start360_Click

    calculate the sku row in the worksheet:
    Please Login or Register  to view this content.

    Please Login or Register  to view this content.
    When choosing the column numbers for the cell, type Headers. then choose the header from the dropdown.
    Last edited by protonLeah; 12-28-2018 at 07:46 PM.
    Ben Van Johnson

+ 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. ComboBox values source being changed based on another combobox selection in a UserForm
    By stephenanderson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2016, 11:12 PM
  2. [SOLVED] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  3. [SOLVED] Trying to Link 2 textboxs to a combobox selection
    By forrestgump1980 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2015, 12:30 PM
  4. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  5. [SOLVED] fill combobox selection based on a selection from the first combobox
    By Monza in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2013, 07:34 PM
  6. [SOLVED] link commandbuttons on userform and sheet
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-18-2013, 01:54 PM
  7. [SOLVED] how to link commandbuttons on userform
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-30-2013, 04:23 PM

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