I wish to use CUSTOM buttons for my excel worksheet as below:


[< ] [TEXT ALTERING AS PER LEFT RIGHT CLICK] [>]

LeftCellButtonImage ButtonLinkedText RightCellButtonImage



by passing a variant array:

Dim arr As Variant
arr = Array("Txt1","Txt2","Txt3","Txt4","Txt5","Txt6","T xt7","Txt8","Txt9","Txt10","Txt11","Txt12")

It should work like:
InitialText = [Txt1]

FirstLeftClick LeftCellButtonImage arr(11) FirstRightClick LeftCellButtonImage arr(1)
SecondLeftClick LeftCellButtonImage arr(10) SecondRightClick LeftCellButtonImage arr(2)
ThirdLeftClick LeftCellButtonImage arr(9) ThirdRightClick LeftCellButtonImage arr(3)
FourthLeftClick LeftCellButtonImage arr(8) FourthRightClick LeftCellButtonImage arr(4)
-------------------------------------------------------------------------------------
TwelfthLeftClick LeftCellButtonImage arr(1) FirstRightClick LeftCellButtonImage arr(1)
-------------------------------------------------------------------------------------

In a circular manner.