Hi All,

I am considering preparing a survey using a simple worksheet approach for internal use (rather than design a complicated Userform for this mini project).

As such, I would like some entries to be manually typed by the User in a Textbox (based on general consensus by people using the survey).

As such, I understand that for each textbox, I could validate the input entry (e.g. ensuring a value between 0-1 and formatted as a percentage) using a Keypress Event as described in this site.

However if there are going to be many Questions and if the Textboxes are named logically e.g. Question1_Part1, Question1_Part2, Question2_Part1 etc, its may be easier to use Class modules.

As such, I found this very helpful example by Ozgrid member Reafidy to control textboxes on a Userform.

I have attached Reafidy's example but added in a second worksheet with the labelled textboxes and relaevant validation required.

Could anyone please show how to control the textboxes on the worksheet using the Class module approach?

Any help appreciated.