Macro Within a form

[shariefoo]

Hi,
Is it possible to create a button in a form and then add codes to it and when clicked it updates an exsisting macro ??

Example:
I want to import an excell sheet, of course i have to use a macro, however, could i create a button that when clicked it updates the macro details like change the oath of the excel sheet ?

 

[namliam]

try using a module (VBA) instead of a macro. Macro's are much too limitted...

Regards

 

[shariefoo]

How ??

Ok thanx..

You know how ??? the problem is i never used modules. I have always worked with macros

 

[namliam]

Try searching the forum... many a sample out there...

Try this search for starters...

Regards