change value of selected cell by click on bottun +vba

[kar2rost]

Hi Good day
I want to click on a button to change the value of the cell I selected with the mouse to another value that is fixed in other cells.
For example in the cell
Like the picture sent

 

[Logit]

You'll want to consider using Data Validation - List.

Try this link for instructions : How to create a drop-down list in Excel -- quickly and easily

 

[kar2rost]

You'll want to consider using Data Validation - List.

Try this link for instructions : How to create a drop-down list in Excel -- quickly and easily

Tank u.but i want to slove this by vba code

 

[kar2rost]

Tank u.but i want to slove this by vba code

hi anybody there to help me plz

 

[Joe4]

All you need is VBA code attached to the "sep" button that looks like this:

Sub SepButton()
    ActiveCell.Value = "sep"
End Sub

Repeat the same logic for your other buttons.