[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

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
0
TigerMan
Asked:
TigerMan
  • 4
  • 2
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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
 
TigerManAuthor Commented:
All good ... thanks very much.
0
 
gowflowCommented:
Your welcome my pleasure.
gowflow
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now