+ Reply to Thread
Results 1 to 1 of 1

Pasting cell range to make selections from existing combobox listings

  1. #1
    Registered User
    Join Date
    05-11-2007
    Posts
    6

    Pasting cell range to make selections from existing combobox listings

    Leith Ross was very helpful getting me to this point, but I have some remaining questions, so I thought I'd try reposting.

    For the attached spreadsheet ModelRequirementBreakdown2a.xls, I want to be able to make selections from within combo boxes in the Product column, not only by using the combo box dropdown and select mechanism, but also, if possible, by pasting a cell range whose data matches one of the existing selections available in the combobox definition.

    In other words, if I have a single column cell range from somewhere with the following data in 2 rows:
    VNXES
    HDX

    I want to be able to paste that range starting at B8, such that it makes the combobox selections in B8 and B9, and thereby populates rows 8 & 9 with the appropriate data (in exactly the same way as making these selections manually with the drop-down would).

    Is this do-able?



    I saw an example of another approach to data selection which I liked somewhat, but I don't think it will work. I thought I was good at figuring out things, but I can't crack this simple one.

    In the attached spreadsheet NamesReference.xls, cell A1 of Initial Quality worksheet has a drop down that apparently references the Namelist? "FieldeList" which is on the List worksheet, cells A1-A14.

    By examining A1 of Initial Quality, how can you determine that this reference exists?

    How do you establish such references to Namelists, with the drop-down arrows?

    I like this method of using drop-down lists better than ActiveX combo boxes, because once you've chosen what you want, the appearance is cleaner. Big problem however, is if you try to paste directly into the A1 cell, it doesn't select the item out of the namelist, it overwrites the cell, erasing the namelist functionality. Am I missing something?

    Thanks,

    David
    Attached Files Attached Files

+ 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