Help needed - macro button that increases/decreases specific value to a range of cells

[Cuzzaa]

Hi everyone,

Hope you can help.

Is anyone able to help me with some vba for a macro button then when clicked presents the user with a popup to either increase or decrease (add or minus) and then a second user input field to enter a number, i.e. the user clicks the button, then is asked to select either 'Increase' or 'Decrease' and then asked to enter a value i.e. '10' so that the values in cell range 'H1:H100' are all increased by 10?

Please let me know if there's any other info you need if this isn't clear?

Thank you SO much!

 

[Cuzzaa]

I can use something similar to the below but how can I amend this so that the user is prompted to select either increase or decrease and a value to each of the cells in the range?

Private Sub CommandButton1_Click()
Range("H1:H100").Value = Range("A1").Value + 1
End Sub

 

[Fluff]

Duplicate Vba help needed please - change range of values by x number

Please do not post the same question multiple times. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).