Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .