HELP PLS! How to erase the content of an InputBox without For Each

[fefo32br]

Hi!

I would like to know if there is any way to erase the content of an InputBox inside a selection WITHOUT USING FOR EACH (when i used, the macro was veeery slow for big selections).

Thanks in advance!

example:
Capture.JPG

[kersplash]

Can you just do a find and replace on the range?

[fefo32br]

Actually this is what I have to do everytime a want to erase..... LOCATE / SELECT ALL / DELETE THE CONTENT / TAKE OFF THE COLOR

But I do it a lot of times...I want to save some time, this is why i want to do it by VBA...

[kersplash]

Maybe attach a workbook showing before and after what you are trying to achieve.

Go Advanced -> Manage Attachments -> Upload

Try and use the same layout and real-world data (desensitised) in your sample.

[fefo32br]

Hi!

I Have attached an example with the objective and before / after.

Thanks for your help!!