EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I create a spead sheet with different word lists that I can pick from? For instance I have one column with colors to be listed and instead of making a pull down list, I would like to be able to select from a table or library of many colors. I would pick a color and then the name of the color would appear in my column. That way I could just pick from a table or library without have allot of pull downs all over my speadsheet. I would like to have different info in each column and each with its own table or library to pick from. Is that possible on Excel or do I need to use another program?
 
Hi
with VBA you could do this. One way would be using the selection_change
event of using the right-mouse click to pick a value from a list.
Though this could get complicated. If you like provide some more
details:
- in which column do you want the colors to be stored
- how do you want this column to be created
- how is the target cell for this picked color identified (note:
drag'drop is probably not possible / haven't check this)

I can set-up some example code four you.
 
What is VBA? I really do not know what column I want to store the colors, since I have so much info to input I came to halt when I was making the spreadsheet. I had about 12 pull down menus with several more to go. I know there had to be a different way so I posted on this forum for some help. I am just going through the help menu to see what else I might be able to do. I am looking into the selection_change event like you mentioned, and I am going from there. I guess the way I want the columns made is to have the ability to input different info into each cell, by picking from some where else wether its a table or somthing else. I need to be able to put different info from different list's into each cell. I am making a chart for bids and inventory. I get several types of metals and sizes that need to be input but sometimes it is either or depending on the project so each cell would need to be able to accept a type of metal or color and size. Or maybe three different columns with the info stored in another place that I can pick from like one for metals and then for sizes and so on. Any help would be excellent, thanks
 
Hi
not so sure how your spreadsheet is designed. If you like, email me a
sample copy of your workbook and maybe I can give you some hints
 
Back
Top