Consulting

Results 1 to 2 of 2

Thread: Combo Box / List box help

  1. #1

    Combo Box / List box help

    So I am trying to create a drop down menu in my spread sheet that doesn't require a rowsource. I need the drop down menu to be able to supply the user with a few options A B C D ect.... when they select one of the options I would like my script for the selection to place a value in a specific cell. So, "A" would return 1 "B" would return 2 and so on. Can anyone help me with this?
    Thanks
    Ben

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Just use Data Validation list.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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