• bstix@feddit.dk
    link
    fedilink
    English
    arrow-up
    3
    ·
    7 months ago

    You can learn how. VBA for Excel is pretty easy to learn on your own.

    There’s probably a lot of material online for learning it, but that will most likely only scare anyone off from actually getting started, because it is too comprehensive.

    I suggest you just start trying and then search for each problem at a time. You’ll soon learn how to make anything you need.

    The first step is to get familar with macros. Enable the developer tab and record a macro. Start with something easy, like searching for a word and format it as bold or whatever. Then stop the recording. In the macros dialogue box you can set a keyboard shortcut so the macro will run everytime you press that key combination. Play around with it.

    If you then open the visual basic editor or click edit on the macro, you can see what code was recorded.

    You’ll soon realise that even if macros are powerful, they’re also very limited for larger tasks. There’s always something that doesn’t really work as intended when trying to use it on other cases. That’s when you need to start editing the code and this is when the online resources come in very handy. Simply search for “vba” and any function this causing issues and you’ll easily find solutions.