• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating Combo Box for Indirect Lookup Table

Lhurley1964

New Member
I am new to this forum but you all seem to have the answers :) After days of research I am stuck as I am trying to make two dropdown columns in my spreadsheet open wider using combobox. I copied the VBA code from a site found on Contextures https://www.contextures.com/xlDataVal11.html#download and it works for my primary column dropdowns. When I try to insert the additional code mentioned for "indirect" it does not work. One indrect column is a simple formula but the other is using lookup table. Can someone help with the proper code to use? This is my first time using code so learning on the fly. Attached the file with the code so you can see what I am referencing in Columns E and I.
 

Attachments

Top