Calvin1128
New Member
- Joined
- Mar 27, 2022
- Messages
- 8
- Office Version
- 2021
- Platform
- Windows
Hi!
I am seeking help on VBA for locating and going to the cell.
I wish if I can type something in a cell under tab1, I can locate and go to the same cell in another tab (Only 1 cell would be the same within the whole file) after clicking a button
It is literally like control + F...
I have created a test file for detailed reference.
Like If I type "ABC1234" in "Sheet1", I would like to go to cell A4 in "TAB2" as they are the same.
Is it possible to make it? I have seen similar threads and posts, but I am a newcomer in VBA and I cannot change it for my use..
Hope anyone can help and let me learn from this task
Feel free to ask me to supplement any details! Thanks a lot!
I am seeking help on VBA for locating and going to the cell.
I wish if I can type something in a cell under tab1, I can locate and go to the same cell in another tab (Only 1 cell would be the same within the whole file) after clicking a button
It is literally like control + F...
I have created a test file for detailed reference.
Like If I type "ABC1234" in "Sheet1", I would like to go to cell A4 in "TAB2" as they are the same.
Is it possible to make it? I have seen similar threads and posts, but I am a newcomer in VBA and I cannot change it for my use..
Hope anyone can help and let me learn from this task
Feel free to ask me to supplement any details! Thanks a lot!