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

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

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

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