OnClick Sub Deletion from VBE

[cgi_pro]

Hello

I have the following code in Sheet1:

Please Login or Register  to view this content.

and I have a button in a form, and when I click on it I want it to delete that Sub (the Some_Name()) entirely from Sheet1 VBE

What's the code for that?

[dominicb]

Good morning cgi_pro

I can sort out some code fot that for you. Before I do can you just confirm that the code is in Sheet1's module - not a regular code module? It makes a difference...

HTH

DominicB

[cgi_pro]

Yes, it's in a sheet that I called (PlayersList) as its codename instead of the default Sheet1

Thank you in advance

[dominicb]

Hi cgi_pro

OK, have a look at he code below :

Please Login or Register  to view this content.

You're going to have to set the relevant references for this to work : if you didn't have to do it after my last post to you, have a look here for a refresher :

http://www.excelforum.com/showthread.php?t=581170

Also you will need to keep the "trust access to visual basic project" box ticked.

HTH

DominicB

[cgi_pro]

Thanks a lot dominicb

But can you please explain to me the following in the "ProcStartLine("Some_Name", vbext_pk_Proc)"

• What are you referring this "Some_Name" to? I mean what do I put in its place?
  
• What's that vbext_pk_Proc?
  
• What value does this ProcStartLine return? I believe the line number of rhtta procedure right?

[dominicb]

Hi cgi_pro

Does the code not work or are you just dissecting to find out how it works? I wrote the routine for you based on the information you gave me. Some_Name is what you have inferred is the name of your routine in the above code, which I thought suspicious at the time - if your routine is realy caled "test"

Please Login or Register  to view this content.

then replace it with test.

vbext_pk_Proc is a VBA instruction from the VB Project Extensibility sub set (which is why you check the reference).

.ProcStartLine (and ProcCountLines) are commands to determine the start and lebgth of the code - you then delete starting from the startline for the number of lines.

HTH

DominicB

[cgi_pro]

Thanks again dominicb

you're a good help