VBA to cycle through cells

[max8719]

Hi I have 2 buttons one for cycle left and one for right. i would like to be able to cycle the selection forward and backward.

I15, AN15, BP15, CU15, DY15, FD15, GH15, HM15, IR15, JV15, LA15, ME15.

Thanks in advance.

 

[James006]

Hi,

Surprisingly .. you have not posted your current macros ...which allow you to cycle left and right ...

You could create a Named Range ...

 

[max8719]

Hi apologies but I haven't created a macro yet, I just have two objects i would like to use as buttons

 

[My Aswer Is This]

Are you saying if you enter a value in Range("I15") then you want the active cell to then be Range("AN15")
and so on.

 

[James006]

Hi,

Do not know your constraints ... but given your explanations ... you should be using a SpinButton ...

By the way is there a coherent Column count in between all your cells in Row 15 ...?

 

[max8719]

I just want the active cell selection go through the cells stated, each these are merged cells ie I15 to AM15 is a merged cell "January" and so on.