Excel Userforms for Beginners (9/10) - Use Excel VBA to Create A Userform and Manage a Database

Подписаться 94 тыс.

Просмотров 38 тыс.

50% 1

Excel Userforms for Beginners - Use Excel VBA to Create A Userform and Manage a Database
Link to download files:
tinyurl.com/yy...
Link to playlist for Excel Userforms series:
tinyurl.com/l5...
Video 1 - Introduction To Excel Userforms
• Excel Userforms for Be...
Video 2 - Create an Excel Userform, Add a ‘Control’
• Excel Userforms for Be...
Video 3 - Build up an Excel Userform, Add Labels, TextBoxes, ComboBoxes
• Excel Userforms for Be...
Video 4 - Maximise User-Friendliness of an Excel Userform
• Excel Userforms for Be...
Video 5 - Link the Excel Userform to the Spreadsheet Using Excel VBA
• Excel Userforms for Be...
Video 6 - Position data precisely in the database using Excel VBA
• Excel Userforms for Be...
Video 7 - Control and Helpful User Interaction in Excel Userforms
• Excel Userforms for Be...
Video 8 - Use an Excel Userform to Edit Existing Data
• Excel Userforms for Be...
Video 9 - Load Data from a Database into an Excel Userform
• Excel Userforms for Be...
Video 10 - Creating a Sense of Mode - ‘Add New’ and ‘Edit Existing’
• Excel Userforms for Be...
Note: Chris did do some ‘tidying up’ of the code after shooting, to improve the quality of the completed file. This involved improving the in-code annotations and the structure of the code. No new coding ideas were introduced, however, and the mechanisms all work in the same way. Don’t feel that you should copy every detail of Chris’ approach, however; you now have the tools to design and implement your own powerful Excel userform-based applications. Good luck!
🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know
tinyurl.com/yc...
Get in touch with Tiger using the platforms below!
For regular spreadsheet hints and tips and more on the #ExcelRevolution:
/ tigerspreadsheetsolutions
/ tigspreadsheets
tigerspreadshee...

Опубликовано:

28 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 52

@maurocastagnera8949 6 лет назад

I really have to say that you are an awesome teacher! Clear, simple, step by step from the simplest concepts to the more complex ones and with all that is needed in everyday work. Thank you very much!

@TigerSpreadsheetSolutions 6 лет назад

Many thanks Mauro! Always appreciate supportive comments.

@ANTheWhizkid 2 года назад

I can only agree with the others... Your videos are really well structured, you explain the objective, give moments to think before you give the solution, you sum up, and so on. bravo!!! :)

@TigerSpreadsheetSolutions 2 года назад

Thank you very much my friend

@davecks3042 5 лет назад

Like the way you teach . Very practical with you doing little trial and error sometimes

@TigerSpreadsheetSolutions 5 лет назад

This approach has worked for me over the years - I'm glad you like it

@johnvanstultj 6 лет назад

Hello, very helpfull video tutorials. Could you please add a button to remove an entry so you have 'add', 'edit' and 'remove'. And so that the rows will move up after a selected entry is removed? this would realy complete the userform for me. Thank you.

@TigerSpreadsheetSolutions 6 лет назад

Hi John That sounds like a good idea for a follow-up video, I have put it on my list of video ideas, thanks :-)

@jpattanaik1983 2 года назад

my edit button, doesn't retrieve data in one go. I have to close the Data_UF once and have to again select the same value in Find_Entry_UF to update the values . kindly help

@TrucNguyen-ze9gq 4 года назад

Thank you so much for your series VBA, could you tell me how I can create ref column (number 1,2,3...250, 251) automatically when I add 1 new record from user form into excel ?

@TigerSpreadsheetSolutions 4 года назад

Hi there - you're welcome! I think I did this using a formula in this spreadsheet. However, you could do it using VBA by counting the number of current entries, adding one, and then inputting that figure to the spreadsheet. Good luck!

@melanieray6259 6 лет назад

