 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / March 2006Update the list of a combo box, depending on another c.b
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 cos centres. Each cost centre has a set of task numbers, but there is just one cos center for each task. I want to first pick a cost centre from a combo box. I then want th task numbers in the second combo box to be unique for that cos centre. How can I do this? By a macro -- Ctec Hi Ctech, See xlDynamic's Dependent Dropdowns page at: http://www.xldynamic.com/source/xld.Dropdowns.html --- Regards, Norman > I have two tables, which is to generate a form. > [quoted text clipped - 10 lines] > > How can I do this? By a macro? Norman Jones: I've tried to follow the tutorial you pasted. However Im still havin some problems.... Im not sure what it is... I have attached my file, so if someone have the time to take a quic look at it. That would be great +------------------------------------------------------------------- |Filename: Data for for pack.zip |Download: http://www.excelforum.com/attachment.php?postid=4483 +------------------------------------------------------------------- -- Ctec Do anyone know of any other tutorials to dynamic drop down lists, whic I can read and try to find out the errors myself -- Ctec Hi Ctech, See Debra Dalgleish's page on dependent dropdowns at: http://www.contextures.com/xlDataVal13.html --- Regards, Norman > Do anyone know of any other tutorials to dynamic drop down lists, which > I can read and try to find out the errors myself? Hi Ctech, Few regular contributors would be prepared to open unknown attachments. Try, instead, enunciating the specific problems that you encounter and show the problematic code snippet(s). --- Regards, Norman > Norman Jones: > [quoted text clipped - 8 lines] > |Download: http://www.excelforum.com/attachment.php?postid=4483 | > +-------------------------------------------------------------------+ |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.