Any VB Experts Out There?

It actually is much easier using Data | Validation than with VB.

Check this topic for a good example

http://www.mrexcel.com/board/viewtopic.php?topic=40&forum=2

I set up a worksheet like this:

The titles in row 1 are the names of the ranges below.

Then I created a UserForm and added 2 ComboBoxes. I assigned List as the RowSource for ComboBox1.

Then I wrote this code to synchronise the RowSource for ComboBox2:

this is similar to my problem can someone post a code, my post is called combo box question.

I have done something like before and it hasnt helped. I am working in a Structural Engineering Firm. The first combo box has a list of different steel beams shapes (like W, T, S, etc), and the second box has the different sizes of each shape (example - W44x35, W44x29, etc.) The problem i now propose to you true believers, is the fact that after the user has made a selection in the second box, all these characteristics pop up below them on the same sheet. All these above data are in a chart that looks like this:

Type Shape Dia Wt Area Wedge Shear..
---- ----- -- -- ---- ----- -----
W W44x35 44in 353lb 98in3 2.5 136lb-f
W w44x29 39in 339lb 82in3 2.1 129lb-f

...and this continues on for 102 columns and 1924 rows of data.

The way my sheet is set-up now is, I have my data-->validation boxes set-up so when you pick the second one (in C7) the names of each of the characteristics is revealed using the =INDEX(dia,c7). This works perfectly fine.

I wanted to have the combo boxes do that now, so if that makes the codes different or whatever can you please.

I also need to know where to put the code and how to activate it.

Thanks again

What do you want to do if the user selects something from ComboBox1 or ComboBox2? Put the selection in a cell? If so which cell(s)?

What I want is when something is selected from combobox1 (say names of teams) i want combobox2 to have information specific to the choice in combobox1 (say names of the players on the teams). and when they choose the choice in combobox2, i want information to appear in the cells (say the players statistics for the season). so what i really wish would happen is that somehow i can treat the combobox2 as a cell and just reference the box in a formula as you woul do in a cell.

Well i guess Im on my own then...wish me luck everyone

On 2003-01-09 11:12, vburns01 wrote:
What I want is when something is selected from combobox1 (say names of teams) i want combobox2 to have information specific to the choice in combobox1 (say names of the players on the teams). and when they choose the choice in combobox2, i want information to appear in the cells (say the players statistics for the season). so what i really wish would happen is that somehow i can treat the combobox2 as a cell and just reference the box in a formula as you woul do in a cell.

Click to expand...

So in which cell would you like to put the information from ComboBox2?

Honestly it doesnt matter but just so the answer is out of the way how about we put it AA1