Keeping updated lists throughout an entire document through referencing a template
I am working on a project as a contractor, and I am having a somewhat interesting problem. The company sells chemical products and I was instructed to have one page where the products are listed and can be updated throughout the document. I was also instructed to use type selective drop-down boxes (I used combo boxes) for each day, for an entire monthly report. My current issue is having to manually update 300 combo boxes of the products list because I don't know of any way to have them update automatically when the 'Products List' page has been updated. Any ideas?
June 11th, 2015 1:53pm

Hi Hal,

Based on your description, you wonder to add a List Page which products are listed in that page. And you wonder to update 300 combo boxes automatically when the List Page update. I suppose you can use CODE to get your result.

I suggest you post your issue to MSDN forum for Excel Developer, Im not good at VBA code and this forum is to discuss questions and feedback for Microsoft Excel.

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
June 12th, 2015 5:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics