A good portion of the questions I get in my IT side job have to do with Visual Basic scripts, typically in Excel or Access. The first step to creating your own scripts is making the developer tab visible.
I am by no means intending to replace your IT or programming team. Developer scripts and Visual Basic scripts can be powerful if used correctly, but in this blog, it’s just ramblings of things I get asked a lot. I’m not here to replace anyone or provide professional advise.
- Open Microsoft Excel (I’m using Office 365 – steps will be varied slightly for any other version).
- In the File menu (top left), click options
- Customize toolbars
- Make sure the check box beside developer is checked.
Once this is done, you can record macros for things you do often and start creating buttons or quick fixes for yourself.