Home General Chat
If you need urgent support, call 999 or go to your nearest A&E. To contact our Crisis Messenger (open 24/7) text THEMIX to 85258.
Read the community guidelines before posting ✨
Aged 16-25? Share your experience of using the discussion boards and receive a £25 voucher! Take part via text-chat, video or phone. Click here to find out more and to take part.
Options

Excel

Dr PirateDr Pirate Posts: 8,303 Legendary Poster
I need to link a cell to a drop-down combo box for my coursework.

I've tried the MS knowledge base, no luck and that paperclip needs to die aswell. I only have a few days left on my coursework :(

Help!

Comments

  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    In the cell type "=ComboBoxName"

    Will that work? Im sure someone will help out.
  • Options
    Dr PirateDr Pirate Posts: 8,303 Legendary Poster
    The combo box doesnt have a name lol.
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Describe what it is exactly that your are trying to do, or even send me the file and i'll look at it for you. [mjs59leac@gmail.com]

    Chances are you are using a combo box from the Control Toolbox and not forms. Either way, let me know more and i'm sure i'll be able to help.
  • Options
    Former MemberFormer Member Posts: 1,876,323 The Mix Honorary Guru
    Can't remember what the function is. grr.

    Lookup "Restrict cell entries to the data from a list" in the help file, it tells you how to do it.
  • Options
    Dr PirateDr Pirate Posts: 8,303 Legendary Poster
    Thank you moo-man, that helped me greatly

    Narrator: and the Moo-man saved the day... Again
Sign In or Register to comment.