Dynamic UserFrom creation

[Vaze]

Hello everyone,

I have a potential simple question but I struggle to go ahead here.
I'm trying to create a dynamic amount of UserForm which have the same design with the same functionality.
The first step - creating the user form is done as well as transferring code into e.g. "CommandButton1_Click()"

Now I want that whenever I click this button a value within this UserForm is stored in a specific sheet.

Within the CommandButton1_Click() I Make a

Call Insert(Me.Name)

The Insert Sub looks like this:

Sub Insert (Name as String)
Dim TextInsert as String

TextInsert = Name.TextBox1.Value


But this always causes a compile error "Invalid qualifier"

I guess the solution is rather simple - many thanks in advance and best regards,

[torachan]

There is no need to trigger another Sub in a simple case as this - put the code in the command button event.

Please Login or Register  to view this content.

[Vaze]

Thanks but this code is dynamically created as well as the Userform. Therefore, my idea was to not blow up the code of the dynamic Userform creation to just call those subs here