Excel Form - Dependent Combo Boxes Writing To A Cell

[ll]

I am currently working on a form in Excel that will take the date the
user enters and place it in the appropriate row. The main listing is
for courses, and the Combo Box has an option to display all or the
different subsections of it. I had been using the list.index to get
the right row in which to place the date, but with the addition of the
subsections of the main listing, I am quite stuck.
I've tried to add another column that will categorize the courses
(number 1-5), and added a script that will write category 1's to column
such and such (dividing the main list according to category). I then
got the second combo box to be populated with the different
subsections, depending upon what the first combo box selected. It did
this just fine, but once I got this far, I couldn't find a way to find
the row count, based upon the Combo Box selection. The entry needs to
be back in the main (large, uncategorized) listing, and if I use the
list.index for the secondary Combo or the primary Combo, the row will
be incorrect.
Is there some way to get the row number back to a variable, etc., in
order to write to the correct row?
Many thanks

Louis

 

[sachmahajan]

how did you get the 2nd combo box populated? I am trying to do it, but
with no luck