Consulting

Results 1 to 2 of 2

Thread: LISTDATA MISSING FROM COMBOBOX PROPERTIES

  1. #1
    VBAX Regular
    Joined
    Nov 2018
    Location
    London, U.K.
    Posts
    99
    Location

    LISTDATA MISSING FROM COMBOBOX PROPERTIES

    I am trying to add lists to a 4 column combobox in auserform.
    I wanted to use the combobox properties to do this, but theListdata field is missing, so I guess I have to use code to do it. However ………..
    Every example of the code to use to do this isdifferent!! I am so confused, I have noidea how to do this at all.
    My listdata is in worksheet Validation Range B2:E88 (NamedRange CustData)

    Any help or pointing to an article website or anything wouldbe appreciated!


  2. #2
    VBAX Master Aflatoon's Avatar
    Joined
    Sep 2009
    Location
    UK
    Posts
    1,720
    Location
    At design time you would set the Rowsource property to the address/name of the range. In VBA you can do the same or pass the value of the range to the List property (there is no Listdata property for either method).
    Be as you wish to seem

Posting Permissions

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