ActiveSheet. TextBoxes (2). The Caption=Sheets (" data "). The Cells (j, 3)
ActiveSheet. TextBoxes (3). The Caption=Sheets (" data "). The Cells (j, 4)
Such statements, I want to know what the TextBoxes corresponding to Excel in the table object, number how to look, I know is it? A text box in the write data, but there are a lot of TextBoxes, how on this number, if I want to add new add TextBoxes??????? Urgent, can explain, thank you!
CodePudding user response:
You can see in the excel spreadsheet interface, you can be in in if excel2003 point right-click on the toolbar, showing "controls and toolbox," above there is a vb controls, you pull a text box on the table, right in the above point selected attributes to know its name, like textbox1,CodePudding user response:
Use the ActiveX controls in the EXCEL spreadsheet, which the value of the TEXTBOX and then form the value of the corresponding to the specific unit