Hello!
I am using my first form within a VBA project and could use assistance from the experts in this forum! Overall, the project is designed to automatically open a bunch of invoices and copy them over to the main file. In this file, I want to ask the user if an invoice is a specific number. If it is that number, then I want it to automatically code it something different than the excel formulas indicate. So more specifically...
My goal is to call a form within a sub, enter data into the form, and then use the same data within the sheet and edit fields based on the data entered. The prompt opens and it allows me to enter data but then it never actually changes the information. I have isolated the code within the form and it worked as stand alone code - however, when I try to call it from the form - it simply continues without actually making the edits. There is no error message or anything like that, it just doesn't do what I want it to do. I think this must be a simple error but I could really use some help here - I am banging my head against the wall on this one...
In order to call form I created from a sub can I simply put:
Here is the code within the form, perhaps this is where the problem is located.:
It might be easier to analyze the problems by viewing the workbook and code directly so I have attached the sanitized Invoice Creator workbook as well as four example invoice work books. When the prompt comes up I want to select PFD and enter invoice number "36230352" and "36230354", then select SO and enter invoice number "36230355" and then, finally, select no.
Any help on this would be greatly appreciated!!
Bookmarks