Stock Control

[neoswiper]

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?

 

[parsec]

Can you post your project so we can see what you have done

 

[neoswiper]

http://www.freewebs.com/phallus/Ellenham_s.xls

P.S dont worry about clear and print functions ect. Im gonna record the macros all at once but i need the stock control working first.

 

[neoswiper]

is it even possible? and by the way, why does it say i have macros in my file when i dont?

 

[Smitty]

Have you checked the ThisWorkbook and all Sheet & General modules?

You may have recorded a macro and forgotten about it.

Smitty

EDIT: Welcome to the Board!

 

[neoswiper]

Have you checked the ThisWorkbook and all Sheet & General modules?

Whaaaat? Sorry am an extreme newbie here? Can you explain how to do this?

 

[Smitty]

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.

HTH,

Smitty

 

[parsec]

Here something that will help

http://www.mrexcel.com/board2/viewtopic.php?t=74347&highlight=inventory