I am new to VBA, I am trying to use text boxes to input data into and retrieve data from an Access Database. I am not having any success. Here is the coding I have so far. Try not to laugh :\ Private Sub cmdEnter_Click() Dim txtFig As Integer Dim txtItem As Integer Dim txtPart As String Dim txtGrove As String Dim txtUnitPrice As Integer Workbooks("Sheet2").Activate Cells(2, "E").Value = txtFig Cells(4, "E").Value = txtItem Cells(6, "E").Value = txtPart Cells(8, "E").Value = txtGrove Cells(10, "E").Value = txtUnitPrice End Sub From here I have become lost, probally because I am trying to teach myself. Any help or hints would be greatly appreciated. Reguards, Marty

I also have figured out how to import external data ( the access database I created ) though I do not know how to add new entries into the database itself, or display the data I import by using search parameters I am trying to define in the text boxes. Being txtItem, txtPart, txtFig and so forth. Reguards, Marty

You have to open an instance of Access from Excel VBA and then open the database to make your changes. You should get a book on VBA if you don't have one already. John Walkenbach and John Green both have excellent ones widely available.