[EXCEL] Multi-tabbed userform

[Matty B]

Hey there. I posted previously but I had nothing to show as a model for what I was looking for. At the time I didnt know if Word or Excel would be the proper program to use but I know have a userform with a bit of code that a friend helped me ith but as we go on I think Word may be better than Excel as Im using now.

If you look at the attached Work book and userform youl see tabbed pages with many different options for parts of a car. To use the form fby pressing the big blue square, youll need to add a fake invoice number then the tabs ill ungray. The goal of the program is for my business to create a customized instruction manual based on accessories in a customers car. They fill out a sheet with all electrical components in their car and we input it into a program which makes a manual for those parts.

Right now I am attempting to use Excel to do this. What is being designed is that each customer is assigned a unique ID based on invoice number. Multiple sheets are used to allow easy additions to the userform as new parts become available. The Id is used against each sheet with true or false cells for all the components. If a component is true then it is supposed to go to a master table of all the instructions for all the parts possible and adds in whats necessary to a seperate sheet. More or less the userform is being designed to pick certain lines from one workbook or sheet and based on the choices made in the userform, sends them to another sheet.

My friend that has tried to help is way to busy with family and work to help me on even a monthly basis so I am turning to the forums for help.

Before I ask for help on specific questions I have with what Im doing, Im wondering if there is a way in Word to do the same thing. I figure that for other than the customer infor page, Word would work better and faster than Excel.

Ive wondered if there is a way in Word to use a form like this in Word that just adds the different instruction steps. Being a Word processor, its easy for a person like me to do the data entry.

Now if Excel is easier to use on to my question....

Would anyone be able to help me with the code to pick a line from one sheet and add it to a new sheet? I do not have any instructions in the workbook but for instructional purposes, using A1:A4, B1:B4, ect would suffice. Im looking for an example that I can work off of to make the whole thing.

My friend is a programmer and IT guy but has admitted to not being as proficient in VBA as Java or the like (I guess those languages are more relevant now?). Im a mechanic that has a rudemetary knowledge from college about VBA that I learned ten years ago so I know a bit but Im more or less retarded when it comes to advanced coding.

Hope you guys can help, thanks

[TerryTee]

I'd certainly stay with Excel for this. Think of Excel as a database for this purpose. Each sheet is a table dedicated for a type of material. Each column hold a specific type of information, and each row represents a specific item.

A good way to get started is to use the macro recorder. I'm sure you can find a lot of info on it if you search a bit. Basically it lets you record the actions you do, and then it creates the VBA code for you. The created code must then be generalized before you use it in your modules, but it is a great way to learn. You can find the macro recorder with the other macro menu items in excel.

The generated code will generally use Select a lot, and this is amongst the things you want to get rid of. Example:
The recorder may give you this code:

Sheets("Invoice Info").Select
Range("A3").Select
Selection.Copy
Sheets("Customer Info").Select
Range("A3").Select
ActiveSheet.Paste

but you can cut it down to:

Sheets("Customer Info").Cells(3, 1) = Sheets("Invoice Info").Cells(3, 1)

Good luck on the project.

-Terry