Pricing update on Userform

[Jerrold]

I have a userform that shows current pricing we just had a price increase that was a 3.5% increase, and instead of just changing each price one at a time I would like to add a textbox that shows the 3.5% & command button that will update the pricing in the current textboxes.

 

[SteveO59L]

something along the lines of

Dim c As Range, rng
Set rng = Range("a1:a20")
Dim my_val As Double

my_val = InputBox("enter new value")
For Each c In rng
c.Value = c.Value + ((c.Value * my_val) / 100)
Next c

 

[Jerrold]

the textbox I am wanting to update is on a userform not a spreadsheet...I think I have to repaint the textbox but not sure how to write the code