Results 1 to 4 of 4

Thread: inCellDropdown

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Unanswered: inCellDropdown

    Hi!

    I just started trying to teach myself Visual Basic and already I have encountered my first problem. I have the following script for a data validation dropdown:

    With Range("b9:d9").Validation
    .Add xlValidateList, xlValidAlertStop, xlBetween, "=AK3:AK6"
    .InCellDropdown = True
    End With

    Now I want to fill the dropdown with values from cells on another sheet. My guess was that I could simply change the second line into

    .Add xlValidateList, xlValidAlertStop, xlBetween, "=Sheet1!AK3:AK6"

    but this doesn't work. I have tried numerous other formats as well, but without success. Any help would be much appreciated!

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    I don't think cell validation can be done with referance to cell in different sheets, but in you can then someone out there will know!

    MTB

  3. #3
    Join Date
    Jul 2004
    Posts
    3

    hope it helps

    If you go to the help in excel and type in: enter in data in a cell from a list you specify. That will explain what you need to know. It will change with the cells that you have selected. So you don't have to worry if the data in the list is being changed.

  4. #4
    Join Date
    Jul 2004
    Posts
    2
    Thanks! That's pretty much what I was looking for.

Posting Permissions

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