FrenchCelt
Board Regular
- Joined
- May 22, 2018
- Messages
- 214
- Office Version
- 365
- Platform
- Windows
Hello,
I'm trying to code a macro that will pop up an input box and then select a range with the text entered into that input box.
For example, if the user types "name1" into the input box, the macro will search for name1 in Column A and select that cell plus the six cells to the right (e.g. if the text is found in A35, the range selected would be A35:G35).
I should be able to code what I need to do next for that worksheet, but then I want to switch to a different worksheet and search Column C for the same text and select the entire row.
Can anyone provide some guidance?
I'm trying to code a macro that will pop up an input box and then select a range with the text entered into that input box.
For example, if the user types "name1" into the input box, the macro will search for name1 in Column A and select that cell plus the six cells to the right (e.g. if the text is found in A35, the range selected would be A35:G35).
I should be able to code what I need to do next for that worksheet, but then I want to switch to a different worksheet and search Column C for the same text and select the entire row.
Can anyone provide some guidance?