ExcelBanter - Using excel built-in form, through VBA, script to initialize it

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using excel built-in form, through VBA, script to initialize it (https://www.excelbanter.com/excel-programming/392715-using-excel-built-form-through-vba-script-initialize.html)

Alfredo

Using excel built-in form, through VBA, script to initialize it

I have pop-up an excel built-in form for data entry using VBA. However, the
form pop-up with the 1st row data. Needed:
1) How to click new button to clear contents for new data entry--a VBA script
2) How to disable all other options on that form, except new?

All times are GMT +1. The time now is 05:04 PM.