IT coursework

chunky · Mar 13th, 2002, 01:13 PM

can someone pls help me how to write in a pickin list box thankx

Jack in the UK · Mar 13th, 2002, 01:22 PM

Hi

Can i ask for a little more

IE what you have and what you would like to end up with

chunky · Mar 13th, 2002, 01:26 PM

ok, i doin a project i have to do a system for a coach company. i have produced a pickin list in excel i now want to click the arrow and different things come up i.e. coach no ive done a box with an arrow i want somebody to press the box and things like 01,02,03,04,05 and then they can click which one is the correct option. thankx and i hope u understand what im sayin

chunky · Mar 13th, 2002, 01:40 PM

user form

chunky · Mar 13th, 2002, 03:46 PM

can someone help me plssssssssss

Daniel Cremin · Mar 13th, 2002, 04:14 PM

what you want a series of values that you can pick when you click into a cell or dyou want a dialog form that you can select the correct option on and paste in.

chunky · Mar 14th, 2002, 02:50 AM

yeah i want a serious of values in a box hidden and when u click the arrow u r then able to see the correct option which is relvent to u. thankx

Audiojoe · Mar 14th, 2002, 02:52 AM

So do you mean that you want a dropdown list or a userform?

Mar 14th, 2002, 03:04 AM

i have done a dropdown list but im not able to write in it, can u tell me how pls? thanks

Audiojoe · Mar 14th, 2002, 03:23 AM

Right, you need to put the list you want to use in the sheet somewhere. So try putting Monday, Tuesday, Wednesday, Thursday, Friday, Saturday in Column Z, from rows 1 - 6. Once you've done that, you go and select the cells that you want to carry the list and then click DATA > VALIDATION

Now from the little dropdown list, pick LIST. Now you should have a blank white box just underneath the list you picked LIST from. Click in it, then click back into the sheet (without clicking OK, very important!) and highlight the list you made in column Z. Once you've done this, click OK and your list should be in the cells you selected

Mar 13th, 2002, 01:22 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Can i ask for a little more IE what you have and what you would like to end up with __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 01:13 PM	#1
chunky New Member Join Date: Mar 2002 Posts: 5	can someone pls help me how to write in a pickin list box thankx

Mar 13th, 2002, 01:26 PM	#3
chunky New Member Join Date: Mar 2002 Posts: 5	ok, i doin a project i have to do a system for a coach company. i have produced a pickin list in excel i now want to click the arrow and different things come up i.e. coach no ive done a box with an arrow i want somebody to press the box and things like 01,02,03,04,05 and then they can click which one is the correct option. thankx and i hope u understand what im sayin

Mar 13th, 2002, 01:40 PM	#4
chunky New Member Join Date: Mar 2002 Posts: 5	user form

Mar 13th, 2002, 03:46 PM	#5
chunky New Member Join Date: Mar 2002 Posts: 5	can someone help me plssssssssss

Mar 13th, 2002, 04:14 PM	#6
Daniel Cremin Board Regular Join Date: Feb 2002 Posts: 64	what you want a series of values that you can pick when you click into a cell or dyou want a dialog form that you can select the correct option on and paste in.

Mar 14th, 2002, 02:50 AM	#7
chunky New Member Join Date: Mar 2002 Posts: 5	yeah i want a serious of values in a box hidden and when u click the arrow u r then able to see the correct option which is relvent to u. thankx

Mar 14th, 2002, 02:52 AM	#8
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	So do you mean that you want a dropdown list or a userform?

Mar 14th, 2002, 03:04 AM	#9
Guest Posts: n/a	i have done a dropdown list but im not able to write in it, can u tell me how pls? thanks

Mar 14th, 2002, 03:23 AM	#10
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Right, you need to put the list you want to use in the sheet somewhere. So try putting Monday, Tuesday, Wednesday, Thursday, Friday, Saturday in Column Z, from rows 1 - 6. Once you've done that, you go and select the cells that you want to carry the list and then click DATA > VALIDATION Now from the little dropdown list, pick LIST. Now you should have a blank white box just underneath the list you picked LIST from. Click in it, then click back into the sheet (without clicking OK, very important!) and highlight the list you made in column Z. Once you've done this, click OK and your list should be in the cells you selected