Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

advanced list management

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Advanced List Management

Advanced List Management

ResolvedVersion 2003

Habil has attended:
Excel Advanced course
Excel Advanced course

Advanced List Management

How do you create drop downs from a list of drop downs already created?

RE: Advanced List Management

Hi Habil

This is an interesting question, i have spoke to one of the other trainers and they informed me that it cant be done on the spreadsheet, however it can be done use VB code into a form, if you need anymore info on this please reply to this message

Hope this helps

Mark East
mark@stl-training.co.uk

MOUS Master Instructor

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.