i will post my purchase order on the community templates soon, and will post
back here, it is easier to understand with a working copy of something,
rather than bits and pieces of things.

thanx,

jat


"Bob Phillips" wrote:


"jatman" wrote in message
...
doesn't work... as for the referencing a list from another sheet, Excel
can
do that.

But only if that list is a defined name!

TAB2, highlight the column A, in the cell next to the formula bar, enter
"test" as the descriptor. enter various data in column A.
in TAB1, select a cell, select DATA Valadation, and the validation
criteria
is allow list, and for the source enter "=test", and you can reference the
data in column A, on TAB2...

next option...

can it be written into ThisWorkbook

Sub Macro1()
'
' Macro1 Macro
'
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=
_
xlBetween, Formula1:="=LOOKHERE"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End Sub


where LOOKHERE tells what to look for, something like this

lookhere = vlookup(d5,Suppliers!,A:B,2,false)

if i change the selection in D5, the cell that should make the list would
look up somewhere else.

cannot really give a better example...

suggestions?


No idea what you are trying to do now, had little to start with, less now.