VBA to modify numbers in input column

[CDandVinyl]

I'm trying use VBA to change all numbers below one number to a different number.

An input box would request the column to work on. Having entered this , another input box would request a number below which cells should be changed. A third input box would ask for the number to change them to.

As an example, the user might enter column B as the one to work on , and in the second input box they might enter 5. In the last input box the user might enter 10.

This would mean that all cells in column B containing numbers less than 5 should all be changed to 10.

So , in Column B

2
3
7
1
8

Would change to

10
10
7
10
8


Can someone advise on some VBA to satisfy this?

Grateful for any help.

[nankw83]

Hi CDandVinyl,

Try below code ... Sample file attached as well

Please Login or Register  to view this content.

[CDandVinyl]

Very good - many thanks. It's working fine and does the job perfectly. As I'm working with a long list of numbers , would it be an easy thing to have the changed numbers made to be a different colour , say red? It's just so i can pick them out once the macro is run.

[nankw83]

This will change the cell color to red

Please Login or Register  to view this content.

[sintek]

Another Option...

Please Login or Register  to view this content.

[CDandVinyl]

Many thanks guys for your help. This is working perfectly now. Problem solved!

[nankw83]

Glad to help & thanks for the added Rep.