Quote Originally Posted by fb7894
Sounds like you're Workbook B is acting as a database. Maybe you'd have better luck if the UserForm in Workbook A updated an Access db?
Ideally that is something that I would like to do. At the moment we are only using workbook A so it has the User Form and the database on a seperate worksheet. My skills with excel and access, don't currently, strech to linking between the two applications but this is something that I am work on.