Excel help

[SoreArms]

Is there a way to make menu/option buttons inside a cell, like have several options with a button that you can click? It doesn't have to do anything, it just needs to be there.

for example

Do you like me:
o Yes
o No

and you can click on the circle and it would turn black and stuff

is this possible in excel?

 

[Scotsman]

Not exactly but you can set up a perameter so that if someone writes yes or no it can register it then you can use it as a data accumulation grid.

Cheers,
Scotsman

 

[SoreArms]

I'm creating a data base in excel and there are several options that I need to add, if I give each one it's own column it will run off too much. If I could some how just put them all in one cell, it would be perfect!

 

[Moderate_THIS]

what about combo boxes

 

[SoreArms]

what about combo boxes

what ams those?

 

[Scotsman]

You can set a box to log most responses so you don't have to set up a bunch of columns plus write an equation to register each box. So you could have a bunch of yes no questions and given the number of each response it will give you a resultant. Like answer enough yesses and it tells you that sorearms is gay enough no's and the monocle is gay. See what I am getting at?

Cheers,
Scotsman

 

[SoreArms]

It's a database for software bugs/changes/enhancements. I need to add all the different options/configurations available so that I can document which area the bugs/changes/enhancements directly affects. Each item can have several options or non at all. If I make a separate column for each option (to be answared in yes or no format) it will be too wide. This database will grow pretty large, it will never get smaller because data will not be deleted, only it's status will change (Open, Fixed, etc...) so I need these options to show up in every row.

Any ides on how this can be accomplished?

 

[SoreArms]

bizzump duzzump

 

[SoreArms]

 

[jnuts]

It's called a radio box

 

[SoreArms]

It's called a radio box

you can do it in excel? how?

 

[jnuts]

http://www.mrexcel.com/archive/Controls/6791.html

 

[SoreArms]

http://www.mrexcel.com/archive/Controls/6791.html

sweet! Thanks bud

 

[SoreArms]

Thanks Jnuts, that helped me do exactly what I wanted to.

Now, how do I make it copy the contents of the first cell, to all the cells in that same column. I just want to be able to put the radio boxes (I actually used check boxes) on every cell in the same row.

 

[SoreArms]

OK, I jsut copied the first cell down 1000 rows, I hope thats enough. I jsut hope that any one that prints any of this is smart enough to hit print preview and check how many pages down the data actually goes and only print 8 of 500000 pages

 

[Devastation]

lol

















huh?