Excel basic macro help

[jared511]

Hello,

I created a macro that is very simple. I linked the macro to a button that is also on the spreadsheet. When you click the button all the macro does it =randombetween(a1,b1)

that's it.

However whenever I enter any information on the sheet seperate from the macro, it triggers the macro to run and changes the result. Any idea how to stop it from running and restrict it only to run when I click the button?


Thanks,
Jared

 

[VoG]

Try like this

With Range("A1")
    .Formula = "=randbetween(a1,b1)"
    .Value = .Value
End With

 

[jared511]

I want the result to populate in cell G16. Can you add that to your macro? And thanks so much for your help!

 

[VoG]

That would be

With Range("G16")
    .Formula = "=randbetween(a1,b1)"
    .Value = .Value
End With

 

[jared511]

Pure genius thank you sir!