Dear Robb, I have attached a simple example on drop down list box.
Based on the first selection the details in the second list box get changed. Similarly in the third list box. 1. name the range 2. go data ---> data validation ---> select list box 3. use indirect function to call the named range Hope this example is sufficient for you. Regards Paul On Thu, Aug 4, 2011 at 5:21 AM, tuffhu...@yahoo.com <tuffhu...@yahoo.com>wrote: > Hello! > > First post, so bear with me. > > I'm a novice VBA user (and love it!), but here is what I want to do: > I want to create a data-validated list box whose options changed based > on entries in an original list box. For example, the first list box > would contain product manufacturers, and the second list box would > contain products names (based on the manufacturer chosen). > > I understand that in an excel sheet, the indirect function works > well. I just can't seem to make this work using user forms. > > Thanks much for your help. > > 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 > -- ---------------------------------------------------------------------------------- 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
drop down example.xls
Description: MS-Excel spreadsheet
