<div>
Thanks for your code techfanatic<br />
This code does not work as I've got several worksheets in my workbook.<br />
I tried adding this code to the Worksheet_Activate event but I get an error ..
</div>


Thanks for your code techfanatic
This code does not work as I've got several worksheets in my workbook.
I tried adding this code to the Worksheet_Activate event but I get an error ..

<div>
That code can be called once. Did you want to control &quot;tabbing&quot; on a specific range?
</div>


That code can be called once. Did you want to control "tabbing" on a specific range?

<div>
yes, the range is called &quot;Orders&quot;<br />
and I'd use the same &quot;tabbing&quot; on another range called &quot;Customers&quot; with another userform/macro
</div>


yes, the range is called "Orders"
and I'd use the same "tabbing" on another range called "Customers" with another userform/macro

<div>
<div class="content wysiwyg-content">
Hello<br />
<br />
I have a listobject called &quot;Orders&quot;. As all my entries to the datatable are added by userforms, I want to prevent the user from manually adding data at the end of the table by pressing TAB. I'd like to display a userform called frmOrders instead.<br />
<br />
What code should I write?<br />
<br />
Thanks for your help<br />
<br />
Massimo
</div>
</div>


Hello

I have a listobject called "Orders". As all my entries to the datatable are added by userforms, I want to prevent the user from manually adding data at the end of the table by pressing TAB. I'd like to display a userform called frmOrders instead.

What code should I write?

Thanks for your help

Massimo

Listobjects: How to show a userform when user clicks on Tab

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