98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training courses london - Names and drop down menus
microsoft excel training courses london - Names and drop down menus
Resolved · Low Priority · Version Standard
Vicki has attended:
Excel Advanced course
Names and drop down menus
I have created a list and named it. I have set up the link on the sheet to create a drop down menu to select an item from the list. Is it possible having chosen the link to have that linked to another list which would automatically (once chosen) open another drop down to select from?
Or failing that it is possible to set the worksheet to respond to the mouse running over the words creating a linking list next to it - like when looking for a software package from start, you would then choose all programs, then as you run up the list other drop down menus appear to the side - is this possible in a worksheet?
RE: Names and drop down menus
This is possible to some extent. With VBA knoweldge and expereince you could customise your solution to fit your requirements. In the abscense of that, you would need to combine data validation and the INDIRECT function.
Do some research on "Conditional Data Validation" using google. That will give you enough background to build the solution that will fit for you. The first entry is pretty good.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Separate the year from a dateTo separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1) |