vba proj

  • Thread starter Thread starter fi.or.jp.de
  • Start date Start date
F

fi.or.jp.de

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 ?
 
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 ?
Click to expand...
Tools->Macro-> Select your macro from list of macro names ->Edit
 
Press Alt + F11
View>Project Explorer
Then Click the module your code is in.
Make you changes
Click Save
 
Back
Top