+ Reply to Thread
Results 1 to 12 of 12

Attached combobox to cell

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Attached combobox to cell

    Hi,

    i created combobox (active control) and want to populate it using values from Table CustomerName:

    Screenshot_3.png

    1. To have 2 columns from CustomerName : List and Value.

    I tried to input named range in field ListFieldRange but this is not working:

    Screenshot_5.png

    Please help how can i do this.

    2. It is possible to attached the combobox to specific cell in table as constant object? (not possible to change it when resizing columns)?
    So when table will be resized combobox also should be populated?
    3. How to lookup using formula in this combobox?

    Goal is to show user different value in a combobox and consume different value attached to selected by user value in same row from source list for combobox (like in Access Combobox)
    For example when user will choose "Jacek" in DV or combobox i will see Jacek but the cell will store value "555".
    But i do not want to add additional columns for it in table or create separate table to get this.

    Please help,

    Best,
    Jacek
    Attached Files Attached Files
    Last edited by jaryszek; 02-14-2019 at 07:12 AM.

  2. #2
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    Anyone?

    Jacek

  3. #3
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    398

    Re: Attached combobox to cell

    Hi,
    Like this?
    Put this code in ThisWorbook module
    Please Login or Register  to view this content.
    and this code in your sheet module
    Please Login or Register  to view this content.
    See attached
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    hi,

    this is not working. But thank you for help,

    when i am clicking on drop down arror:

    Screenshot_9.png

    i see strange behaviour of combobox like in the screen above (after clicking)

    And second question is how to populate this combobox within whole table column for each row?

    And how to populate this combobox without VBA?

    Best,
    Jacek

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,866

    Re: Attached combobox to cell

    Helo jaryszek,

    The easiest way to do this without VBA is by using a "Helper" Column, where we join the Data of the Second Table. We then work from that Column. In the sample Workbook attached, you will see that I have used Column "O" - you may change it as you like.

    Regards.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  6. #6
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    Hi Winon,

    thank you, nice idea.
    But i think this is nit possible to populate combobox into each row into table, to anchor it within row...

    Best,
    Jacek

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,866

    Re: Attached combobox to cell

    Thank you for the feedback jaryszek,

    I don't understand why you say that.

    You simply drag down Column "O" as far as you need.

    Thank you for the Rep+, much appreciated.

    Regards.

  8. #8
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    I want to have this combobox in each row in table.
    To have something like in Access , drop down in each cell in table.
    This combobox i have to insert manually for each row in table,

    Best,
    Jacek

  9. #9
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,866

    Re: Attached combobox to cell

    In that case, may I suggest you delete the ComboBox, and replace it with a simple DropdownBox in Each Row?

    Please see revised attachment.

    Regards.

  10. #10
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    Thank you,

    it would be very nice but i have to show to user only first value, second i have to write somewhere and pass to BE...

    Best,
    Jacek

  11. #11
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2007
    Posts
    5,866

    Re: Attached combobox to cell

    it would be very nice but i have to show to user only first value, second i have to write somewhere and pass to BE...
    Please could you attach a new sample workbook (not a picture or pasted copy), to explain BE...
    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Thank you.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  12. #12
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016
    Posts
    1,617

    Re: Attached combobox to cell

    Sorry, BE it is back-end - java engine which is consuming whole tables (read using java apache poi).

    so i want to add DV list and show only one column within it but somehow store the second value.

    So if user will choose "Jacek" user should see Jacek in table but hidden value attached to Jacek is "555". And second value i want to pass to BE java engine.
    Iw as thinking to use comments for it and selection change event or comboboxex (not possible to implement).

    Best,
    Jacek

+ 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