Hi,

Use data menu, Validation

With Selection.Validation
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=
_
xlBetween, Formula1:="Greg;Bob;etc"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
Regards
JY
"strictlydata" wrote in message
...
Hi Guys



Trying to make it simple



I have a sql table with say 6 entries in

ie

Ben

Bob

Fred
Guy

Tony

Garry



I have created a connection and recordset to the sql using vb 2005



on double click I would like to create an excel validation which consists
of
these entries

so the user can only select these choices for lets say for all column A



HAs any one got any ideas on how to achieve this?