Hello Friends,
I will be having two user form buttons one for UP and other one for DOWN
A list will be containing names of months starting from January, February till December in Range ("AA5:AA16")
If current value of cell L3 is March and UP is pressed then it should show April i.e. moving one cell down in that range & vice versa if DOWN is pressed
If current value of cell L3 is December i.e. the last cell in the range and UP is pressed then it should show January i.e. moving one cell forward which is coming back at the top of the list & vice versa if DOWN is pressed
If cell L3 is blank and UP is pressed then it should show January i.e. first cell in that range
If cell L3 is blank and DOWN is pressed then it should show December i.e. last cell in that range
Regards,
Humayun
I will be having two user form buttons one for UP and other one for DOWN
A list will be containing names of months starting from January, February till December in Range ("AA5:AA16")
If current value of cell L3 is March and UP is pressed then it should show April i.e. moving one cell down in that range & vice versa if DOWN is pressed
If current value of cell L3 is December i.e. the last cell in the range and UP is pressed then it should show January i.e. moving one cell forward which is coming back at the top of the list & vice versa if DOWN is pressed
If cell L3 is blank and UP is pressed then it should show January i.e. first cell in that range
If cell L3 is blank and DOWN is pressed then it should show December i.e. last cell in that range
Regards,
Humayun