Improve company productivity with a Business Account.Sign Up

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

Create multiple multi-select drop downs in Excel

Hello,
I am trying to set up a drop-down box in multiple columns in an Excel worksheet. I have used this link to create this for one column and it works great.  

http://blog.contextures.com/archives/2011/04/29/how-to-set-up-multiple-selection-excel-drop-down/

I would like to use it for more than one column in the same worksheet. Is this possible? I am not a coder, but I tried modifying it to make it work for multiple columns and could find no syntax that worked. Is this possible and if so, how do I modify the code? Thanks!
0
janicet123
Asked:
janicet123
1 Solution
 
Rainer JeschorCommented:
Hi,

yes this should be possible. Without having your workbook I must code blind.

Assuming that you want to use this in your worksheet on columns
A - D - E and G (4 columns) then the related part of the code should look like
If Target.Column = 1 OR Target.Column = 4 OR Target.Column=5 OR Target.Column = 7 Then 

Open in new window


which is
Column A -> Target.Column = 1
Column D -> Target.Column = 4
Column E -> Target.Column = 5
Column G -> Target.Column = 7

HTH
Rainer
0
 
gowflowCommented:
Did the reply suggested helped you in any way or you need more help ? If yes then can you please post the workbook that you worked on on 1 column so we can take it from there ?
gowflow
0
 
janicet123Author Commented:
This was perfect! Thank you so much - just what I needed!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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