Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking to present an Excel questionnaire I have written to the board, via either paper or presentation slides. It uses a lot of drop-down boxes, and so I'm looking for any ideas on how one might go about showing the options for each response (from the drop-down boxes), without having to manually print screen a bunch of times and pasting the results into Visio.

Has anyone come across a nie easy, fast method of doing this?

share|improve this question
How were you planning on giving the presentation? Planning on presenting within excel or are you trying to generate images you can import into powerpoint or visio? – DaveParillo Oct 19 '09 at 23:21

I don't think you can do this with Data validation drop downs. Any chance of converting the dropdowns to ActiveX Controls?

Even the following code snippet fails:

Sub Foo()
    Range("C4").Select    'Assuming this is the cell containing the dropdown list
    Application.SendKeys "%{DOWN}", 1
    Range("C4:C10").CopyPicture Appearance:=xlScreen, Format:=xlPicture
    ActiveSheet.Paste Destination:=Worksheets("Sheet1").Range("D16")
End Foo

It does cause the dropdown to appear, but the 'CopyPicture' methods copies the underlying cells, not the displayed dropdown.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.