Very easy question that REALLY needs to be answered!! plz he

[Sami]

What is the visual basic code that AFTER or WHEN enter has bee pressed in cell F5 THEN run this code

'Look for the ProductID in the Stock Table.
StockWorkbook.Seek "=", ProductID

'When found, take the current quantity and subtract from it the sold quantity.
If Not StockWorkbook.EOF Then
StockWorkbook.Edit
StockWorkbook!Quantity = StockWorkbook!Quantity - SalesWorkbook!Quantity
StockWorkbook.Update
'

End Sub


thanks i really need this quick
its in for friday!!

[Jack in the UK]

Hi Sam

this post links with feed

http://www.mrexcel.com/board/viewtop...2646&forum=2&6

Correct....

[Sami]

Cell F5 is just the total cost of the cell. Its got the formula D5*E5. Help plz!

[Jack in the UK]

Sami

The ideas of my HTML Hype was to kill this feed as you have posted the same question twice, please let this post feed drop off the board, as people are anwering the other feed, its worthless to feed twop questions of the same subject no matter if thay are only similar or very close, stick to the one feed.

Please

That way you get the result you want, also dont keep adding Pze quotes as poople will flick the post, i moniotor feeds and so do some pals and we pledge to answer any unanswered posts.. in a best time poss so feer not, some answers will be there, but if only posters understand and know the answers.

I know your young and so i am truly trying to help, i expect you to understand these commenmts...