Hello all,
beginner to VBA so please bear with me,
I have been tasked to write a macro for a purchase order form.
I have attached the file to help you guys understand and see how much of mess I got myself into.
I have currently written code so all active cell data is picked up and recorded on to a separate data sheet via a click of a button,
I have found if this button is accidentally double clicked this will recorded the data twice.
I am lost of how to prevent this.
please see attached the work sheet I am working on Macro PODATA
I understand I my current work might be the long way round but all of this has been hand typed and not recorded.
IF you could help me that would be amazing as I have been working on this for weeks and being chased up now.
Thank you in advance for tips and help
Bookmarks