I need suggestions. I have a multipage userform. On the last page of the
form, there are several textboxes (more than 25). The contents of these
textboxes are page numbers for a presentation. What is the best way to
prevent duplicates from being entered?

I thought at first that I could cycle through all of the controls on the
page, then check to see if the control was a textbox, then compare that
value to the current textbox value. A few problems are apparent with that
thought - first, control.value is not available in VBA. Second, I would
have to write code for each textbox afterupdate event.

I need help figuring something out. Any ideas out there?