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

Spreadsheet Dropdown ?
 

Hi
could be 'Data - Validation - List'. See:
http://www.contextures.com/xlDataVal01.html

--
Regards
Frank Kabel
Frankfurt, Germany


Ray Batig wrote:
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

Spreadsheet Dropdown ?
 

Ray,

It appears that the affected cell(s) are subject to data validation.
It is controlled through the data...validation menu.
There is a lot in the online help concerning this feature. HAve a loo
at it and post back any queries you still have

--
Message posted from http://www.ExcelForum.com

Spreadsheet Dropdown ?
 

Thanks to you both. I have learned something new!


Ray Batig wrote in message
nk.net...
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