Excel animation using table values loop

Question

Hello all,

I have a three columns table and three TextBox objects in another sheet

the name of the TextBox objects is the same as one of the columns (TextBox Name)

I am trying to create VBA code to iterate through the table and change the rectangle objects color according to the color name and insert the text from the "TextBox Text" column in the text box

With the code running, is it possible to capture the changes into an animation MOV or similar video file?

Thanks for any help or insight

TextBox Name	TextBox Color	TextBox Text
Station_A01	Black	Model_A
Station_A01	Red	Model_A
Station_A01	Green	Model_A
Station_A01	Blue	Model_A
Station_A01	Blue	Model_A
Station_A01	Blue	Model_A
Station_A01	Red	Model_A
Station_A01	Red	Model_A
Station_A01	Red	Model_A
Station_A01	Green	Model_A
Station_A01	Green	Model_A
Station_A01	Green	Model_B
Station_A01	Green	Model_B
Station_A01	Green	Model_B
Station_A01	Green	Model_B
Station_A01	Blue	Model_B
Station_A01	Blue	Model_B
Station_A01	Blue	Model_B
Station_A01	Blue	Model_B
Station_A01	Blue	Model_B
Station_A01	Grey	Model_B
Station_A01	Grey	Model_B
Station_A01	Grey	Model_B
Station_A01	Grey	Model_B
Station_A02	Green	Model_C
Station_A02	Grey	Model_C
Station_A02	Grey	Model_C
Station_A02	Grey	Model_C
Station_A02	Grey	Model_C
Station_A02	Grey	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Red	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A02	Yellow	Model_C
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Blue	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_D
Station_A03	Black	Model_E
Station_A03	Black	Model_E
Station_A03	Black	Model_E
Station_A03	Red	Model_E
Station_A03	Red	Model_E
Station_A03	Red	Model_E
Station_A03	Red	Model_E
Station_A03	Red	Model_E
Station_A03	Red	Model_E

Answer 1

Hello Andreas,

thanks, for the reply. the sample data is shown in the body of the message.

I did try using Copilot after I posted this and got the solution from it so this issue is now closed

thank you very much

K

Answer 2

We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.