vba proj
 

Hi All,

I have excel based tracker. All the macro part working fine.


Problem is I sent the file to all the users.


Small mistake I made in Macro part ie.,


instead of Uform.optionbutton1 = true I put that one as
Uform.optionbuttion2 = true.


I need to change only one line code in the module.


I am learning how to change the module codes using macro.

pls. let me know how to do this ?

vba proj
 

On Dec 16, 7:49*am, "fi.or.jp.de" wrote:
Hi All,

I have excel based tracker. All the macro part working fine.

Problem is I sent the file to all the users.

Small mistake I made in Macro part ie.,

instead of Uform.optionbutton1 = true I put that one as
* * * * * * * *Uform.optionbuttion2 = true.

I need to change only one line code in the module.

I am learning how to change the module codes using macro.

pls. let me know how to do this ?
Tools-Macro- Select your macro from list of macro names -Edit

vba proj
 

Press Alt + F11
ViewProject Explorer
Then Click the module your code is in.
Make you changes
Click Save
--
Cheers,
Ryan


"fi.or.jp.de" wrote:

Hi All,

I have excel based tracker. All the macro part working fine.


Problem is I sent the file to all the users.


Small mistake I made in Macro part ie.,


instead of Uform.optionbutton1 = true I put that one as
Uform.optionbuttion2 = true.


I need to change only one line code in the module.


I am learning how to change the module codes using macro.

pls. let me know how to do this ?



.