Hello,
I am needing to add a function to my userform to open a PDF file via the results of a combo box. What I have is a combo box that are dependent on the first. The result of the 2nd comb box is the file name that I want to open when I hit the "Open" button. I have a known folder location.
I have attached my code:
Re: Using multiple comboboxes
One last thing, I would like to populate the "Chassis Spec" combobox a different way than 'hardwiring' the specs into the code. I have re-arranged the Chassis Specs tab a little bit and would like to have the "Chassis Spec" combobox get populated based on the "Chassis Sub-Type" combobox selection, which would be column 'A' of the chassis spec tab. Can this be done?
Re: Using multiple comboboxes
Nevermind, works like a charm.
Re: Using multiple comboboxes
I'm getting a Run-time error '9' when I try and run the code after adding the populating the textboxes code. The debugger highlights the 1Rw line of code.
Re: Using multiple comboboxes
Thanks, that worked great. That worked perfectly. Now on to try and finish this up. Thanks again.
Re: Using multiple comboboxes
OK, here's my workbook.
The first tab is the userform start, the second tab has the 2 combobox data that I need to populate the data, and the thrid tab has other data that I can to work when everything is working correctly.
Here's my workbook:
Hi all,
I am trying to develope a userform in EXCEL 2010 that has a couple of comboboxes that pulls data from a specific worksheet. The first combobox is initialized with data from column "A" of the worksheet, which I can get to work perfectly. But what I am having trouble with is the second combobox, the data that needs to populate combobox2 is dependent on combobox1 results which are the column headings ("B" thru "E"). What I want to do is search row 2 find the result from combobox1 and populate combobox2 with the data below that result. Below is my data that I am working from. Any help would be appreciated.
[ATTACH=CONFIG]61566[/ATTACH]
