CODEWITHSUNDEEP
excelforms
bdubb
bdubb

Reputation: 61

Retrieving Data back into a form in excel vba

I am pretty new to VBA in Excel. I have built a form which users enter data and at the press of a button it drops all that data into an excel spreadsheet and clears the form. What i need now is code for the user to push a button (off a list or combo box that shows already entered data) and have that data be brought back into the form for changes. I am trying to keep them out of the spreadsheet. Thanks

Upvotes: 1

Views: 1400

Answers (1)

wooha
wooha

Reputation: 11

I think must be like this:

Private Sub Textbox1_Change()
Worksheets("worksheetname").Activate
TextBox1 = Cells(1,1).Text
End Sub

In "Cells()" you have to selecet the specific cell which contains the value. But if you want to use excel as a kind of a database you should think about if it's the right tool, maybe access would be better.

Upvotes: 1

Related Questions