VBA FIND Function, User Edit then upon cancel continue VBA

I want the user to be able to find each cell matching the What, make changes to any it finds, then upon cancel, continue the VBA to the next What and so on until done with these three searches. Everything I know about VBA comes from searching the internet, so I am missing the fundamentals. Thank you for your time!

Please Login or Register  to view this content.

Originally Posted by christinelennard

make changes to any it finds

Do you want the user to be able to change the cell that was found, or something else, like another cell on the same row?

There are a couple of problems in your code.

I am not sure what you are doing with the SendKeys since you are already using Find to find the cell. You need a loop for each value that you are trying to find. The tricky part is having a loop and also giving the user a chance to make an edit during the loop. The way I would do that is each time the value is found, present an InputBox with the value and give the user a chance to change it there.

Also I discourage you from using Find as the name of a Sub since it is also a method on Range. It will probably still work but could potentially be a problem later.

You wrote a With clause but then never used it to make a reference. Maybe you are unclear on how it works.

I have attached a file with a solution. The code will run on the sheet called Format. This is not a bulletproof solution. If the user hits Cancel when the input box comes up, the cell will be blanked out. If that is too dangerous for you then it needs a custom userform to make the update.