View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Nysse Ken Nysse is offline
external usenet poster
 
Posts: 2
Default placing a pull-down menu at a cell location automatically

Hi there,

I'm wanting to click on any cell in Excel and wanting a
pull down menu to be positioned over that cell location,
when I double click on that cell.

The pull down menu has a list of values (text values), and
once I select a text value from the pull down list, that
value automatically appears in the cell, and the pull down
menu then dissapears.

How do I code this in visual basic?

Cheers KEN