>>>Changing Method Code of an object at run time is not possible. However, why not create a custom method and control what portion of the code to be executed by passing parameters
>>
>>Hi Jess,
>>
>>This is the situation:
>>
>>We want to use code written by an end-user in the refresh() event of an object. We therefore need to read the code from somewhere, ie a memo field, and 'put' this code to work in the objects event.
>
>Try macro substitution to execute line of code
>
>cexecute = Thisform.Editbox.Value
>&cExecute
Totally Good Job! I also put it in my Control Center Form...
But remind you that:
when error occur,
you need to code:
Set Message Tobecause the status bar is blank after error!! ~^_^~
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.