AngloPremierTranslations
New Member
- Joined
- Sep 28, 2017
- Messages
- 4
I have a macro that makes several text boxes flash, one after the
other. It's to show new users of my template where to find the
clickable text boxes.
I can select one of the boxes using this line:
It works fine, but I then want to make another box flash that is initially off the bottom of the screen, and when I select it, the screen stays in the same position. Is there a way to make a text box visible (i.e. on the screen, rather
than below the screen), i.e., in the same way that if I select cell A300 that cell will become visible on the screen, I want my second text box to become visible.
As a workaround, I could move down to the row where the box appears, but I'd rather not, otherwise I have to update the macro if I add or remove rows before it.
other. It's to show new users of my template where to find the
clickable text boxes.
I can select one of the boxes using this line:
Code:
ActiveSheet.Shapes("Text Box M303T1Fichero").Select
It works fine, but I then want to make another box flash that is initially off the bottom of the screen, and when I select it, the screen stays in the same position. Is there a way to make a text box visible (i.e. on the screen, rather
than below the screen), i.e., in the same way that if I select cell A300 that cell will become visible on the screen, I want my second text box to become visible.
As a workaround, I could move down to the row where the box appears, but I'd rather not, otherwise I have to update the macro if I add or remove rows before it.