I got the point, can you attach a sample file for me to apply revised logic.
Regards, DILIPandey On 8/4/11, tuffhu...@yahoo.com <tuffhu...@yahoo.com> wrote: > Thanks for the time. However, it's not quite what I was looking for. > > I am trying to design a user form that basically interviews the user. The > first question will be "What manufacturer"? (Instead of a list box, I think > a combo box is actually better). There are at least 5 different choices > here (your example works fine with two manufacturers, but gets kind of large > with more than that). Then the second question will be "What Product"--BUT > the choices available depend upon the answer to the first question. > > I think I could adapt your example to fit my needs IF I wasn't using VBA > code to create the combo boxes. I have named lists that match each selection > possible in question one--I just don't know how to use formulas, etc. to > make them work together in a user form. > > Thanks again for your help. I always learn something from other people's > work. > > Robb > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
