+ Reply to Thread
Results 1 to 9 of 9

Populate selected cells from combo box selection

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    Populate selected cells from combo box selection

    Not being vba literate I looking for help with the following, please.

    QUESTION 1:
    Each cell A1:H1 needs to be populated with unique values selected from a single list called. NBS_Codes

    So when cell A1 selected I can then select from a combo box an entry, this is then populated to cell A1.

    I then select Cell B1 and do the same process with a different entry from the same combo box.

    QUESTION 2:

    Once I've populated them I would like to have a check box to lock the selections.

    Help appreciated.
    Last edited by Bravo33; 07-08-2013 at 03:05 AM. Reason: Clarity of request

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Populate selected cells from combo box selection

    Hi,

    check if this is what you need: LockCells.xlsm

    Code:
    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Populate selected cells from combo box selection

    Thanks techneXus!

    I should have stated that it is a 2 part question.

    Question 1:

    Each cell A1:H1 needs to be populated with unique values selected from a single list called. NBS_Codes

    So when cell A1 selected I can then select from a combo box an entry, this is then populated to cell A1.

    I then select Cell B1 and do the same process with a different entry from the same combo box.

    Question 2:
    Thanks for the Lcok cells code. Great!!

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Use a listbox.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Populate selected cells from combo box selection

    The cell is narrow and the text is vertical and it was suggested I use a combobox in order to view the full list.
    I thought the method proposed in Question 1 would be the best way, but, I bow to greater knowledge and assistance.

  6. #6
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Populate selected cells from combo box selection

    Hi,

    check this: UniqueFromList and LockCells.xlsm

    Values from list (data validation), duplicates not possible, lock cells. The data validation is just a suggestion as its easier to work with this, if you really want an activeX control let me know.

  7. #7
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Populate selected cells from combo box selection

    tehneXus,
    In principle looks good.
    The number of columns to be populated is a variable. It could be 3, it could be 25.
    The columns are narrow with the text vertical, that's why I thought an activeX control would be better as the char length for each entry can be 50+and visible.

  8. #8
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Populate selected cells from combo box selection

    Could you please upload a sample which shows the sheet before you start setting the columns and after, please also include the narrow columns and vertical text.

  9. #9
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    Re: Populate selected cells from combo box selection

    Guys, thanks for your help on this one!

    I've done a work round.............long winded, by linking individual combo boxes to each cell that I want to populate.

    Not ideal, but it works!

+ Reply to Thread

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