Create an Excel Database in Minutes - Magic Userform Code - Part 3

Create an Excel Database in Minutes - Magic Userform Code Part 3.Previously we had a look at a bit of awesome and flexible code that when combined with a userform control naming method outlined, produced a database populated from a Userform in minutes.In this tutorial I will demonstrate how to modify this for a multiple lined userform. I will be taking the magic userform code from the first project and showing how we can use it in multiple lines within a Userform. The Userform that we will be constructing has six rows of controls each row containing six controls. It does not matter what type of control you will be using as long as it can contain data.

[kwik]

Trev,
I have been studying many Excel/Access tutorials for months now, learning as I go. I have to say, your tutorials rate at the top. They're pleasant, informative and spot on. I for one have learned quite alot from you tutorials. PLEASE. Keep up the fantastic work buddy.

[nudger]

Trevor, Thank you for your wonderful work, long story short I have created a packing list creator data input using the code you have shown in these tutorials. what i would like to know is if it could be used to change label captions on the userform but then also input the value of the label caption into the packing list above the actual data by way of clicking on an option button? I have various size ranges that can be selected via the option buttons.

[salva]

Hi Trevor,
I was looking for a method to load a DB with several rows as in your tutorial and it works  perfect,   but now i need some method to edit the entered data. I review some of your tutorials (By the way, these are excellent and easy to build) but most of them do the edit part considering just one row.
The point in here is that when I could do the extraction, I could perform some calculations based in the data contained in the columns for one specific matrix.
The matrix that I am entering is a 6rows x 7columns and these share one unique number that I put in the last column (ie: Arec7, Brec7….Frec7) to identify that those data belongs to one person only.
Please could you suggest some method, or tutorial to follow, to do it?.
The way you explain how to do it is excellent, I could say that I learned more in a few weeks just by following your tutorials than other methods.
Best regards

[oldbutbetterthanyou]

Hi Trevor. Set nextrow = Ark1.Cells(Rows.Count, 3).End(x1Up).Offset(1, 0) gives me an runtime error 1004 - application defined or object defined

[mammarwan]

Hi Trevor
Summary wonderful work, you can use the controls to generate new rows when needed without predetermination immediately with his number for rows ?

[felisbertopaquete]

hi Trevor,
how to get back the information from the sheet
to an add multiple value userform?
I Love yours works...

[rashidimam]

hi,
i want to ask one thing regarding userform. i have created userform on my excel file, its working properly. i can add data easily. but after closing my excel file where i have entered my data and created the userform, when re-opening the same file for more data update, the userform is missing and showing some error, and not able to add more data with the help of that user form, i am very sure that i am not saving the file properly,
So, Plz will you help me that how can i save that file correctly? and can update my data in future with same userform which i created..

[ashrafallam]

Great and helpful work! I have three questions
1-Can we change the code such that it can edit the data if it exists?
2- Can I use this for a students workbook that has 20 worksheets each is for a different class in a school?3- Would you please tell us the name of the great program that you use to record these videos.
Thanks for your patience.

[D_Business_Analytics]

Runtime error 1004 "Application defined or object defined error while running Addme Routine

[jeovanyhercules]

Hi Trevor, I'm having a problem with the " Set nextrow = Sheet1.Cells(Rows.Count, 3) .End(x1Up). Offset(1, 0)" command I get a Run-time error '1004' what could be the problem?

[bondniko]

It takes a really smart person to do things in a simple way. While complicated stuff can be done by stupid ones.

[eyeofthetiger]

very good tutorial, but I miss the most important buttons like Delete, Search next and Previous  ?

[Real-ZiX]

Ur Speaking style is so advance! I m nt that much of level.
Can't understand, sorry for skipping this video!