Ok, I have just started a project. I have to create a till which controls the stock, and print a reciept and clears the screen everytime someone purchases something. Ive done everything apart from the stock control. Any help?
Sorry. In Excel, hit Alt+F11 to open VBA. You should see the project Explorer on the left hand side of the screen. If not, hit CTRL+R.
You'll see VBAProject(YourFileName.xls), then a folder called Microsoft Excel Objects. WHen you open that folder, you'll see ThisWorkbook, then Sheet1(SheetName), Sheet2(SheetName), etc., and any Modules that VBA added when you recorded a macro. Check all of these for any errant code that you may have recorded.