Event VBA cell multiplication

[Redland]

Hi Guys,
I'm a new member, so apologies for any incorrect formatting!

It's fairly easy (but I've never had to use Excel in this capacity!) I have a list of destinations set against each other with the distances of such in the corresponding cell, I'm trying to create an event to find out the cost of the journey by multiplying it by a set cost (in a separate cell).

I'm trying to use an active X button so that, once the distance has been selected, you click the button and a MsgBox will appear with the cost (as a result of the distance being multiplied by the cost).

The table ranges from B6:AE35 with the cost located in cell AE:37

Can anyone help me with the VBA for this? As I said, I'm just having difficulty as a newbie!!

Thank you for your help,

Jim

 

[Arjan77]

Private Sub CommandButton1_Click()
MsgBox ActiveCell * Cells(37, 31), vbOKOnly, "Costs"
End Sub

 

[Redland]

Awesome!!

Thank you Arjan77