(no subject)

[matataku_hoshi]

So I'm using Excel.  I want to have an option where the user can click on the box, and then check off multiple options.  (Just having a pull-down menu only allows you to choose one option)

Any ideas, oh wise friends list???  This is way over my head.

Comments

[winter]

I'm thinking you might need a macro. Or a 0/1 toggle next to each option?

[muffin-song.livejournal.com]

*cries* The fact that I have become "the one who knows about comptuers" around my office really is tragic, because I really don't T_________T (Or rather, my knowledge of Excel is functional but quite limited)

Maybe I'll try Googling these terms...?

[winter]

*pats* I can't help you with writing Visual Basic (I call up out VB whiz when I need one!), but for 0/1 toggles - just have a list of options and a drop-down menu next to each one to choose 1 or 0 (or Yes or No) from, with the default being 0/No.

*does this for a living* *or tries to*

[educatedmonkey.livejournal.com]

So I played with excel for 10 minutes without any luck. From the internet it looks like you are trying to make something called a multi select listbox, which seems to require visual basic, as bwinter has pointed out.

How many selections could one person need to make? Can you get away with offering 3 or 4 drop down lists with the same options and having people pick the ones that are relevant and stop when they are done. It's less pretty, but maybe workable.

good luck