Alright...We are trying to figure a way out to have an excel worksheet that when you click on a cell and type in a part number (BKIC_PROD_CODE), then the next column could generate the Description. How do we do this? I have been able to create a MS Query with a parameter value on PROD CODE to let you specify the part number and then pull the related description also.
It would be cool to just fill out a table with part numbers then refresh and have the descriptions populate. Anyone have any ideas?

Option Explicit
'--------------------------------------------------------
'--------------------------------------------------------
Public Const odbc_dba As String = "EVO"
Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public cmd As New ADODB.Command
'-------------------------------------------------------
 
 
Public Function sku_desc(the_sku As String) As String
Dim var_sql As String
conn.CursorLocation = adUseClient
conn.Open "provider=MSDASQL;dsn=" & odbc_dba
 
var_sql = "SELECT BKIC_PROD_DESC FROM BKICMSTR WHERE BKIC_PROD_CODE = '" & the_sku & "'"
rs.Open var_sql, conn, adOpenStatic
sku_desc = Trim(rs("BKIC_PROD_DESC"))
 
rs.Close
conn.Close
End Function
 
Public Sub test_my_function()
Sheets("Sheet1").Range("A1").Value = sku_desc("MY SKU ID")
End Sub
 
 
 
Kelloggs