Fill textbox in each active UserForm

[Laik2013]

Dears,

I have a problem with my VBA code.

I have over 20 Userform which have one textbox with the same name txtsejobcode1.

Additional I have a UserForm in which user can search for a needed job code.

I wanted that after a user will choose a job code the job code will be added in to the active userform with the textbox named txtsejobcode1.

I could build this:

Please Login or Register  to view this content.

But in the line with Combobox I'm getting a error 438

Run Time error 438
Object doesn't support this property or method.

Please help

PS. Sorry for my english

[Norie]

Isn't K the userform object?

If it is you should be using it in the loop when trying to refer to the textbox.

PS Why do you have all these userforms open at the same time?

Also, are the userforms identical?

[Laik2013]

Hi,
k = textbox - txtsejobcode1
No, my program run like this:

User opens one from 20 userforms which have textbox "txtsejobcode1". In this form he has a button which runs the userfrom in which he can search for a job code.
After he choose the job code the value should be copied in to the active userform in to the textbox "txtsejobcode1".

[Norie]

Why the loop then?

[Laik2013]

Because I have 20 userforms with the textbox txtsejobcode1 but only one userform to search for a job code which can be run in each of the 20 userforms thru a button

Thats why I want that the choosen job code will be copied in to the active userform.

[Norie]

Sorry, I'm confused.

Why do you have 20 userforms?

Are they all the same?

[Laik2013]

Hi,

I have created a program to create contracts.

In my program I have created over 20 userform which are filled with fields, comboboxes which need to be provided by the user to create a contract for some employee.

Each userform represents different contract.

Each userform has one the same field textbox txtsejobcode1 which is needed in all contracts.

In each of the Userform I have a button which is initializing a user form which has a search engine to search for a job code.
I want that choosen job code will be added in to the textbox in the active userform from which the button to search for a job code was clicked.

[Norie]

Can't you have the code to search for the job code in the individual userforms?

Or perhaps in a separate sub that each userform can call.

[Laik2013]

Separate sub

Please Login or Register  to view this content.