Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Form - Dependent Combo Boxes Writing To A Cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Form - Dependent Combo Boxes Writing To A Cell
how did you get the 2nd combo box populated? I am trying to do it, but
with no luck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent (linked) combo boxes | Excel Discussion (Misc queries) | |||
How do I create dependent combo-boxes? | Excel Discussion (Misc queries) | |||
Excel User form with 4 Combo Boxes | Excel Programming | |||
combo boxes on a form | Excel Discussion (Misc queries) | |||
Preventing Writing in Combo Boxes | Excel Programming |