Thank You Very Much! You are very clear and do a wonderful job at explaining everything.

@mattyulenaers474 Год назад

Dear Chris, you are a great teacher. I followed your series of lessons from 'Excel Userforms for Beginners'. I get stuck at my own Database after the last point of lesson 9. You have used one group with option buttons. If I use one group of option buttons everything works perfectly. But I used 4 groups with option buttons and then the VBA code doesn't work anymore. Is this easy to solve?

@TigerSpreadsheetSolutions Год назад

Hi Matty - thanks very much. Check the group setting on the option buttons in the VBA editor. I believe this where you control the group behaviour.

@mattyulenaers474 Год назад

@@TigerSpreadsheetSolutions Thank you for responding so quickly to my post. The group settings for the Option Buttons are correct. Each group has its own name. The code also works perfectly if I put only one of the groups in the code alone. From the moment a second group is added to the code, things go wrong. I hope you don't mind, but I've sent you more documentation on this on linkedin. I hope you can help me.

@mattyulenaers474 Год назад

@@TigerSpreadsheetSolutions Dear Chris, Forget all my previous posts. I started all over again and now it works. I don't know what I did wrong... But obviously something somewhere. Thank you for the good videos you make. That way I learn a lot. Kind Regards Matty

@TigerSpreadsheetSolutions Год назад

@@mattyulenaers474 Good job, Matty!

@mattyulenaers474 Год назад

@@TigerSpreadsheetSolutions Dear Chris, Here I am again. I did everything you explained in your lessons and it works perfectly. Except one thing. The combo box. When we want to edit a contact. Then it is always empty and must be clicked again. Otherwise it will be empty in the database. Then I thought, get rid of the combobox I use radio buttons. So that I can enter one of these and the correct info is in the database. But your explanation is about two radio buttons. How does it work if you work with multiple radio buttons?

@kirbytheswordmaster 7 лет назад

Hi Chris! Thank you for the great explanation. I was wondering, how would you write the code for reversing the userform (as in minute 13) in the case of a ListBox with multiple options available to select that then appear separated by commas? Thank you! :D

@TigerSpreadsheetSolutions 7 лет назад

Thanks Alejandro - I have never had to work with a Listbox in that way, so I cannot help you immediately. As always, Google will give you some ideas. Keep up the good work!

@MaulikAcharya87 6 лет назад

hello i have to ask if there any trick to auto full symbols..like i type 25 * symbols..nd it will auto full 25 * symbols in specific cell

@TigerSpreadsheetSolutions 6 лет назад

Hi Maulik If you mean writing 25 * into 25 cells then autofill should help. If you're on a windows systems, use the CTRL + D shortcut. If you mean writing 25 * into a single cell, using VBA and a loop might help. Good luck!

@abhinav0686 3 года назад

I need to edit my data in the table via input user form but via edit userform but with a unique combination of Date and Name (Date and name combination are unique in my data), I am facing a lot of problem with date. My date is not auto filling according the pre-existing dates in the form. Any guidance with that? It would really make my life easy. Thank you. P.S. i am less that a newb to coding. Loving your content btw.

@faungarbleathercrafts8387 2 года назад

This is a really great tutorial. More helpful than any other userform tutorials on RU-vid. Thanks for making it simple and sensible.

@TigerSpreadsheetSolutions 2 года назад

It's a pleasure and welcome to the channel - do check out our other videos ...

@ShawnTheSheep407 5 лет назад

thank you very much! Using your video, I have created collated tracker containing 4 different trackers and 6 interactive userforms :) This was very easy to understand.

@TigerSpreadsheetSolutions 5 лет назад

Great to hear Avil! Keep it up.

@pbthao 6 лет назад

Thank you for your lecture, it's really helpful for me who haven't touched VBA for a long time. I have a question: Can we use this method for many users at the same time? I mean can 3 people add data to the data base at the same time?

@TigerSpreadsheetSolutions 6 лет назад

