Updating VBA event code at runtime

[CyberDwarf]

Hi

I'm sure this has been asked before, so my apologies in advance for dumb
questions!!!

Has anyone been able to update the VB code for events fired by, eg., command
buttons?

Any suggestions greatly appreciated

Steve

 

[Douglas J. Steele]

Changing code at runtime is a fairly unusual requirement. Perhaps you could
explain what you're trying to do, and someone can offer an alternate
solution.

If you really need this ability, though, take a look at some of the methods
of the Module object like DeleteLines or InsertLines. You can get
information about these methods in the Help file, or at
http://msdn.microsoft.com/library/en-us/vbaac11/html/acobjModule_HV05186685.asp

 

[CyberDwarf]

Hi Douglas

Thanks for your reply.

I have a requirement to change the way events fire, depending on the user of
the form.

Eg., client1 needs the standard event code, but client2 needs the event to
perform a different action (sorry I can't be more specific, but I'm already
running into non-disclosure arguments!!).

Problem is that I have a set-in-concrete startup routine which already sets
certain client parameters (changes labels, hides text fields, changes sort
orders, etc) and I have to operate within this setup. I know there are other
(easier!) ways to solve this, but.....

Prime example, tho', is the need to amend the VB code which is fired from
the Help button (this is client specific).

BTW, thanks for the MSDN link

Steve

 

[Rick Brandt]

Hi Douglas

Thanks for your reply.

I have a requirement to change the way events fire, depending on the
user of the form.

Eg., client1 needs the standard event code, but client2 needs the
event to perform a different action (sorry I can't be more specific,
but I'm already running into non-disclosure arguments!!).

Problem is that I have a set-in-concrete startup routine which
already sets certain client parameters (changes labels, hides text
fields, changes sort orders, etc) and I have to operate within this
setup. I know there are other (easier!) ways to solve this, but.....

Prime example, tho', is the need to amend the VB code which is fired
from the Help button (this is client specific).

BTW, thanks for the MSDN link

Steve

You would not accomplish this by modifying the code on the fly. You would
run *different* code...

If (However you determine the user) = "client1" Then
Call SomeSubRoutine
Else
Call SomeOtherSubRouitne
End If

 

[CyberDwarf]

Rick

Yup, all understood & agreed, BUT....

I have had the restrictions imposed on me ;-(

Thanks

Steve

 

[CyberDwarf]

Douglas

Thanks again for the link. I now have working code!!!

Very useful stuff

Steve