Lists

yankybel

New Member
Joined
Sep 16, 2002
Messages
2
I am trying to create a "comment" type box (within Excel 2000) that when the cursor moves over the cell, the box appears with a list of 65 items in a verticle row. The user would then click on one of the items in the list and that item would then automatically be inserted into the cell and the list box would disappear. Is this possible? Also, is it possible to have a scroll feature on the list? (65 items will take the list off of the viewable screen.)
Thanks for your assistance.

rick
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

BigC

Well-known Member
Joined
Aug 4, 2002
Messages
851
Rick
Your problem sounds like a perfect application of the Data Validation functionality of Excel.

Ina separate range, enter all the acceptable values for your list, and name the range.

Select the cells into which you want the user/s to enter the data, click Data Validation => dialogue box appears.
On Settings tab , select "List" from the "Allow" dropdown box
Click in the Source field, press F3, and select your range name created above.
Fill in the information required on the Input Message & Error Alert tabs (mostly self-explanatory, but check Help for more info)
Click Ok

Then, when a cell in the input range is selected, a drop-down arrow appears in the right of the cell which allows the user to select from the list. And depending on the settings you select in Data Validation, may also prevent the user from entering any values other than on that master list.

This function is very useful for ensuring consistency of input, and/or restricting values to certain ranges, etc.
Check out Help under data validation.

HTH
BigC
 

Forum statistics

Threads
1,143,739
Messages
5,720,585
Members
422,292
Latest member
Bernd0501

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top