Excel 2003 - mcaro through validation list

Hi,
A simple printing sheet with a validation list of 1-n values (in B2) from which all other data in the sheet is vlookup-ed from a different sheet.
I need

2 buttons (back and forward) that scroll through the validation list one record at a time

A slider bar that sits above B2 and sliding it moves through the validation list (this is to provide a quick way to find a value)

A button that will print the current page for each value in the validation list i.e. if there are 40 values in the validation drop down list, then 40 pages, one for each, will be printed).

Code needs to
a) be written in non-geek-speak i.e. proper variable names, readable, etc
b) provide error handling

Thanks in advance
LVL 5
TigerManAsked:
Who is Participating?
 
gowflowCommented:
ok I think this is what your looking for. I amanged not to use a combo and only use cell B2 that have a validation list as in G column. Check all the buttons and let me know your feedback
gowflow
Validation-bttns.xls
0
 
gowflowCommented:
before going further can u post a sample workbook ?
As your post is somewhat confusing
a validation list of 1-n values (in B2) >>> I gather that B2 has a drop down from which you can select values that are there depending on a certain validation criteria

then you say ...
2 buttons (back and forward) that scroll through the validation list one record at a time
>>> I undertand that you have say a back button and a forward button each time you click on one of them it give you the next or the previous value in the dropdown of B2

then you say ...
2 buttons (back and forward) that scroll through the validation list one record at a time
>>> I gues a faster way to see the values rather than simply pressing back back back or next next next ...

So far I have no problem with the above (if my understanding is correct)

Prblem is with hte following
A button that will print the current page for each value in the validation list i.e. if there are 40 values in the validation drop down list, then 40 pages, one for each, will be printed).
>>> For me the number of items in the dropdown is fix then it will always be what ever is there. or else then you need to clarify how the dropdown is filled and what makes it changes !

gowflow
0
 
TigerManAuthor Commented:
hi gowflow ... sorry for delay

i don't yet have a working sheet to give you ... i know what it will look like

your notes re the buttons above are correct

the print thing ... on sheet1 i will have a variable amount of records (generally between 5 and 100)
the validation list on sheet2 (where these buttons etc will be) will validate on the key field in those records in sheet1
sheet2, when an item is chosen in the dropdown, will redraft all contents using vlookups
sheet2 needs an easy way to print all the data relating to each item in the validation list - a single button

does that help?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
gowflowCommented:
To start with
pls check out this file and tell me if this is what your looking for we can add the print later if all is ok.
I used a combobox as frankly do not know how to  loop thru a validation combobox !! :(
make sure you enable macros then run it
gowflow
Validation-bttns.xls
0
 
TigerManAuthor Commented:
All good ... thanks very much.
0
 
gowflowCommented:
Your welcome my pleasure.
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.