Hi Thao This kind of 'collaborative working' is, to my knowledge, currently a weakness of Excel. It depends on how the systems at your organisation are set up - I would contact the IT department and ask. Good luck!

@vigneshwarank529 6 лет назад

Dear sir greetings Your video lists are awesome. I am trying to build this kind of userform. In that I want to know how to set specific data type for all text boxes and combo boxes Example: - for date as date, numbers as numbers and text as texts etc., Awaiting for your response. Do the needful Thanks in advance

@mictralif7515 5 лет назад

great tutorial video! learned a lot. but i have questions though. how do you check columns for similar dates. or list down the names with similar birthdate?

@TigerSpreadsheetSolutions 5 лет назад

Hi there, thank you. I would recommend looking at advanced filtering options ... Google 'Excel advanced filter', or similar. Good luck!

@mictralif7515 5 лет назад

@@TigerSpreadsheetSolutions thank you! was able to find a solution.

@TigerSpreadsheetSolutions 5 лет назад

Good stuff!

@samehsayed162 4 года назад

Thanks for the Great Video again , But I have a problem that I have the below code , and It only returns some of the Values not all of them Dim TargetRow As Double TargetRow = Application.WorksheetFunction.Match(Edit_Box, Worksheets("October 2019").Range("A6:A1000"), 0) MsgBox TargetRow Unload UserForm2

@TigerSpreadsheetSolutions 4 года назад

It could be a number of things. Check that numbers are not stored as text. Good luck!

@ASI15236 5 лет назад

Chris, I am learning lot about user forms with your videos. Encountered a big problem. My user form has input of two numbers which require calculation. Let's say average. I added a dim statement declaring them as "double", but in the bar code they will not allow calculation. Do they default as a "string"? When placing on the data sheet they appear as zeros. If I do not add the dim statement there is an exclamation and hovering says number added as text. Thanks for the solution.

@TigerSpreadsheetSolutions 5 лет назад

Daniel - good to hear you're getting value out of the videos. Use the VBA command =val() to convert string values to numerical values. x = val(x) is the basic construct. You could try something like: cell reference = val(userform object) Good luck, Chris

@ricomalibiran3977 5 лет назад

What if the search is not found what code can we use, instead of error pop up??thanks and more power

@TigerSpreadsheetSolutions 5 лет назад

Rico - I would recommend checking to see if the entry is in the data before trying to do anything with the entry. You could use the countif formula, for example, to check if the entry is present. If entry is not present then notify user and exit the routine. If the combo uses the database as its data source, you should not encounter this problem, however.

@sadaksharanchandrasekaran1210 6 лет назад

What if I had to enter a date in a text box and i want that date to be the same date on which i am entering my details. This varies for every record that is being entered and I want the date on which I am entering my details to appear on the text box.I would also like to know how to place a date picker option in a text box using VBA. Please do help me with these. Thank you.!!

@TigerSpreadsheetSolutions 6 лет назад

Hi there - thanks for the comment. I am not sure about the date picker. I have created date mechanisms in my work using boxes for day, month and year, however - these have worked well. You can use =now() in VBA to input the date and time, or just the date / time components you require. A quick internet search will give you more information. Good luck!

@sadaksharanchandrasekaran1210 6 лет назад

Thanks Chris, for your time!! I have tried it and it worked, but it changes when i try to edit the record . Are there any ways so that i could keep it constant ?

@TigerSpreadsheetSolutions 6 лет назад

Copy the range and paste the values, then adjust the format to time / date. Record the code using the macro recorder then tweak and integrate into your routine. Good luck!

@markyaney318 6 лет назад

I have created a simple database for employee training records and would like to apply conditional formatting base on training expiration. Could you do a short video on adding conditional formatting for date ranges? Also, the videos you have put out are fantastic. I have learned a great deal watching and following along. Keep up the great work and thanks a million.

@markyaney318 6 лет назад

Hopefully the conditional formatting will be using VBA