Drop down text box when cell is selected - how to remove

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

Hi,
I've got a spreadsheet that I need to modify.
There are some cells that have drop down 'text' boxes associated with
them that are activated only when the cell is selected.
There is no indication on the cell that there is a 'comment' attached -
they're not inserted comments.
I've looked in the code for anything relating to 'activation' but
there's nothing there at all.

Any one got any ideas on how this type of user help box is generated?

Regards
Roger
 
The 'help' box is an input message on Data Validation. If you invoke
Data>Validation menu, select the input tab, you will see the message that is
displayed. It may be that on the first tab, it has a particular allow type,
such as a list, or Whole Number, or it may be just Any Value so that the
comment will show.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Excellent, found it and thanks

Roger


Bob said:
The 'help' box is an input message on Data Validation. If you invoke
Data>Validation menu, select the input tab, you will see the message that is
displayed. It may be that on the first tab, it has a particular allow type,
such as a list, or Whole Number, or it may be just Any Value so that the
comment will show.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Back
Top