Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: IT coursework

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    user form

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can someone help me plssssssssss

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    64
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  8. #8
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


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

  9. #9
    Guest

    Default

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

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •