ExcelBanter - Auto advance to next field -tab key AND option button to reset fie

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

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

- - Auto advance to next field -tab key AND option button to reset fie (https://www.excelbanter.com/excel-programming/354788-auto-advance-next-field-tab-key-option-button-reset-fie.html)

~KO

Auto advance to next field -tab key AND option button to reset fie

I have created a form in Excel 2000 and protected all cells except for the
textboxes. I would like to 'tab' through the textboxes and have the focus on
the first tab upon opening.

Can I also create an option button that when clicked will clear all fields?

thanks!

All times are GMT +1. The time now is 02:33 AM.