Hi Guy's
Someone helped to write the below code, it populates some combo boxes on a userform, it also allows me (from the userform) to type in a new supplier and it will check to see if it exists, if it doesn’t exit, it gets added to the list.
The data that populates the combo boxes comes from Tables in a sheet called “Lists” of the same workbook as the userform.
I have created a new workbook called Payees, I have copied the “Lists” sheet to the new workbook and named that sheet “Lists” also.
In theory everything is exactly the same other than the tables are now in another workbook called Payees.
Can someone please help/advise how I should alter the code for it to continue populating the combo boxes and for the Lists to get updated if I enter a non-existent entry.
The new workbook Payees is Open.
Thanks for looking.
Bookmarks