How do I get infomation from a cell in an Excel sheet on a form to a textbox on that same form? IE: Text1(0).Text = Sheet1("A1"). This obviously doesn't work but it gives you the jist of it.
Printable View
How do I get infomation from a cell in an Excel sheet on a form to a textbox on that same form? IE: Text1(0).Text = Sheet1("A1"). This obviously doesn't work but it gives you the jist of it.
you need to specify the object that holds the excel sheet, either an object variable or oleobject