Display Data From A Database

Hi all,
My question is, how i can display different values using the Selection.FormulaArray, ok look at my code:

Dim mySheet As Worksheet
    
'    On Error GoTo errors
    Dim x As Integer
    x = TextBox1.Text
    Dim y As Integer
    y = RefEdit2.value
    
    Set mySheet = Excel.ActiveSheet
    mySheet.Range(RefEdit1).Select
       
    Selection.FormulaArray = "=multiplie_value(""" & x & """, """ & y & """)"
    MsgBox Selection.FormulaArray

Now the function i call:

Public Function multiplie_value(valor As Integer, multiplo As Integer) As Integer
    multiplie_value = Val(valor) * multiplo
End Function

thats an example. so the real question is i create a form, the user enter some values to search to a database, the user select an area(a range) where they want the data to be display, but i dont how to display that info that is coming from the database in the range that the user selected. The info displayed in the range should look like a tabular report, column headers, etc.

Thanks in advance.

Andrés.

Peace to all my bros!!!!

Hi i need to desing a form so the user enter some values to search to a database, the user select an area(a range) where they want the data to be display, but i dont how to display that info that is coming from the database in the range that the user selected. The info displayed in the range should look like a tabular report, column headers, etc

Thanks,
Andrés. :cool: