So i have a macro here designated on shortcut CTRL+E.

When the user presses CTRL+E, certain values will enter in the cell ACTIVECELL.Offset(0, 4). But sometimes there are instances where i want it to be entered on ACTIVECELL.Offset(0,5) or (0,3) depending on the user.


From what I heard there's a macro to edit a macro so i can edit the activecell.offset value as i wish, but they recommended not to do so. So as a workaround i will have plenty of Macros ready and the user just has to set the parameters.

so in my code there will be:




sub option1()

With ACTIVECELL.Offset(0, 3)

    .FormulaR1C1 = _
        "=VLOOKUP(RC[-3],'C:\Users\Kevin\Google Drive\Work\FHE\ESTIMATING PROGRAM\[xyz without local file detection.xlsm]PRICELIST'!R1C1:R65536C43,3,FALSE)"
    .Value = .Value
    End With
end sub

sub option2()

With ACTIVECELL.Offset(0, 4)

    .FormulaR1C1 = _
        "=VLOOKUP(RC[-3],'C:\Users\Kevin\Google Drive\Work\FHE\ESTIMATING PROGRAM\[xyz without local file detection.xlsm]PRICELIST'!R1C1:R65536C43,3,FALSE)"
    .Value = .Value
    End With
end sub

sub option3()

With ACTIVECELL.Offset(0, 2)

    .FormulaR1C1 = _
        "=VLOOKUP(RC[-3],'C:\Users\Kevin\Google Drive\Work\FHE\ESTIMATING PROGRAM\[xyz without local file detection.xlsm]PRICELIST'!R1C1:R65536C43,3,FALSE)"
    .Value = .Value
    End With
end sub
So how can make it that the user can edit his shortcut of CTRL+E to do either option1, option2, option3?