passing values

[DSJ]

Here is what I mean. If I have a routine that gives me a temp value of a record, FIND where C.select matches the criteria the user is looking for.
I then need to pass this value onto another routine "UPDATE" to the record can be updated.

In my FIND routing I have the value of C. SELECT to show my current record match, I then need to update the record with my UPDATE routine.

How can I put UPDATE on the same record as FIND? the problem I am having is find work independently from UPDATE so Update is not at the same record as find.

Any help would be appreciated.
Daniel

[Leith Ross]

Hello Daniel,

In VBA values are passed two ways: by value (ByVal) or by reference (ByRef - this is the default). By value creates a copy of the object in memory for private use by the calling routine. By reference passes the object address (pointer) to the object itself. This allows you to directly interact with object without copying it first.

If your Find routine is searching a range then it will return a range object if successful. You can pass this ByRef to another routine to modify those same cells directly. If you want to do some trial manipulation of data, you can pass it ByVal. The changes made on this data won't affect the original data.

Sincerely,
Leith Ross

[DSJ]

Leith,

Thanks for the explanation.