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