Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Roger - 11 Jul 2006 06:34 GMT
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
Ardus Petus - 11 Jul 2006 06:59 GMT
Look at Data>Validation
Thre must be a list attached

HTH
--
AP

> Hi,
> I've got a spreadsheet that I need to modify.
[quoted text clipped - 9 lines]
> Regards
> Roger
Bob Phillips - 11 Jul 2006 08:36 GMT
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.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi,
> I've got a spreadsheet that I need to modify.
[quoted text clipped - 9 lines]
> Regards
> Roger
Roger - 11 Jul 2006 20:33 GMT
Excellent, found it and thanks

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
[quoted text clipped - 22 lines]
> > Regards
> > Roger

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.