Can I use one user form for multiple outputs?

I have multiple machines that can have multiple tool sets. Each one must be tested at intervals.

I am trying to build a user form to easily input this information to reduce confusion and improve user accuracy/ease of use.

Problem is, I'm getting mixed signals from what I'm building.

So, here are the questions:

1) Can I have a command button open a user form to select the "tool" being tested?
2) Can I then use just one user form and direct it to multiple outputs?

I'm trying to do this, but I'm just not getting anywhere, and I'm confused, frustrated, and overwhelmed.

Please help me with a starting point. I can build from there.

Thanks,
TR

Machine 1 has tool a,b,etc

The info needed for each test is: Lot, Shift, Date, Pocket, test result.

So, I have a spreadsheet with all of the machines listed, with each tool listed separately. The spreadsheet currently ends at column DP.

I am currently using input boxes. A command button on the first page opens the input sheet and finds the machine and tool.

The layout is like this:

example of machines.xlsx

Sorry to take so long to reply. I am not at my desk today.

Has anyone had a chance to look at this? I can't seem to find anything quite like it in all of my searching.

I am so far above my knowledge level here it isn't funny. I tried to get the input form to show the machine, then the tool, but it isn't changing the tool. After the second selection, I need to go to the input location and put in the values for the test. I'm not even sure what the first step is.

example of machines.xlsm

This is updated with the correction and form filled a bit.

This will need to be changed, as the machines may change. Don't know if they will add or subtract, but the one constant is change.

That would be great if you could get me a similar form! Thanks!

Can you create an individual userform for each tool, then create a userform with tickboxes with the name of each of the tools.

Then just enter the code (example has 3 tools)

Please Login or Register  to view this content.

The tool subs need to be entered into a module, create one for each tool that needs testing

Please Login or Register  to view this content.

Repeat as needed

That makes sense. I'll have to tryit out.

Thanks!

On Friday, I took another class in an Excel tutorial I'm taking from Ed2Go.com, and the instructor presented us with exactly what I wanted for this problem. I was able to make it work for this, and I now have the ultimate in flexibility and ease of programming:

example of machines.xlsm

Now I need to figure out a way to call a subroutine by saying something like this:

Please Login or Register  to view this content.

I searched, and found the following:

http://www.excelforum.com/excel-prog...parameter.html

Is that a way of doing this, or am I looking in the wrong direction?

The machine is selected, then the tool is selected. The two numbers that are generated are what I would like to use as variables.

I'm sure that I can get those two numbers into two variables, I'm just not totally sure how.

When I have the variables, I want to put them into the "Call" statement. However, I don't understand how to put the variable into a "call" statement. I'm looking, but it's not an easy question to ask, and I'm not finding it quick.....

Yes, sorry.

Originally Posted by TRLWNC

Okay, I got it to work.



Attachment 365693

This version works like I want it to.

Well, I'm sorry you won't be able to help, but I'm glad I was able to solve your problem!

How does this relate to this question?

http://www.mrexcel.com/forum/excel-q...lications.html

Oh, wow, has this been a headache. Trying to do something with a system that refuses modification really, really stinks.

So, I ditched the ideas I had before and went with a different system. It works, amazingly enough, so I will begin the process of using this system to build my full scale spreadsheet.

Here is my project as is. I'm sure there is a LOT to do to get it looking better. But, I need to build what I will use....

example of machines Level 3.xlsm

I am going crazy here. I have built my user form, and everything works great. But, it won't return to the first page by using the:

Please Login or Register  to view this content.

code.

What am I doing wrong? It worked fine in the example! I am pulling my hair out here!

I figured it out. A bit of gigo on my part. But, this coding thing is a headache! Welcome to puzzles upon puzzles.

I actually had a licensed programmer ask me what that meant recently.....

Originally Posted by TRLWNC

On Friday, I took another class in an Excel tutorial I'm taking from Ed2Go.com, and the instructor presented us with exactly what I wanted for this problem. I was able to make it work for this, and I now have the ultimate in flexibility and ease of programming:

Attachment 366385

Please Login or Register  to view this content.

I keep coming back to this because it just doesn't make any sense. I have put in the following code with an activeX command button on the "Input Finder" page:

Please Login or Register  to view this content.

But when I exit design mode, I get this error:

Can't exit Design Mode because Control 'New Test' cannot be created.

What is going on? I have the system working just fine on the other one, but this one is just weird. Does anyone have a clue why this error would come up?

I want to know so that if this ever comes up on another workbook I can understand why it is happening and prevent further problems.

Thanks.

Thanks, I'll double check that I got all of them. I thought I had tried this already.....

I went live with my spreadsheet this month, and found something that I needed to iron out. The text is small, and so incorrect items were being selected. I have found out how to fix this using ActiveX text boxes that I was able to alter the text size of.

The problem was, I didn't know how to link the boxes or to initiate the code. So, I looked around and found that the boxes could be linked this way:

I made the ListFillRange (or RowSource in a user form) for the first box the "Machines" list, and the second one linked by this code:

Please Login or Register  to view this content.

And the input process could be activated with this code:

Please Login or Register  to view this content.

This is a nice addition, as I am able to have larger type. Now I just need to code it all in.....

Hope this helps someone!

Originally Posted by gmr4evr1

No problem, just trying to get myself clear. My thought was a user form that the user either inputs data into a field, such as the date, work order #, etc., and/or selects certain data, like the machine and tool #'s. The form would automatically open when they opened the workbook that this information is going to be saved in. Once they enter all the information, they click a button (submit?) and the information would be transferred to the required spreadsheet. Once they finish, they click another button (close and save?) and it would close the user form and save the workbook. Is this anything like what you were looking for?

In the end, this is exactly what I built. It's pretty involved, but it does a wonderful job. Another plus is that everyone who uses it thinks it's great! Yeah! Win-Win!

Try this video out. It works for me!

https://www.youtube.com/watch?v=f8s-...3akx_gFMnpxTN5

I have gotten my system to a very complete operation. Since I have many on this forum to thank for helping me get to this point, I want to share what I have with you. See attached:
example of machines Level 4.xlsm

I have an interesting question for this. I am taking a programming class, and we have gotten into arrays. I am intrigued with the idea of using an array and a loop to eliminate all of the repeated code for my test inputs.

But how do I do that? Any suggestions?