Monthly Archives: January 2013

Pegasus‒A VBA based Drag and Drop tool in MS Excel [1/2]

Hello friends..Happy New Year to all of you!

First year in a B-school takes its toll on you. But now, as things have settled down, I’m back.

This time around I’m back with something new—something that will take your MS Excel skills to the next level. We are going to create a drag-and-drop tool which would allow your deliverable to be more interactive. As usual, I’m going to give you a glimpse of what we’re going to develop and follow it with a post explaining how we develop it. And yes, I call it the Pegasus :) .

Our drag-and-drop tool would be a solution for pharma analysts and would help them to analyze the drug pipeline for Pharma companies in a very novel and effective way. We would do a simple two dimensional analysis which would allow the user to view the number of molecules by their mechanism of action that various pharma companies have in their pipeline.

You would ask why to go for such a complicated solution when we can simply use dropdowns to create this solution. Well, my aim here is to demonstrate how to build drag-and drop functionality in MS Excel which will open a whole new range of possibilities for you in the long run. Moreover, it looks and feels amazing!

Just to give you a peek of what we will be learning, I’ve uploaded a video (shown below).

The list below is mentioned just to tell you what all we will be using in to develop this tool: Continue reading