UserForm1 to Open UserForm2 & close itself but transferring txtbox entry from Form1 to 2

Hi There...

I have UserForm1 where the employee must enter his details in "Textbox_Employee" and then select a certain machine in "Textbox_MachineAlocation". Based on the selection from the "Textbox_MachineAlocation" entry from UserForm1, it must then open the required UserForm for the specific machine (Such as userforms called MachineCalibration1, MachineCalibration2 or MachineCalibration3 etc.) and must also close UserForm1. It must also transfer the entry from (UserForm1 - "Textbox_Employee" & "Textbox_MachineAlocation") to the Userform that will be opening.

The code below is opening a certain UserForm but it must however be selected from the TextBox entry.

Please Login or Register  to view this content.

I have tried this code but could not get it to work.

Please Login or Register  to view this content.

Any idea how to do above?

Also how do I get UserForm1 to close? Below code only hides it.

Please Login or Register  to view this content.

Here I have tried the following but it does not work.

Please Login or Register  to view this content.

Anyone knows how to achieve this?

Hi Colin,

To close UserForm1 that was opened with the 'UserForm1.Show' command

Please Login or Register  to view this content.

The following code from the attached workbook should help you get started associating variable names with UserForms:

Please Login or Register  to view this content.

Lewis

Originally Posted by LJMetzger

Hi Colin,

To close UserForm1 that was opened with the 'UserForm1.Show' command

Please Login or Register  to view this content.

The following code from the attached workbook should help you get started associating variable names with UserForms:

Please Login or Register  to view this content.

Lewis

Thank you for the reply and the sample file. It works!

Originally Posted by mikerickson

LJMetzenger's Userforms.Add method won't work on Macs.

In any case, I'd suggest a combo box rather than a text box to avoid misspelling errors.

If you put code like this in the main user form, it should work.

Please Login or Register  to view this content.

Thank you for your reply and post as well as the sample. I have decided to go with this option because some of the names are a bit tricky. It was my idea from the start to use a combobox due to the possibility of a mistype. I must admit that with a sample it is much easier to see where I went wrong. Again thank you both of you for taking the time to compile a sample as well. I appreciate it! I will now mark this thread as solved!

Originally Posted by mikerickson

LJMetzenger's Userforms.Add method won't work on Macs.

In any case, I'd suggest a combo box rather than a text box to avoid misspelling errors.

If you put code like this in the main user form, it should work.

Please Login or Register  to view this content.

Above code I got to work 100%. I have however identified a problem on my part. The machines to be calibrated are dependant on the specific calibration form. The problem is that some of them have a complex name. The only way to have the user form opening is by renaming it to this machine name and herewith the problem. Some of them are called..."Work Area 7, Mixer Number:3 (Reclaimed Sand)" A user form cannot be renamed to this type of name. Is it [possible to have each of the selections in the combobox1 referring to a certain user form name?

I have tried below code with no success.

Please Login or Register  to view this content.

Do you know how to do this?

Hi Colin,

Thanks for the rep points.

The simplest way would probably to have simple names for the UserForms. The captions on the UserForms can be changed to display whatever text you like. See the attached working file, which uses Mike's code as a baseline, since your previous post used Mike's code.

Please Login or Register  to view this content.

Lewis

Originally Posted by LJMetzger

Hi Colin,

Thanks for the rep points.

The simplest way would probably to have simple names for the UserForms. The captions on the UserForms can be changed to display whatever text you like. See the attached working file, which uses Mike's code as a baseline, since your previous post used Mike's code.

Please Login or Register  to view this content.

Lewis

Thanks a Lot!! Code works exactly as I need it to work. I would have never thought to have changed it in that way. Reason why I went for Mike's form was due to it also being used on Mac. Thank you again for all your work and sample file. I appreciate it!

Thank you to both of you for all the help. I am now able to select the required user form as required. One last thing I am trying to achieve (With no results thus far) is to have the combox1.Value to display in the second user form that opens. I have 19 different machines that uses 5 different user forms. In other words the same user form can be utilized for example on 5 different machines. The calibration completed will however be on that selected machine. So I would like the selection from combobox1 on the first user form to display on the TextBox1 on the second User Form that opens.

I have tried to copy to a cell on a sheet but that value only updates once the second user form is closed. Is there a way for the value to transfer to the second user from that opens when the first one closes?