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!

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

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.

Thanks! That's pretty much what I was looking for.