[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

drop down box

I have alot of cells on some of my sheets that I would like the user to be able to type common things in easily and to type new thing in as well. But rather than chosing the words can it be like predictive text. eg I would have a list of the most common works and if they type say S then the work Sick would come up. Common words are:

SICK
RDO
OFF
HOLIDAY

Or do you have any other suggestions? this has to happen about 10 - 20 times on a single sheet.

Cheers
Rob.
0
RobJanine
Asked:
RobJanine
  • 2
1 Solution
 
reitzenCommented:
If the common words are going to be in the same column, you can pre-fill several rows above the input range and hide these rows.  Excel has a built in predictive text option when you begin typing in a cell.

So, as an example you can enter the pre-filled list (SICK,RDO,OFF,HOLIDAY) starting in A1.  Do this for each column you'd like to pre-fill.  Hide these rows from the user.

Now when the user types the letter "S", all they have to do is press ENTER.

They will have to enter more than one letter if there are words that begin the same letter(s).  For example, you would have to enter "SIC" if you had SICK and SINGLE in your pre-filled list.

Also, as the user enters other unique values in the column, these will also become available in the predictive text.
0
 
RobJanineAuthor Commented:
Ok, only thing is I dont have any free cells above, can it be linked to a single cell for predictive text?
0
 
reitzenCommented:
No, each item has to be in it's own cell.

If you cannot insert rows above your input range, the only other way is to write a class that would watch inside of your input range and search the current column based on each keystroke and present a word or list of words.  Unfortunately, I'm not even really sure if this can be done.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now