Userform Questions

[Rahzelsmh]

Hello All, I have a few questions. any help would be greatly appreciated

1. Is there a way to mass edit all of the names of my user form objects ?. Instead of clicking each one, are they listed elsewhere altogether where they can be edited ?

2. I would like to create a summary page or review page for the user to check prior to hitting the submit button is this possible ?

Thanks !

[mehmetcik]

I would never rename your userform object names.

As you get more proficient then you will want to create complex read write routines like:

'Write Contents of 200 TextBoxes to Row 2 of current worksheet

Option Base 1
Sub macro()
Dim Myarray(200)
For count = 1 to 200
MyArray(Count) = Me.Controls("Textbox" & 1 ).value
Next
Range(Cells(2, 1), Cells(2, 200)).Value = MyArray
End Sub