<div>
Please attach your workbook.
</div>


<div>
As Martin says attach an example workbook
</div>


As Martin says attach an example workbook

<div>
Thanks rspahitz, this was exactly the part that I was missing
</div>


Thanks rspahitz, this was exactly the part that I was missing

<div>
<div class="content wysiwyg-content">
Hello everybody,<br />
<br />
I would like fill a table using an Userform. For each month a row should be generated. The textboxes: ID, Name and Lieferant should be filled into each row. &nbsp;3 rows should be generated always (one for each month) even if there is no entry in the Textbox for that month.<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2015/11_w47/1018821/UserForm.png" target="_blank" title="Example (21 KB)"><img alt="Example" class="file-block lazyload" style="max-width: 759px;" data-src="https://filedb.experts-exchange.com/incoming/2015/11_w47/1018821/UserForm.png" /></a><br />
Unfortunately I am not able to solve this problem by myself. Perhaps one of you experts can help me.<br />
<br />
Thank you very much
</div>
</div>


UserForm.png

Hello everybody,

I would like fill a table using an Userform. For each month a row should be generated. The textboxes: ID, Name and Lieferant should be filled into each row.  3 rows should be generated always (one for each month) even if there is no entry in the Textbox for that month.



Unfortunately I am not able to solve this problem by myself. Perhaps one of you experts can help me.

Thank you very much

Userform: Fill multiple rows with one text box

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

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.