Call the value conain in an Edit Box in a personal Ribbon and use it in macro

I've built a personal tab in the ribbon, which contains an edit box to do basic operations (+,-,x,/). The objective, is to gain time, instead of the classic method, copy a value and then paste special + multiply, add etc
The issue is that i cannot "connect" the editbox with my macro, can you please help?

Thanks a lot
cpmsimoes

(without looking at the code)
What software are you using to create your ribbion? Are you using Custom UI Editor? If you are then you will need to specify a variable in the sub that you are calling, as shown below.

Sub Macro1(control As IRibbonControl)
    MsgBox "Hi There"
End Sub

I'm using Custom UI Editor.

Here one part of the code. I'm getting a Run-time error '424' Object reqired

Any clue?

Sub multiplication(control As IRibbonControl)

  Dim sTextBoxValue As String
  Dim sValue As String
  Dim xTextBoxValue As Double
  Dim xValue As Double
  Dim c As Range
    
  sTextBoxValue = Editbox1.Value

  If IsNumeric(sTextBoxValue) = True Then
    
    xValue = CDbl(sTextBoxValue)
    For Each c In Selection
           sValue = c.Value
      If IsNumeric(sValue) = True Then
        c.Value = c.Value * xValue
      End If
    Next c
 Else
    MsgBox "Error! The value entered '" & sTextBoxValue & " is NOT a NUMBER."
  End If
    
End Sub

Open your VBA put your mouse cursor inside the 'multiplication' macro and press the 'F8' key. this will initiate the break mode and you can step through every line of code until you hit the one that is erroring out. That will give us a better idea on where your code is having a hickup.

Thank's for your reply!

I'm a basic VBA user... but not that basic!