Stop

[WaterSprite]

This is sort of a continuation of my Select Case question from 22 September, 2010. I took everyone's advice about not using input boxes for data entry. So, now my problem.

I am using a drop down list in 3 cells for names to be selected from a preset list and placed in a cell. I am using [Stop] to give the person a chance to select the name from the drop down box.

But, I cannot figure out how to get the execution to continue or resume by code after the [Stop] command and the name selection in the cell. Obviously, with the code sheet up, I can do a restart from the toolbar, but I do not want my end users to have to click something on the code sheet. So, I need something like a button on the worksheet they can push to resume the code execution after [Stop}.

 

[SkipVought]

Hi,

One process preceeds the user selection event.

Following the user selection event, a second process occurs, presumably the code that you have following the STOP. This process could be triggered by the user selection event, or it could be triggered by some other event, like a button click event.

Bottom line: Don't STOP a process to wait for something to happen.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

Yes. Why are you using Stop?????


unknown