VBA code for ADD and CHANGE events for Combo Box on worksheet
I have a worksheet which has Order designed on it with Combo Boxes for Supplier and Item information which are named ranges in Supplier tab and Item tab used in listfillrange property in Combo Box with Linked cell property referencing cell B11 and G11 on PO tab. When changes are made to any of the cells linked to the I need the change event to update the relevant source tab (font red) and add system date to changed row in first available blank column on tab. I the item does not exist on tab use ADD event to add item to bottom source sheet with date added.
I have added my workbook it is pretty self explanatory.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By excelnewb02 in forum Excel Programming / VBA / Macros
Last Post: 09-21-2012, 08:44 PM
By jomili in forum Excel Programming / VBA / Macros
Last Post: 12-13-2010, 06:14 PM
By JBW in forum Excel Programming / VBA / Macros
Last Post: 04-22-2009, 01:33 AM
By Potoroo in forum Excel General
Last Post: 11-28-2006, 12:59 AM
By brazierpt in forum Excel Programming / VBA / Macros
Last Post: 05-14-2005, 05:29 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1