Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to insert data into a worksheet
PHV, Yes I agree your method of referencing the cell is much cleaner and tidier. I stand corrected.- Glenzil
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How to insert data into a worksheet
Assuming you're writing a macro within a workbook and you want to write data into cell A1, you could use the following: Worksheets("YourSheetName").Activate ActiveSheet.Range("A1").Value = formName.txtBoxName You can also reference the worksheet by number eg Worksheets(1).Activate- Glenzil
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
