vba vs macros

[RedGoneWILD]

if the majority of my code is in vba, does it hurt to have some simple stuff in macros...like a close form button or whatever

i was reading that macros are amateurish, and you should make your whole program in vba...but i copied a couple of buttons or what not from templates or examples, and i absolutely do not understand macros at all...i understand vba A LOT better...but im scared to change it because i need it to still work.

any thoughts?

[trb5016]

Eh, I think you're alright with simple macros. I use them to for simple form opens.

If you want there is an option to "Convert Form's macros to Visual Basic"

I've only ever used this for simple macros (I could never make anything complicated without VBA in the first place lol) but you might want to check it out.

Also, it seems like this may be a global option (though this might be in my head and not actually true)

Regardless, it's probably a good idea to make a backup before making any changes

[RedGoneWILD]

thanks for the reply...i found the convert macros option, so we'll see what happens!

[TheShabz]

"Anything you can do I can do better"
-VBA talking trash to Macro

If you got VBA going, stick with it.

[maximus]

I prefer VBA even to do the little stuffs. If I may, I will always advice VBA over macros .