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. 

  1. Open Microsoft Excel (I’m using Office 365 – steps will be varied slightly for any other version).
  2. In the File menu (top left), click options
  3. Customize toolbars
  4. 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. 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s