Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Validataion listbox
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Validataion listbox
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Validataion listbox
Enter the list anywhere in the same sheet (at IU1). Select the cell where you
want the validated list. Go to Data, Validation. Under Allow select list which will prompt you to select the list and now you can select the list of names entered in IU1 "strictlydata" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Validataion listbox
Thank you both for your replies
The problem is the data changes so I don't want the validation to be static I would like the data to be read from sql everytime the validation is used. Thanks -- 1 "sacrame" wrote: Enter the list anywhere in the same sheet (at IU1). Select the cell where you want the validated list. Go to Data, Validation. Under Allow select list which will prompt you to select the list and now you can select the list of names entered in IU1 "strictlydata" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can the source in data validataion be located in another sheet? | Excel Discussion (Misc queries) | |||
Resize Validataion Message Help! | Excel Discussion (Misc queries) | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming |