help with calling a function (B) and return control of program flow to the calling functio

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?

Quick reply to this message Reply Reply With Quote Reply With Quote Multi-Quote This Message

Jeff,

Thanks for the suggestion.

It's like the guy whose tooth ache goes away in the dentist's waiting room: I've come up with a couple of ideas that I'm going to try first.

Either way, whether I River Walk my own way through this or try your suggestion, if anything works then I'll come back and post it.

Later,

John

Just a comment on the original post - if you call a sub/function from another sub/function then once the called sub/function has completed control will return to the calling sub/function.

So there's no need to tell the code to return to the calling sub/function.

Jeff,

I think I found a solution. It involves a public variable.

I'll let u know.

John

Originally Posted by john/nyc

Jeff,

Thanks for the suggestion.

It's like the guy whose tooth ache goes away in the dentist's waiting room: I've come up with a couple of ideas that I'm going to try first.

Either way, whether I River Walk my own way through this or try your suggestion, if anything works then I'll come back and post it.

Later,

John

Jeff,


It was a poorly asked question.

1) The calling function is a user form with 7 option buttons in a frame that is launched from workbook_open. Each button launches a different task (enter new appointment, cancel existing appointment, edit existing, etc.). Don't want to return there.

2) The called function is code that locates an apartment number after error checking. This code, itself, ends with a call to another function the allows the user to input(box) an appointment_date. Then the appointment_date function calls the appointment_time function which calls the doctor's_name function , and so on.

3) This was dandy as long as all that was being done was to enter a new appointment, but what if cancel_appointment was the chosen task? The code to enter a date wasn't needed but code to find a date had to be found and plagiarized.

4) But locating an apartment number was needed in all the tasks. Initially it was just copy_paste the apt. locate code at the beginning of the all the code no matter the task. Didn't think that was the way to go even though it worked.

5) What was actually needed was a way to send flow from the apt. num. function to the next function dependent on which task option was selected in the initial user form.


What I wound up doing was declaring a public variable at the tippy_top of this_workbook. Then, in the user form code, giving that variable a different value to correspond to the chosen task. Then testing that value at the end of the apt. num. code in order to send control to the appropriate function. It also became handy for changing the prompts in a msgbox to reflect the task at hand.

I'm sorry that you had to waste your time answering a dysfunctional question. I'll try, in the future, to think things more thoroughly through.

Thanks again,

John