Can anyone help with calling a function (B) and return control of program flow to the calling function (A)?
These functions are in different modules of the same workbook's VBE.
The modules contain only those functions.
Ideally, control would return to function (A) at the point where function (B) was called after function (B) does its work.
I guess it would work like a gosub...return.
Here's why:
The code to locate a value (from an input box) in a column (C) has been written but this code has to be run for each task the user will perform, (ie: new entry, delete entry, edit entry, etc.);
All tasks are accomplished through some sort of dialogue box (msgbox, inputbox and/or userform), there is no direct entry into a cell.
Each task is different enough to require its own code but they all require finding an inputted value in col. C to begin to determine where the task is to take place.
So is anyone that can help?
These functions are in different modules of the same workbook's VBE.
The modules contain only those functions.
Ideally, control would return to function (A) at the point where function (B) was called after function (B) does its work.
I guess it would work like a gosub...return.
Here's why:
The code to locate a value (from an input box) in a column (C) has been written but this code has to be run for each task the user will perform, (ie: new entry, delete entry, edit entry, etc.);
All tasks are accomplished through some sort of dialogue box (msgbox, inputbox and/or userform), there is no direct entry into a cell.
Each task is different enough to require its own code but they all require finding an inputted value in col. C to begin to determine where the task is to take place.
So is anyone that can help?