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.
159.3 KB Views: 5