Posted to microsoft.public.excel.programming
|
|
Update the list of a combo box, depending on another c.b
Hi Ctech,
See xlDynamic's Dependent Dropdowns page at:
http://www.xldynamic.com/source/xld.Dropdowns.html
---
Regards,
Norman
"Ctech" wrote in
message ...
I have two tables, which is to generate a form.
- The first table has 8 different cost centers.
- The second table have a list of task numbers, and the linked cost
centres.
Each cost centre has a set of task numbers, but there is just one cost
center for each task.
I want to first pick a cost centre from a combo box. I then want the
task numbers in the second combo box to be unique for that cost
centre.
How can I do this? By a macro?
--
Ctech
------------------------------------------------------------------------
Ctech's Profile:
http://www.excelforum.com/member.php...o&userid=27745
View this thread: http://www.excelforum.com/showthread...hreadid=523512
|