force a selection from a list of words

R

Rick S.

I have a list of prefered words for specific type work sheets, is there a way
to force a user to select from that list and only that list?
In my workbooks, each sheet will have a column (F) that will use up to 29
rows maximum. When ever a user selects a cell in that column I want to force
them to select from a list of specific words to fill the cell.
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007
 
R

Rick S.

This works great! ;)
Can the font size be chaned?
--
Regards

VBA.Noob.Confused
XP Pro
Office 2007
 
R

Rick S.

It would be nice if we could edit our replies/posts.

Can the font size be changed? (not chaned)

--
Regards

VBA.Noob.Confused
XP Pro
Office 2007
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a "moving" range offset from Target 31
Action from list selection 2
List words starting with a specific letter 3
Force Recalc 3
Change the structure of words? 4
Data validation drop down list selection change 4
Combobox list validation 1
Excel Excel: How do I put a formula in a drop down list 11

Top