First, I think you should consider carefully Gordon's advice about using this
approach which leaves no room for error and as he says, no audit trail.

As for learning VBA, the cheapest way is to buy a good book (John
Walkenbach's are highly recommended - he has a web site: www.j-walk.com) and
then get lots of practice. Plus use these NGs as an excellent source of
expertise (none better!).

Without seeing your w/book it is impossible to advise you on what to do
next. if you can send a sample to me with clear explanation of
requirement(s), I am willing to offer you my solution(s).

E-mail: toppers at REMOVETHISjohntopley.fsnet.co.uk

"H. Singh" wrote:

Hi Gord
I created Module in a new worksheet - & tried entering data in D2 & pressing
enter -- nothing worked. I tried F5 etc ---.
I have very complicated (for me) sheet with long conditional formulas
working for maintaining my stock for machines parts. I am using Excel 2003
sp2. At present I have to update stock quantity manually. But I want to
automate. If this first step works then I can introduce what machine a
particular stock is required with some machine code check in another column &
if true then it will subtract it othervise not.
& so on it need to proceed to next row for another check
I thought I can limit the formulas calculations so I tried limiting formula
calculations to 1 time only & using F9 -- It is not that good too.
Are these modules - macros.
I need to get a nack of it & once I understand I will work more complicated.
can someone get me going to start on these modules / macros / vb thing in a
simple manner.
--
H. Singh


"Gord Dibben" wrote:

Right-click on the sheet tab and "View Code"

Copy/paste Topper's code into that sheet module.

Start pounding numbers into D2.

I strongly suggest you not use this method.

You have no way of correcting any errors made when entering a new number into
D2.

i.e. you have no "paper trail" to follow to see where an error occurred.


Gord Dibben MS Excel MVP


On Thu, 19 Apr 2007 12:54:02 -0700, H. Singh
wrote:

Thank You Topper -- But how I will implement this in an worksheet.
Can it be simple. Or Where I should start learnig how to use this visual
basic things without big hasstle in short time and without taking lot of
courses and spending lots of money.