Hey guys,
I am currently trying to build a UserForm in which the user can search for a value and replace all occurences of it in the whole workbook with a new one. In addition a date should be put into the same row but 2 cells next to it.
So the user fills in the value to be searched for, the replace value and the date. After clicking a button the value is to be searched, replaced and the date is to be written 2 cells to the right.
One additional problem for this might be that the value to be searched for is only one letter (for example "a"). Im not sure to what extend this is a problem because all other values in the column are numbers stored as text because they are so long.
I am not so experienced in this so can someone provide me with some code?
Cheers
I am currently trying to build a UserForm in which the user can search for a value and replace all occurences of it in the whole workbook with a new one. In addition a date should be put into the same row but 2 cells next to it.
So the user fills in the value to be searched for, the replace value and the date. After clicking a button the value is to be searched, replaced and the date is to be written 2 cells to the right.
One additional problem for this might be that the value to be searched for is only one letter (for example "a"). Im not sure to what extend this is a problem because all other values in the column are numbers stored as text because they are so long.
I am not so experienced in this so can someone provide me with some code?
Cheers
