matataku_hoshi: (Finch "what?")
[personal profile] 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.

Date: 2010-06-30 07:20 pm (UTC)
winter: (emote - glomp)
From: [personal profile] winter
I'm thinking you might need a macro. Or a 0/1 toggle next to each option?

Date: 2010-06-30 08:10 pm (UTC)
From: [identity profile]
*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...?

Date: 2010-06-30 08:22 pm (UTC)
winter: (emote - creativity)
From: [personal profile] 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*

Date: 2010-06-30 09:28 pm (UTC)
From: [identity profile]
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


matataku_hoshi: (Default)

November 2011

131415161718 19

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 21st, 2017 03:52 pm
Powered by Dreamwidth Studios