Excel form allows 32 columns, is there a workaround to have 40 columns or more?

Excel form allows 32 columns, is there a workaround to have 40 columns or more?

Build your own userform rather than use the automatic one.

BSB

May I know how can I do that?
Thanks.

You can design your own custom forms within the VB Editor (Press Alt +F11 to open this).
It will involve some knowledge of VBA so if you don't have that skill attach a sample workbook and a detailed description of what you need the form to do and we can help you from there.

BSB

Thanks BSB, honestly I have no knowledge of VBA but I will try to make this work,
will post my sample book soon.

Thanks again.
Highly appreciate.

Have a great week.