Hey guys,

I'm new to VBA/programming and I am trying to create my own formula in excel for which I believe VBA is required. I often have to manually convert between different units of oil/gas and would like to install a few custom formulas to be able to make it easier. One example is the conversion from Billions of Barrels of Oil (Bbl) to Millions of Cubic Feet (Mcf). The conversion factor for that is 6, so simply 6*Bbl = Mcf. How could I go about entering that in VBA so that when I wanted to quickly convert Bbl into Mcf I could just enter in a cell = x*Bbl_to_Mcf? (The idea being I type the "Bb" and the rest of the formula name auto fills). Also, should I make it as a plugin? (Not entirely sure what that is though)

Thanks for the help.