dss28
Board Regular
- Joined
- Sep 3, 2020
- Messages
- 165
- Office Version
- 2007
- Platform
- Windows
In Sheet1, I have data in range A5 to A15 and corresponding data in range B5 to B15.
If I enter a text in userform1.textbox1 ( eg corresponding to say text in cell A5) and another text in textbox2, the code should search this text in textbox1 in column A of the sheet1 and replace the cell B5 text with that of textbox2 text.
can anybody help please.
If I enter a text in userform1.textbox1 ( eg corresponding to say text in cell A5) and another text in textbox2, the code should search this text in textbox1 in column A of the sheet1 and replace the cell B5 text with that of textbox2 text.
can anybody help please.