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?
Bookmarks