PDA

View Full Version : Next and Prev. command



atuljadhavne
05-28-2012, 02:23 AM
Dear expert

i have format, where in D3 having (data validation list) list, and the list is in same sheet AJ4 to AJ63,
now when i select from D3 of any one data, than based on D3 value the i am getting code for that (used vlookup from another sheet) in E3

Now i want command like Next and Prev Button, so when i click on Next button the the value automatic change and pick next value, and if i press prev button than take prev value

e.g
this is sample data validation list
now when i select from drop down popup menu "Aditya" from D3, so E3 (vlookup from another sheet) has been change and based on E3 the entire format figure get changed, now when i press next button the D3 value has been changed to "Agro", next "Anmol", Prev "Agro"

ADITYA
AGRO
ANMOL
BADRINARAYAN
BHUMI
CASH
CHANDOK

any help in this regards

tnx in advance

Bob Phillips
05-28-2012, 03:25 AM
Cross-posted and answered at MrExcel http://www.mrexcel.com/forum/showthread.php?t=638070

atuljadhavne
05-28-2012, 03:27 AM
but how to use this code
please explain