View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Batig Ray Batig is offline
external usenet poster
 
Posts: 74
Default Spreadsheet Dropdown ?

Hi,

I recently acquired a workbook from another plant. The author is gone so
that source of information is gone. Here is the question: On a column, if I
select a cell in this column, a gray button with a down pointing black
arrow (dropdown?) appears to the right of the cell. If I click the button, I
get a choice block with an R in it. Then if I click the R, an R appears in
the cell. this was done to insure that the proper letter and case was placed
in the cell so a macro would have the proper reference. I would like to
learn how to add an remove these buttons. Any ideas?

Secondly, I will continue this technique, however, it would make more sense
to provide an option button with one state adding an R to the cell and the
other leaving the cell blank. Any ideas?

Thanks in advance for helping my understanding!

Ray