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
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
ASKER
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?
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?
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
All good ... thanks very much.
Your welcome my pleasure.
gowflow
gowflow
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