<div>
Just to be clear are you referring to data in the cells or in textboxes embeded on the sheet?
</div>


Just to be clear are you referring to data in the cells or in textboxes embeded on the sheet?

<div>
from workbook a.xlsm I am copying data from a combination of &nbsp;textboxes and cells on sheet1 to the next empty row of cells in workbook.b.xlsm
</div>


from workbook a.xlsm I am copying data from a combination of  textboxes and cells on sheet1 to the next empty row of cells in workbook.b.xlsm

<div>
Thank You so much for your help!
</div>


<div>
<div class="content wysiwyg-content">
I have a spreadsheet named a.xlsm which has several text boxes with data in it. I would like to copy the contents of the textboxes to another workbook named b.xlsm. So my steps are:<br />
<br />
1) Copy data in textboxes from a.xlsm<br />
2) open b.xlsm<br />
3) find the next empty row in b.xlsm<br />
4) copy data in textboxes from &nbsp;a.xlsm to the next row in b.xlsm<br />
<br />
I can't figure this out. Any help would be appreciated!
</div>
</div>


I have a spreadsheet named a.xlsm which has several text boxes with data in it. I would like to copy the contents of the textboxes to another workbook named b.xlsm. So my steps are:

1) Copy data in textboxes from a.xlsm
2) open b.xlsm
3) find the next empty row in b.xlsm
4) copy data in textboxes from  a.xlsm to the next row in b.xlsm

I can't figure this out. Any help would be appreciated!

Copying values in a textbox from one excel workbook to a different workbook with VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.