Here's my little problem
I have a workbook with a "personalizede toolbar
On this toolbar, I've got n buttons (n=A to I)
With theses buttons I've got theses macros
I've copy VcellA() code for each letters (A to I)Public Sub prms() Dim ce As Range, rg As Range End Sud Sub VCellA() prms Set rg=Application.Selection For Each ce In rg ce.Value="A" Next ce End Sub
So I've got the "module"
Sub VCellA(), Sub VCellB() ... Sub VCellI()
Is there a way to have only one macro who indentify wich button I click on
and adjust the right letter value in the selected cells?
Thank for your help