📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
@valenification1
6 жыл бұрын
Could hug you right now if I could :) In an amazing tut you have answered a gazillion of questions which were bugging me. It's awesome to have a project commonly needed by perhaps millions of people, explained fluently, coherently, in an easy to follow language and step by step manner. This is the kind of course i would enrol in. Thank you very much for your tutorial.
@ExcelForFreelancers
6 жыл бұрын
WOW! Thanks so much for your great comment. I am so happy to help you learn and grow. Excel is like a blank canvas and we can great our own art right on it, and provide solutions to common problems in the world. (at least that is the way I see it) I will have some comprehensive courses coming out soon so stay tuned. If you have not done so yet, please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
@salmankhan-ew7mg
5 жыл бұрын
sorry sir this mathod is not working If Target.Count > 1 Then Exit Sub If Not Intersect(Target, Range("D13:J9999")) Is Nothing And Range("D" & TargetRow).Value Empty Then Range("B2").Value = Target.Row 'Cont_Load
@ExcelForFreelancers
5 жыл бұрын
HI make sure you have an End If at the end. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@DVSgolddust
5 жыл бұрын
Because you dont have data in Cell B2
@wayneedmondson1065
6 жыл бұрын
So Randy.. this video is excellent.. and I much prefer walking through the building process with you step by step vs. only interrogating an already built solution. While it may take longer to create and or view the video, I think the learning is elevated by seeing and experiencing the construction live.. including mistakes.. which we all make. I find that I can pause and replay the passages that need emphasis. All in all, the take away is much more valuable and engaging than just being an audience to an explanation of an existing end product. I highly encourage more of this type of tutorial. Also, I'd like to salute you for being so generous and sharing your unbelievable and impressive EXCEL skills. Getting an insight into your techniques and creative solutions is invaluable. Thank you and Thumbs up!
@ExcelForFreelancers
6 жыл бұрын
Thanks so much Wayne. My first few videos were like this, then I kinda got away from it to try to create more complex applications. But based on the high views of this video, I really must return to this style of teaching, in some instances, since I believe it is easier to learn. It's a fine balance between people who think "yeah i know these steps already" to those who are thinking "oh wait, how did he get to that step?" I plan to release some comprehensive courses in the near future that get deep into the training and feature of large applications such as Reports Dashboards, Accounting, Scheduling, etc. Thanks so much for your extremely valuable feedback.
@wayneedmondson1065
6 жыл бұрын
Hi Randy.. thanks and understood. I use the KZitem playback speed to go faster or slower through sections that I feel I know more or less well. Even for something where I think I know the steps, I find that I learn something anyway by watching how a third party approaches it. I get that some might be impatient about that.. can't satisfy everyone. I look forward to your courses. If offered for a fee, I hope you host them on something like Udemy. I've taken a few paid courses there and like the interface and overall environment. If offered for free, well.. even better for all of us consumers out here. EXCEL is like a gold mine.. the deeper you dig, the more value you get. Thanks again for your generosity with the free tutorials.. much appreciated and I'll definitely consider your paid courses in the future, if that is how they are offered. Thumbs up!
@krn14242
6 жыл бұрын
@Wayne, I agree totally, couldn't have said it better myself. The learning is seeing it come together step by step. It is much easier to follow along then trying to check after completion all the code and how it all interacts.
@ExcelForFreelancers
6 жыл бұрын
Hi Wayne, thanks so much for your response. That helps me determine how to approach new training so I can better serve people. The courses will be comprehensive 15 - to 20 hours and I will host them on my own website (www.ExcelForFreelancers.com ), however it will be very similar to the Udemy format. I will make sure to set them at a very fair price, and to include a ton of value. Thanks again for your valuable feedback :)
@ExcelForFreelancers
6 жыл бұрын
@krn14242 Thanks very much for your insights. its great feedback to get so I can create more engaging lessons in the future. Much Appreciated!
@ianlevitt6920
6 жыл бұрын
Great tutorial Randy, it makes it so much clearer actually seeing it built step by step. Keep up the good work.
@ExcelForFreelancers
6 жыл бұрын
Thanks Ian I really appreciate the feedback. I realize I must do more of the Build From Scratch in future videos. This one was not so complex so it was a bit easier, but the more complex ones would probably be separated over multiple weeks. Many people seem to agree with you, so your feedback is super helpful. Thanks so much.
@odiniramos9169
3 жыл бұрын
I am getting compile error: variable not defined for CONTCOL = 5 to 20 Sub CONT_LOAD() With Sheet1 If Range("B4").Value = Empty Then Exit Sub .Range("B6").Value = True 'SET CONTACT LOAD TO TRUE CONTROW = .Range("B4").Value 'CONTACT ROW For CONTCOL = 5 To 20 .Range(.Cells(25, CONTCOL).Value).Value = .Cells(CONTROW, CONTCOL).Value Next CONTCOL .Range("B5").Value = False .Shapes("EXISTREQ'TGRP").Visible = msoCTrue .Shapes("NEWREQ'TGRP").VISBLE = msoFalse .Range("B6").Value = True 'SET CONTACT LOAD TO TRUE End With End Sub
@ExcelForFreelancers
3 жыл бұрын
Hi and thank you will want to make sure you define your variable CONTCOL at the beginning of your macro such as Dim CONTCOL as long I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ I hope this helps and thanks so much.
@xaviertkk
5 жыл бұрын
Thanks for the great tutorial! Learned very much. I would like to ask if a placeholder frame (rectangle) for the picture in the sheet itself would make it easier to load the specific size of the picture and set the desired location rather than in the macro
@ExcelForFreelancers
5 жыл бұрын
HI thank you for your question Xavier. I don't think a frame would help however you would just want to determine the maximum width and height of a picture, then use those max values to set the picture height or width depending up which is greater, and maintaining the aspect ration.
@asadurrahman2834
3 жыл бұрын
I got some problems with my code: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("E5:H9")) Is Nothing And Range("B4").Value = False And Range("B3").Value = False Then Cells(Range("B2").Value, Cells(Target.Row, Target.Column + 8).Value).Value = Target.Value End If End Sub #rd line shows the error..
@ExcelForFreelancers
3 жыл бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@mikelgaloy5259
5 жыл бұрын
Hi! thanks for this tutorial vid, but I keep on having an error on H7 & H9 on first row of the data saved, they alternately change every time I save a new contact. honestly I am new in VBA, I just copy your work. so im having a hard time figuring out what is wrong on my input.. thanks a lot! kudos!
@ExcelForFreelancers
5 жыл бұрын
HI Michael thanks for your comment and I am glad you found our channel. We do have an Excel For Freelancers Facebook Group here: bit.ly/groupexcel If you can create a post and add your screenshots of the issue and your modifications we can help you through the bug. Thanks so much.
@FARHADSARAFRAZ-h5z
10 ай бұрын
Option Explicit Dim ContRow As Long Dim ContCol As Long Sub Count_Load() With Sheet1 If Range("B3").Value = Empty Then Exit Sub .Range("B4").Value = True 'Set contact Load to True ContRow = .Range("B3").Value 'Contact Row For ContCol = 4 To 10 .Range(.Cells(11, ContCol).Value).Value = .Cells(ContRow, ContCol).Value Next ContCol On Error Resume Next .Shapes("ThumbPic").Delete 'Delete thumbnailpicture(if any) On Error GoTo 0 'If Range("M4").Value Empty Then Cont_DisplayThumb .Range("B4").Value = False .Shapes("ExistContGrp").Visible = msoCTrue .Shapes("NewContGrp").Visible = msoFalse .Range("B4").Value = False 'Set contact Load to False End With End Sub Sub Cont_New() With Sheet1 .Range("B4").Value = True ' Contact Load .Range("B2").Value = True 'New Contact .Range("E5,E7,E9,H5,H7,H9,M4").ClearContents .Shapes("ExistContGrp").Visible = msoFalse .Shapes("NewContGrp").Visible = msoCTrue .Range("B4").Value = False 'Contact Load to false End With End Sub Sub Cont_Save() With Sheet1 If Range("E5").Value = Empty Then MsgBox "Please Enter a Contact Name" Exit Sub End If ContRow = .Range("D99999").End(xlUp).Row + 1 'First available Row For ContCol = 4 To 10 .Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value Next ContCol .Shapes("ExistContGrp").Visible = msoCTrue .Shapes("NewContGrp").Visible = msoFalse .Range("B3").Value = False End With End Sub Sub Cont_Delete() With Sheet1 If MsgBox("Are you sure you want to delete this Contact", vbYesNo, "Delete Contact") = vbNo Then Exit Sub If Range("B3").Value = Empty Then Exit Sub ContRow = .Range("B3").Value .Range(ContRow & ":" & ContRow).EntireRow.Delete .Range("D13").Select End With End Sub Sub Cont_CancelNew() With Sheet1 If Range("D13").Value Empty Then Range("D13").Select End With End Sub Sub Cont_AttachThum() Dim PicFile As FileDialog With Sheet1 Set PicFile = Application.FileDialog(msoFileDialogFolderPicker) With PicFile .Title = "Select a Contact Picture" .Filters.Add "All Picture Files", ".jpg,*jpeg,*.gif,*.png,*.bmp,*tiff", 1 If .Show -1 Then GoTo NoSelection Sheet1.Range("M4").Value = .SelectedItems(1) ' Put File name in m4 End With If .Range("B3").Value = False Then .Range("J" & Sheet1.Range("B2").Value).Value = .Range("M4").Value Cont_DisplayThumb NoSelection: End With End Sub I have sent all the codes so that you can fix my problem better. Thanks
@ExcelForFreelancers
10 ай бұрын
Thanks so much for your likes, shared and feedback
@pissakis7483
9 ай бұрын
Thanks Can you tell me Why I can't use this code '.Range(.Cells(14, ContCol).Value).Value = .Cells(ContRow, ContCol).Value' It have the problem on my PC. Thanks
@ExcelForFreelancers
9 ай бұрын
Hi and thanks so much. You would first one to check the value of ContCol and make sure it is a while number Then you would want to check Row 14 and ContCol (as a column) check that cell to make sure it is a range such as A1, F4 or whatever If you need some help with this I have a video on Data Mapping here: kzitem.info/news/bejne/mK6wqZicq6JzoWU I hope this helps and thanks so much.
@swagman9203
5 жыл бұрын
Hi Randy, Great instructional video. I added the following line .Range("E5").Activate into the Sub Cont_New section as I found it easier when adding a new customer to save the user having to click on the yellow field. I'm not sure if it's been mentioned elsewhere but I found it particularly useful from a data entry viewpoint. Keep up the great work, I've learnt lots from your videos. Thanks, Tony, Australia
@ExcelForFreelancers
5 жыл бұрын
Hi Tony, thanks so much for your comments, feedback and suggestion. I will also add it to my version so that anyone who downloads this in the future will also get this benefit. Much appreciated.
@r47ms
4 жыл бұрын
@@ExcelForFreelancers What is it necessary for?
@FARHADSARAFRAZ-h5z
10 ай бұрын
Why does the program fail? .Filters.Add "All Picture Files", ".jpg,*jpeg,*.gif,*.png,*.bmp,*tiff", 1
@ExcelForFreelancers
10 ай бұрын
Hi and thank you will want to add an asterisk before the .jpg. I hope this helps and thanks so much.
@gen81465
3 жыл бұрын
One minor thing to remind people about: If you're going to have "Delete Record" delete an entire row, be sure all data mapping, and all variables in columns A & B get stored above the actual area where the records reside. Otherwise, that information might accidentally disappear; especially if those rows & columns are hidden.
@ExcelForFreelancers
3 жыл бұрын
HI and thanks so much. Within databases, I use row 1 for the data mapping, but yes you should be careful if you delete rows or columns, data mapping must be updated.
@paganizonda1000ps
2 жыл бұрын
Which Code would you use then? I have this Problem
@MrKunal995
4 жыл бұрын
Dear randy, I am having a small issue, at 47:00, whenever I am saving a new contact, the new contact s appearing at the top of the list and not at the bottom, where a new contact should come. Where I am going wrong, Please guide me. The tutorial has been really helpful.
@ExcelForFreelancers
4 жыл бұрын
Hi please make sure your Contact Row (ContRow) is set as the first available row, something like ContRow = .Range("A99999").end (xlup).row + 1 You can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks. Thank you for your Likes, Shares & Comments. It really helps.
@krn14242
6 жыл бұрын
Thanks Randy. This was excellent. Really enjoyed the step by step creation. This free content is incredibly valuable. There are many concepts and ideas shown here that can apply to many other excel macro applications. Thanks again.
@ExcelForFreelancers
6 жыл бұрын
For sure, you are very welcome and I really appreciate your comment and feedback. I realize this format of starting from the beginning is very helpful so I will continue to do more of this style of training.
@tarasolutions3128
5 жыл бұрын
kzitem.info/news/bejne/1YR-tWyGjXtlfqw
@tink39999
2 жыл бұрын
i'm getting an error in this code: Sub cont_displaythumb() Dim picpath As String With Sheet1 On Error Resume Next .Shapes("thumbpic").Delete 'delte thumbnail picture(If any) On Error GoTo 0 picpath = .Range("m4").Value 'picture path With .Pictures.Insert(picpath) With .ShapeRange .LockAspectRatio = msoTrue .Height = 85 .Name = "thumbpic" End With End With With .Shapes("thumbpic") .Left = Sheet1.Range("j4").Left .Top = Sheet1.Range("j4").Top .IncrementLeft -25 .IncrementTop 10 End With End With 'end sheet 1 End Sub the debug occurs at With .Pictures.Insert(picpath) everything looks right help
@ExcelForFreelancers
2 жыл бұрын
HI and thanks, that means that the picpath is not the correct path for your picture I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@mylove0mylife
5 жыл бұрын
Great tutorial/video. I used it to make a quality analyst form for work, and I loved it. Never touched VBA before this, and it was easy enough to follow. Thank you!
@ExcelForFreelancers
5 жыл бұрын
Thanks so much Nikki, and great to have you in our Excel For Freelancers Facebook Group as well.
@007Papo
5 жыл бұрын
I am having problems with mapping the table to the form Stating run time error 13 mismatch type the I wrote the code as follow: Sub Cont_Load() With Sheet1 If .Range("B3").Value = Empty Then Exit Sub .Range("B4").Value = True 'Set contact Load to True ContRow = .Range("B3").Value 'Contact Row For ContCol = 4 To 28 .Range(.Cells(16, ContCol).Value).Value = .Cells(ContRow, ContCol).Value Next ContCol On Error Resume Next .Shapes("ThumbPic").Delete 'Delete thumbnail picture (if any) On Error GoTo 0 'If .Range("S4").Value Empty Then Cont_DisplayThumb .Range("B3").Value = False .Shapes("ExistContGrp").Visible = msoCTrue .Shapes("NewContGrp").Visible = msoFalse .Range("B4").Value = False 'Set Contact Load to False End With End Sub
@ExcelForFreelancers
5 жыл бұрын
Hi Jose, it is hard to tell the issue from just looking at the code. We would need to see your workbook. Please check that all mapped cells contain a column number. This is important. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@stevem4306
4 жыл бұрын
Great tutorial, thanks for all the hard work. I had a question though. If you were adding loads of new contacts, and tabbing between fields, how could you make it so that after adding the email field for each new customer, then the next 'tab' would highlight the 'add new contact' button so you can just press 'enter' on the keyboard instead of having to use the mouse?
@ExcelForFreelancers
4 жыл бұрын
Hi Steve, thanks so much for the comment and great question. In this training I show you not only how to tab through fields but buttons as well, allowing you to run these macros without ever having to touch your mouse: kzitem.info/news/bejne/opiDsmuOjGl9fag
@abhinav0686
Жыл бұрын
I found this neat little code to prevent any edits in date directly. Hope this is fine to share. If not please feel free to delete this comment. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Not Intersect(Target, Range("A1:A10")) Is Nothing Then Cancel = True End If End Sub
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. I really like the update. Very nice. Thank you for your Likes, Shares & Comments. It really helps.
@tjorange9421
4 жыл бұрын
Hello There Mr. Randy, I followed your tutorial step by step and it really helps me a lot, now i can monitor our employee's information whenever there is a change in the data.... my concern now is to add search and edit button and execute it at the same time with a code for me to easily find specific employee, can you make a video or in any other way, how to add this buttons and make it executable.... Your kind help will complete my workbook and implement it in our office... Thank You.
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks so much. I have a Search feature in which you can copy in my Employee Manager series right here: kzitem.info/news/bejne/1YiinKVnfXuWipg
@tomaskozvalcak3779
6 жыл бұрын
Could you please support me with the formula (copy paste from you , just modified) : Option Explicit Dim NCRRow As Long Dim NCRCol As Long Sub NCR_Load() With Worksheets("NC Evidence") Worksheets("NC Evidence").Select If .Range("B2").Value = Empty Then Exit Sub Range("B4").Value = True 'Set NCR Load to True NCRRow = .Range("B2").Value 'NCRRow For NCRCol = 5 To 65 Worksheets("NC Evidence").Range(Worksheets("NC Evidence").Cells(33, NCRCol).Value).Value = Worksheets("NC Evidence").Cells(NCRRow, NCRCol).Value Next NCRCol On Error Resume Next On Error GoTo 0 End With End Sub Always I have issue with the line: .Range(.Cells(33, NCRCol).Value).Value = .Cells(NCRRow, NCRCol).Value , maybe i have different version of excel or I dont know i followed step by step your video and set up as mutch as possible in line with you..but i really dont know ..THANK YOU for Support
@ExcelForFreelancers
6 жыл бұрын
Hi thanks for your message. concerning the formula, I have created a Facebook group with 9000 Excel Experts so that many of us can help you with your Excel questions. Can you please post your detailed question, with samples or screenshots directly in our group? If you have not Joined yet, please join here: bit.ly/groupexcel. This way we can get you the answers you need, fast.
@hafizzubair9774
6 жыл бұрын
this video is excellent.. and I much prefer walking through the building process with you step by step vs. only interrogating an already built solution. While it may take longer to create and or view the video, I think the learning is elevated by seeing and experiencing the construction live.. including mistakes.. which we all make. I find that I can pause and replay the passages that need emphasis. All in all, the take away is much more valuable and engaging than just being an audience to an explanation of an existing end product. I highly encourage more of this type of tutorial. Also, I'd like to salute you for being so generous and sharing your unbelievable and impressive EXCEL skills. Getting an insight into your techniques and creative solutions is invaluable. Thank you and Thumbs up
@ExcelForFreelancers
6 жыл бұрын
Thanks so much Hafiz, I really appreciate the feedback. I will try to build each application, if time allows, from the beginning so you can see how its being created. If not, then I will try to move slow so you can see how the process was done. Thanks so much for your great comment. Very helpful.
@Matthewm-h9p
10 ай бұрын
I get an error midway through around the 37 min mark when I try to run it I get an error message that pops up and it highlights the section with .Range(.Cells(11, ContCol).Value).Value = .Cells(ContRow, ContCol).Value Any thoughts?
@ExcelForFreelancers
10 ай бұрын
Hi and thanks for your comment, when it is highlighted in yellow, hover your mouse over the variables ContCol and ContRow and make sure they are whole numbers, make sure also in this cell .Cells(11, ContCol).Value on your database sheet you must have a range such as D3 or F5 or whatever. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@sabelokhoza4524
6 жыл бұрын
This is really a very good staff, especially building the system from scratch. Thanks bra
@ExcelForFreelancers
6 жыл бұрын
Thanks very much, I am glad you liked it. I will continue to build applications from scratch. Much appreciated.
@jimjones6182
6 жыл бұрын
Wow this is truly amazing. I had no idea things like this were possible. Thank you very much!
@ExcelForFreelancers
6 жыл бұрын
Thanks so much Jim, I really appreciate your comment. Check out our latest series, Employee manager for more comprehensive designs and features right here in KZitem
@ДмитрийШкуренков
4 жыл бұрын
@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в
@ДмитрийШкуренков
4 жыл бұрын
Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв
@congnghevakythuat
4 жыл бұрын
Very good! Welcome to view and give comments. Thanks
@ExcelForFreelancers
4 жыл бұрын
Thank you very much. I do appreciate that.
@JustoShowCartoons
5 жыл бұрын
This was excellent. I've never thought to map like this. This gave some me some ideas/direction for a application I working on for my wife. Thanks!
@ExcelForFreelancers
5 жыл бұрын
For sure you are welcome I am happy to share that. I also programmed for many years without figuring out how to map data like that. This has also saved me tons of programming time. I am happy to help.
@manleycenobe3804
Жыл бұрын
Hello I have to thank you for this great videos teaching. And please can someone help me to now how to find a good word on this macro: if. Range ("M4"). Value Empty then Cont_Display Thumb IF isn't work on it. Thank you
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. I am glad you enjoyed the video. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@danterusso6354
5 жыл бұрын
Amazing! The data mapping Technic you use added a new dimension to how I was coding my Student Tracking application. Thank you so much. Subscribed and am looking forward to seeing more of your expertise. =8)
@ExcelForFreelancers
5 жыл бұрын
Thanks so much Dante, I really appreciate that. I am going to add some amazing Automation in Parts 4 and 5 so please watch each week. Thanks again.
@sergioe.viscuso2963
4 жыл бұрын
HI, I have tried this macro and unfortunately on ContactMAcros this line is always in yellow [ .Range(.Cells(11, ContCol).Value).Value = .Cells(ContRow, ContCol).Value ]. I have checked several times spelling, syntax and other but it seems correct to the input by you suggested. please Help
@ExcelForFreelancers
4 жыл бұрын
HI Sergio please check your variables. They most be whole numbers and the cell references must be valid. I created a video to help you solve these types of bugs here: kzitem.info/news/bejne/u56uvYhor6udfHo
@samnangchhing3333
6 жыл бұрын
I really love this video. Thank for your showing for start to the end. Mr. Randy, You're really amazing teacher I've ever seen. I've learned so much from your video and it really help me with my business. Thank so much for your sharing.
@ExcelForFreelancers
6 жыл бұрын
Thanks very much for your comment and feedback. Much appreciated. I look forward to bringing you new and exciting videos each week.
@khanyameyiswa1356
4 жыл бұрын
.Range(.Cells(11, ContCol).Value).Value = .Cells(ContRow, ContCol).Value is has a debug. It is highlighted yellow and I don't know what might be wrong Please help
@ExcelForFreelancers
4 жыл бұрын
Hi thanks for your comment. I have created a video to help debug some of these types of issues right here: kzitem.info/news/bejne/u56uvYhor6udfHo I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@victorcharlie9548
4 жыл бұрын
Wow, awesome. I love excel, and manage to stumble along, but you clearly have this down to an art! Always a pleasure to watch you! Keep up the great work & thx again!
@ExcelForFreelancers
4 жыл бұрын
Thank you so very much, I really appreciate that Victor.
@reginasarmento2195
3 жыл бұрын
I am new to this and already lost. I got to 27 minutes and copied the code. When I click on the sheet the code highlights "Private Sub Worksheet_SelectionChange(ByVal Target As Range) and will not work. What am I doing wrong? Thanks for your help ahead of time.
@ExcelForFreelancers
3 жыл бұрын
Hi Reginia, thanks for watching. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@murphdawg6969
3 жыл бұрын
This keeps popping up yellow in my Visual Basic. I've spent hours trying to fix it and have no clue what's going on. Can anybody help me out with this? .Shapes("ExistContGrp").Visable = msoTrue
@ExcelForFreelancers
3 жыл бұрын
Hi Christopher. thanks for your comment. "Visible" is spelled incorrectly. Make sure you check the spelling on that. I hope this helps and thanks so much.
@jimhendrickson4666
8 ай бұрын
I know this is old but I would suggest you go to minute 22 and over dub something that makes sense. I love your videos and they have been very helpful. But in this you say things that make no sense. I'm not an expert but I have watched this numerous times and still don't understand how 5 plus 8 is 13 but is really 4 because it's in column 8. I assume you read what I wrote and thought wtf is this guy talking about. That was done intentionally because that is exactly what it sounds like in the video.
@ExcelForFreelancers
8 ай бұрын
Hi and thanks for your comment and feedback Jim. Yes, I certainly could have worded that differently. The idea is we need to know that when we make a change to that cell, then we must also make a change to column 4 of the database. So I have placed that 4, exactly 8 columns to the right (in the same row). So if when we make a change to any of the cells, we look 8 columns to the right, and we look what # was placed there, and it is that number that we use as a column within the database. Within the last few years, I use a much more streamlined and simple option to map data to the database. Thanks for your valuable feedback. Thanks for sharing
@rakirada4280
Жыл бұрын
This is great! But there is something I can't figure out. I am an Excel novice and I followed the instructions to the letter but I cannot get the VBA to function automatically as shown in 37:30. I have to press the "Run Sub/Userform" button every time in order for the VBA code to execute and the table to update. I can't have the function where you just select a cell in the table and it updates the information above. What am i doing wrong?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much for your comment. It is called a Selection Change event. That means when the user makes a selection of a cell on the worksheet, a macro is assigned under the correct conditions. This code is placed on the worksheet module. Make sure to download my free version using the links in the description You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBADiscount_Randy
@anzebukovnik
3 жыл бұрын
I ran to a problem at displaying a picture. I am constantly getting Run-time error 1004 at line With .Pictures.Insert(PicPath). Any solution to that? Thanks
@ExcelForFreelancers
3 жыл бұрын
HI Anze, thanks for your comment. You would want to make sure you have the correct sheet and the correct file path. If either of these are incorrect this could result in the bug. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@stannovacki2406
Жыл бұрын
a lot to unpack. I think I'd rather deal with the logic first and pretty it up later. you know, what's the design gonna be, what elements are you including, how are they used, etc etc. having the design up-front let's us maintain and expand on what we've done without ugly kludges or wheel-reinventing. I know, that's boring like designing a database. but thats' really what we're doing, isn't it?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks for your comment Stan. We are basically putting software development into 3 seconds, a front end (user or sheet form), back end (excel table as a database) and possibly a 3rd section for reporting, sorting and filtering to view the data. That is the simplest form in it's elements. How much goes into the front-end design is entirely up to who you are building the application for and their expectations and requirements. I hope this helps and thanks so much.
@alejandropina2605
4 жыл бұрын
Hi Randy I have made a catalog of stamps with your indications but it gives me an error in the "Cont_AttachThumb () in the line .filters.add it gives me an error (5) what can be the problem?
@ExcelForFreelancers
4 жыл бұрын
Hi Alejandro it is hard to tell the cause of the issue here in the comments however if you upload your issue, screenshots and details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 25,000 Members who would love to help you with this. Thanks so much.
@arodvi
8 ай бұрын
Excellent form table could you extend it with search option? For example if the contacts become hundreds or thousands will be much easier for searching them in some field or maybe some dynamic table and when you search specific group of contacts to show only them there?
@ExcelForFreelancers
8 ай бұрын
Hi and thanks, yes for sure, In fact i have a 'Search By' field set up for just that in this training: kzitem.info/news/bejne/uoqtl3qbpGWbrYI I hope this helps and thanks so much.
@kilarinarendra3525
3 жыл бұрын
I have some fields and choice box in office forms which I want fill automatically using VBA. I have data in other excel like 10K rows
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks you can use this method along with Integromat to automate the filling of Office Forms. I hope this helps and thanks so much.
@tsmith9354
5 ай бұрын
Great Talent Randy, I would like to add an update button or when i click on the row and add the new info in the field to add that info in that row. How can i accomplish that. or do you have a video showing that feature i can watch. Thanks :)
@ExcelForFreelancers
5 ай бұрын
HI and thanks you can use the same macro for Save New or Update, You just need an If/Then statement to determine if it is new or existing. I show you how to do that in this video: kzitem.info/news/bejne/zodmwHeMropnm6A I hope this helps and thanks so much.
@edgardomachado2704
3 жыл бұрын
Please help . Filters. Add *All Picures Files*, *.jpg,*. gif", 1 Is not working
@ExcelForFreelancers
3 жыл бұрын
Hi Edgardo, try this .Filters.Add "All Picture Files", "*.jpg,*.jpeg,*.gif,*.png,*.bmp,*.tiff", 1 I hope this helps and thanks so much.
@clydetucker1907
9 ай бұрын
I need help getting the Contact Manager spreadsheet to work. When I enter data and save, it produces an error msg advising that I need to enable macros. I did, but it just doesn't work.
@ExcelForFreelancers
9 ай бұрын
Hi and thanks. As an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. You can fix this once and for all by following the steps I have outlined on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much. I hope this helps and thanks so much.
@English_practice89
9 ай бұрын
Thank u for the vedio but I did every thing u said but I have problem ... the pic stay the same does not disappear when I choose another table please help@excel
@ExcelForFreelancers
9 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@jamesleforce6416
4 жыл бұрын
Out Standing Video. ???? Can you use drop downs in the Data in put areas.. Say you have a of things that you need to add. I have about 4 that I would like to add in this project that I'm working and Drop are needed here.
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks so much. The application is open and unlocked so you are free to customize it exactly as you wish including drop down list as well. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@MiguelLopez-pr7vl
3 жыл бұрын
How can you remove single conditional format from a variable range with multiple conditional formatting using VBA? I was able to do this only by removing all conditional formatting and creating the conditional formatting I want to keep again. Is there a better way?
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks you can simply adjust the "Applies To" range for any conditional formatting if you want to remove that conditional formatting for some cells, but keep it for others within a range. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@megawatylestari4432
Жыл бұрын
Hi! Great Tutorial, I tried this to but had some bugs that the button set did not change to save contact and cancel new. Any solutions? I have repeating the video and rechecked my code already exactly the same with yours
@ExcelForFreelancers
Жыл бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@elijahd.spragueph.d8905
3 ай бұрын
Are you able to use this to search for specific personnel, for example, if you type in the name box and press enter will it pull up related rows?
@ExcelForFreelancers
3 ай бұрын
Hi and thanks. yes for sure. Please check out my Ultimate CRM training for more search features. I hope this helps and thanks so much.
@novagulmatico6918
8 ай бұрын
This tuitorial video is very amazing. Just wondering how to add the link on ADD ID BTN
@ExcelForFreelancers
8 ай бұрын
Hi and thanks so much. I did this training many years ago, so i am not sure about the details, however you can right click any button and select 'Assign Macro' to any button. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@Cosmicsciences
Жыл бұрын
Hi Sir Could you please help where i wanted to add workbook when i did this it add's the workbook with single sheet but i wanted to create two sheets when add.workbook method is it possible sir to add workbook with two sheets current method which is i am using right now Set NewWB = Workbooks.Add(xlWBATWorksheet) rng.Copy With NewWB.Sheets(1)
@ExcelForFreelancers
Жыл бұрын
Hi and thanks can you post your question in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@beboolove1133
5 жыл бұрын
peace upon you Is it possible to code in Excel I want a treasury page I want a code when the change in the page is posted to each expense or customer or supplier or on the basis of accounting guidance without erasing any data from the Fund and without duplicating the data in other pages And God reward you with good
@ExcelForFreelancers
5 жыл бұрын
Thanks very much. I am glad you liked the training. You may want to search my channel for "General Journal" to find a few videos that can help you achieve what you are trying. I hope this helps and thanks again.
@markhines6531
Жыл бұрын
I learned a lot thanks for the easy to follow instructions. I do have a question I can’t figure out. When deleting an contact how can you delete or clear just the columns that have the contact information and not delete the Entire Row. I have added a list of data validation items to the right and I keep loosing information from these lists. Thanks again.
@ExcelForFreelancers
Жыл бұрын
Hi Mark, thanks for your comment. There are instances when we want to delete a contact, but not the entire row. You may want to leave the first column (which should be an ID #) with its value in place. You can run a loop from the 2nd column, to the last column, and clear out the contents of the cells. I show you how to do this in this video: kzitem.info/news/bejne/woGMm6ebk5-adag I hope this helps and thanks so much.
@jmerc14
Жыл бұрын
runtime error 5 invalid procedure call or argument .Filters.Add "All Picture Files", ".jpg,*jpeg,*.gif,*.png,*bmp,*tiff, 1"
@ExcelForFreelancers
Жыл бұрын
Hi. make sure you have a . in front of all the file types (missing on jpeg, bmp and tiff Also, this code is for a PC and not a Mac I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@jmerc14
Жыл бұрын
Tnx a lot.😀
@LeeKobe1
Жыл бұрын
Great tutorial! Noob question...can this be created in the online version of Excel? Thanks.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. The online version does not allow macros. Online Excel uses 'Scripts' however these scripts are not as powerful as macros, yet. I hope one day they will be. Thank you for your Likes, Shares & Comments. It really helps.
@mdrizwanulhasan9279
Жыл бұрын
I want to put my data entry form in a different worksheet then the table. how should I index the worksheet with data table for selection change and others macros? Please help me out!
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. I show you how to do that in my School Manager Series, so please check those videos. I hope this helps and thanks so much.
@nicharding3994
4 жыл бұрын
I am following your video and doing ok but ..... Please Can you help, I cannot see what I have got wrong but I keep getting a compile error: or a syntax error. on this line of code .Range(ContRow&":"&ContRow).EntireRow.Delete b2 is my selected value and is not empty and f14 is my first record in the table. Sub Cont_delete() With Sheet1 If MsgBox("Are you sure you want to delete this Recipient", vbYesNo, "Delete Contact") = vbNo Then Exit Sub If .Range("B2").Value = Empty Then Exit Sub ContRow = .Range("B2").Value .Range(ContRow&":"&ContRow).EntireRow.Delete .Range("f14").Select End With End Sub Thanks Treewizard
@nicharding3994
4 жыл бұрын
I got help from the facebook page thanks!
@ExcelForFreelancers
4 жыл бұрын
Hi Nic, thanks for your comment. You are just missing some spaces in that line and should be like this: .Range(ContRow & ":" & ContRow).EntireRow.Delete I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@systemadmin8075
2 жыл бұрын
The below line commands getting error. Kindly reply Cells(Range("B2").Value, Cells(Target.Row, Target.Column + 8).Value).Value = Target.Value
@ExcelForFreelancers
2 жыл бұрын
Hi and thanks please check your data mapping and make sure that 8 columns to the right is a whole number. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@barrychumley2840
2 жыл бұрын
Enjoyed the video. But I'm getting the same error while adding a new contact, Run-time error '1004': Application-defined or object-defined error. I've also downloaded the Data Entry Form file and that's doing the same thing. I'm running Excel on Windows 11.
@82ndRelic
4 жыл бұрын
at 22:14, you say 5 plus 8. You lost me because you refer to the 4 in that box. Help me out, my friend. Much appreciated.
@ExcelForFreelancers
4 жыл бұрын
HI and thanks the 4 is the column # in which the data is saved. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@Its_SavannahOfficial
Жыл бұрын
I am trying to create an Invoice that uses this type VBA, but I would like my database on a different Sheet. I can not get it to work no matter what I try. Is there somewhere that I can go that can help with that?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much. This video should help you with that: kzitem.info/news/bejne/mm-uvJaMhnNzfWU I hope this helps and thanks so much.
@Darioq57
2 жыл бұрын
When using the Save Button. I only have 3 records on my data base. I expected for the sub to write the entry after the last record found on the data base. The sub is writing it to the end of the table rather than the next available record. Sub Cont_Save() With Sheet4 If .Range("G11").Value = Empty Then MsgBox "Please Enter a Contact Name" Exit Sub End If ContRow = .Range("F100999").End(xlUp).Row + 1 'First Row after last "THIS IS WRITING TO THE END OF THE TABLE, NOT TO NEXT EMPTY ROW AFTER LAST RECORD. For ContCol = 6 To 13 .Cells(ContRow, ContCol).Value = .Range(.Cells(21, ContCol).Value).Value Next ContCol .Shapes("ExistContGrp").Visible = msoCTrue .Shapes("NewContGrp").Visible = msoFalse .Range("B3").Value = False ' N o longer a new Contact End With End Sub Tried this but getting an error ContRow = .Range("F100999").End(xlUp).Offset(1, 0) 'First Row after last Changed this 'For ContCol = 6 To 13 .Cells(ContRow, ContCol).Value = .Range(.Cells(21, ContCol).Value).Value ' Error on this line Am I doing something wrong? There are Empty rows between the las record and the end of the table.
@ExcelForFreelancers
2 жыл бұрын
HI and thanks for your comment. Make sure your data is on Sheet4 and not another sheet, Also use another column other than F in which only your data is. Also check for spaces in the cells. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@charlesgrady249
5 жыл бұрын
Great video but a little long. I found it hard to follow all the mapping. I think it would have been better to show the commands first and then add the mapping. I have watched the video 3 times and needed to stop the video and work on another computer to follow all your instructions, The information is all there but very hard to follow. I think it would have been better to break it up into multiple parts. Learned a lot about coding applications
@ExcelForFreelancers
5 жыл бұрын
Hi Charles thanks so much for your feedback. I am really glad you learned a lot. Much appreciated.
@Shophaws
2 жыл бұрын
i difintely follow your step but in macros said Error while in D13:J9999
@ExcelForFreelancers
2 жыл бұрын
Hi Dee, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@tireddad6618
20 күн бұрын
I was following along and found that i couldn't get the blue row to move on it's own like you were able to. I downloaded the file and there's no difference. In my code and yours.
@ExcelForFreelancers
19 күн бұрын
Hi and thanks so much. You will want to make sure the code within the selection change event places the target.row in the appropriate cell I have a specific training on that here: kzitem.info/news/bejne/l4ed32WOj3yKm44 I hope this helps and thanks so much.
@tireddad6618
19 күн бұрын
@@ExcelForFreelancers thanks. Can't wait to figure this out!
@cameranmohammad8532
3 жыл бұрын
Please I need support How can I after filter and display contacts make an update for one or more information and when press update button the modified data added as new row Pls pls Thanks
@ExcelForFreelancers
3 жыл бұрын
Hi Cam,eran, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@FARHADSARAFRAZ-h5z
10 ай бұрын
سلام. اگ امکان داشته باشه لطفا" فایل اصلی برنامه را برایم ارسال فرمایید. با تشکر
@ExcelForFreelancers
10 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@khalilalsheyadi6486
3 жыл бұрын
Hello I'm a fan of the place you've been introducing. I'm in some trouble when i'm running the Macro Hello I'm a fan of the place you've been introducing. I'm in some trouble when i'm running the Macro . Can you help solve the problem?
@khalilalsheyadi6486
3 жыл бұрын
When I turn on the Macro Load, Show me a wrong letter written in it, "Run-time error, Method 'Range' of object '_Worksheet' failed",
@ExcelForFreelancers
3 жыл бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
@a-copssecurityservices6186
4 жыл бұрын
Hi Randy, when i try to save a contact I am getting the following error, run time error '1004', method Range of worksheet failed and when I click on debug the line .Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value highlights in yellow, I have followed your code but can not figure out why I can not save entry
@a-copssecurityservices6186
4 жыл бұрын
Sorry just to add, I was following your guide How to Create an Excel Data Entry form Without a Userform
@ExcelForFreelancers
4 жыл бұрын
Hi thanks very much. Those types of bugs are pretty common when making any kind of changes. In fact I created an entire training video on how to fix those types of bugs and issues right here: kzitem.info/news/bejne/u56uvYhor6udfHo
@paulforster6873
4 жыл бұрын
how can i change this code to skip a col For ContCol = 3 To 13 i want to skip col 6, so id like =3 to 5 and 7 to 13 to only be returned
@ExcelForFreelancers
4 жыл бұрын
I Paul uou can add something right under the For ContCol = 3 to 13 like If ContCol = 6 then Goto NextColumn then right above the Next ContCol add NextColumn: I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@leonardrobinson8757
3 жыл бұрын
This is some Great Stuff Thank you for bringing this video to us I just would like to know If I could do all this in OpenOffice Software.
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks so much. This code and function is exclusive to Microsoft Excel. I have not worked with Open Office so I am not sure. Thank you for your Likes, Shares & Comments. It really helps.
@syvqcool3095
4 жыл бұрын
Hye why my code have 438? I think my ContRow is problem why?
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks for your comment. Can you please upload a screenshot of your bug and all of the details of your code and application to our Excel For Freelancers Facebook Group here: bit.ly/groupexcel we have 20,000 members who would love to help you with this.
@dennissapiandante
6 ай бұрын
why icant use this .Filters.Add "All Picture Files", ".jpg,*.jpeg,*.gif,*.png,*.bmp,*.tiff", 1
@ExcelForFreelancers
6 ай бұрын
Hi and thanks, If you are on a Mac, the code would be different. You can view that here: www.macexcel.com/ If its another issue, please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@dennissapiandante
6 ай бұрын
I STILL HAVE ERROR ON THIS ON With .Pictures.Insert(picpath) @@ExcelForFreelancers
@ExcelForFreelancers
6 ай бұрын
Hi and thanks. this would mean your picture path is not correct. I hope this helps and thanks so much.
@calehetariki1650
Жыл бұрын
This is really cool vid. Thanks for this. I am getting an error every time it runs at the '.Title="Select a Contact Picture". All code I've copied word for word so am stuck. Am running v 16.69 on a mac if that helps
@calehetariki1650
Жыл бұрын
sorry to be clear - the error I am getting is Runtime error 91 - Object variable or With block variable not set
@ExcelForFreelancers
Жыл бұрын
Hi Cale, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
@THOMASBALAN
3 жыл бұрын
Why when i arrive at minute 45:01 , this messege come out (variable uses an automation type not supported in visual basic
@ExcelForFreelancers
3 жыл бұрын
Hi Thomas Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. I would have to look at the variable declaration. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
@cameranmohammad8532
3 жыл бұрын
Hi After highlighting one contact and loading the contacts in the cells how can I reset those cells and make it empty to add new contacts. What is the code to clear the contacts from cells Thanks
@ExcelForFreelancers
3 жыл бұрын
HI and thanks for your comment. You can clear contents using the ClearContents command such as Sheet1.Range("A1").ClearContents or Sheet1.Range("A1,B1").ClearContents I hope this helps and thanks so much.
@katelynhutchinson1117
5 жыл бұрын
I am getting an 1004 run-time error when I run my save contact sub that says Method 'Range' of object '_Worksheet' failed It references the .Cells(ContRow, ContCol).Value = .Range(.Cells(11, ContCol).Value).Value line The sub appears to work as the information is pasted correctly at the most bottom row. However, the error keeps popping up. I have no idea what it means. Help?
@ExcelForFreelancers
5 жыл бұрын
HI thank you appear to have an issue in data mapping. check all your variable and connected cells for proper column #'s. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@KristineColvin-ix5yf
Жыл бұрын
I want to create a spread sheet in excel where when I click on a cell (named dozer) it will show the parts list i have entered in another worksheet. Is this possible and if so how??
@ExcelForFreelancers
Жыл бұрын
Hi and thanks for your comment. I am sure it is possible however I would not be able to explain it in a KZitem comment as it depends on the structure of your data and workbook. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
@iscariotpaladin5363
10 ай бұрын
Love the video but having issue was the module and can’t quite see the error from mine to yours.
@ExcelForFreelancers
10 ай бұрын
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
@Qwazerty-x4z
2 жыл бұрын
The fact that we delete a contact by deleting a row ends up for me with no more lines formated. So instead of "EntireRow.delete" I did .selection; and Selection.ClearContents; and sort the contact board from a to z (not creating a blank row in the middle of filled ones). I would be happy to know an easier way to do that. Thanks Randy for this usefull knowledge shared! I am currently using this video to make a Seminars multibilling platform for valet car park at work.
@ExcelForFreelancers
2 жыл бұрын
Hi Corentin, thanks so much for the comment and feedback. Clearing the contents and then resorting the table can work just great, as long as you don't mind the order of your data changing. This may be better as it won't affect things like conditional formatting and named ranges. I hope this helps and thanks so much.
@Qwazerty-x4z
2 жыл бұрын
@@ExcelForFreelancers thanks so much for your answer, best wishes for this new year!
@Baryogenese
4 жыл бұрын
I dont get it, how is it possible to perform a color fade over more than one cell? If i select a couple of cells and format it, i get a color fade for each single cell.
@ExcelForFreelancers
4 жыл бұрын
Hello there, if you are performing a color fade, over multiple cells vertically you would just have to use different color fades and matching, for example "Dark Blue to Medium Blue" on the top cell, and the one below it would be "Medium Blue to Light Blue" (as long as the Medium blue is the same, then it will provide a nice color fade between cells. I hope this helps and thanks for your question.
@s.p7094
4 жыл бұрын
Good Day Sir, I really love your video, I really learn a lot, may I ask, what if I need to add the gender and is it possible to automatically separate male from female and in alphabetically arranged? Thank You in advance
@ExcelForFreelancers
4 жыл бұрын
Hi and thanks for your great question. It is certainly possible. You are welcome to add additional fields, Once added you can run an advanced filter based on the gender and then add those to list and then sort. Feel free to download the application from the links in the description and customize this yourself.
@s.p7094
4 жыл бұрын
@@ExcelForFreelancers Thank you so much Sir 😊. Your are a great help.
@srkim9085
3 жыл бұрын
I don't know why not use user-form? I think more easy coding if use user-form.
@ExcelForFreelancers
3 жыл бұрын
Hi and thanks very much. Userforms are great sometimes and other times sheet forms are a lot more customizable since we can control the look and feel. Thank you for your Likes, Shares & Comments. It really helps.
@FARHADSARAFRAZ-h5z
10 ай бұрын
Hello.I like your program .please send me the original file of the program.
@ExcelForFreelancers
10 ай бұрын
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
@ricky-lv3wi
4 жыл бұрын
i always stuck at .Range(.Cells(18, ContCol).Value).Value = .Cells(ContRow, ContCol).Value the error Run time error 1004 Method 'Range' of object '_Worksheet ' Failed any suggest?
@ExcelForFreelancers
4 жыл бұрын
Hi Ricky, thanks for your comment. I would be happy to help. When the bug happens run your mouse over the ContCol and the ContRow and make sure they are actual #'s. Also in the immediate window of VBA place: ?.Cells(18, ContCol).Value And make sure this value is an actual cell address. If not then in the immediate window place: ?.Cells(18, ContCol).Address And then see what cell address this is. That cell must contain a cell address such as C4 or H5 or something like that. Also please see this video to help you debug issues like this: kzitem.info/news/bejne/u56uvYhor6udfHo I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@ricky-lv3wi
4 жыл бұрын
@@ExcelForFreelancers the row is 18 and when i use ?.Cells(18,ContCol).Address the result is $K$18 please any suggest.
@ExcelForFreelancers
4 жыл бұрын
Make sure your ContRow is a whole number as well. If that does not work please upload your screenshot in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
@avelamagazi5055
2 жыл бұрын
Love your work but can anyone please tell me why excel crashes? Then I need to rewrite the code from scratch
@ExcelForFreelancers
2 жыл бұрын
HI Avela, Excel can crash often due to looping worksheet change events. Please make sure to always save your work often and use file sharing and backup folders such as Dropbox, Google Drive and Microsoft One Drive. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@vikasvimal01
4 жыл бұрын
how to protect the labels and other text on the sheet from being edited by any user by mistake... ???
@ExcelForFreelancers
4 жыл бұрын
Hi You can protect the sheet and make sure Edit objects is un-selected. This will protect the shapes. Thank you for your Likes, Shares & Comments. It really helps.
@stevekangman3826
4 жыл бұрын
Hi Randy. I have just discovered your site and watched a few of your videos, and noticed that all your interfaces contained merged cells. I find that in most cases (especially, if only in the case of a title row) that Center across selection works just as well if not better, what would be your take om this.
@ExcelForFreelancers
4 жыл бұрын
Hello Steve, Thanks very much. I have used both at times however I have found that its easier for users to navigate through merged cells when entering data. In case of a Title both will work just fine. Thanks so much.
@AraRoodbuik
Жыл бұрын
I'm going to email my worksheet to Microsoft Belgium. Apparently there must be a difference between excel and excel 365. I once literally made an exact copy of this contact manager. This has taken a very long time. Stopping, retyping, playing again, etc. Nothing seems to work. I've already found out that if someone types a formula and uses a (,) that I have to put (;). I thought that making a Macro or a VBA was always in English, no matter what language office is installed in. It is very frustrating for me because you deliver top quality to the viewer. Like in your conditional formatting with a new rule. I use the formula =$B$3=Row(), I go to format, give the background a color, make the font white, I press ok, but nothing works and I don't get any errors. I have also literally copied your VBA completely. Stop and resume 100 times to make sure. It didn't help. So I think Excel 365 can't do what the original Excel can do. Thank you very much for your explanation and KZitem presentation.
@ExcelForFreelancers
Жыл бұрын
Hi and thanks very much. Your language pack, if not English, can really make a difference. You may want to experiment with English language packs to see if that solves the issue. I use Excel 365 to make all my newest videos and I never use features that only new (or old Excel versions) can use. In other words, I stick with basic formulas and vba functions that almost any version can use. (as long as you are not working in a browser) I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@AraRoodbuik
Жыл бұрын
@@ExcelForFreelancers It is indeed what you say. I once replaced the new line from =$B$3=Row() to =$B$3=Rij(). Rij is the Dutch word for row. And now every row I type in cell B3 gets a color. I'm afraid my English isn't advanced enough to translate a full VBA into Dutch. It remains my dream to become an advanced excel user. It's like a hobby but I love it.
@ExcelForFreelancers
Жыл бұрын
Good job. You are right, we are now in year 2023. The software should be smart enough to translate all of the formulas to the new language pack. It is really unacceptable to have to do this manually when everything else is translated so easily. It is not your fault, but you did a good job of figuring out the solution. Thanks for the update.
@HKrawick
Жыл бұрын
Nice! Do you have one that is set up by account or customer name and you can search by that customer/account name to return contact info and so forth?
@ExcelForFreelancers
Жыл бұрын
Sure you can try my Customer Manager application & training here: kzitem.info/news/bejne/s69pto2KhpSknpw
@ThePsycho147
3 жыл бұрын
Please show us how to add search botton in is excel work book... Thank you in advance
@ExcelForFreelancers
3 жыл бұрын
Hi Mahfuzul, thank you for your comment. I will add it to my list of videos to create. Thank you for your Likes, Shares & Comments. It really helps.
@nsa3679
3 жыл бұрын
worksheet change row and column numbers hard to understand Edit: I understood it
@ExcelForFreelancers
3 жыл бұрын
If you are having a specific issue, please post it in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
@manianand2956
4 жыл бұрын
Plz plz plz can u explain same if it's matter of 2 sheets , I just need that tabele on other sheet and do same jobs ...can u explain how can I configure VBA for that
@ExcelForFreelancers
4 жыл бұрын
HI Mani, In my Employee Manager series I have a from on one sheet and data on another sheet. You can use this system for your application. Just search my Channel for "Employee Manager" Thanks so much.
@manianand2956
4 жыл бұрын
@@ExcelForFreelancers thank u I just created a dynamic entry panel by combining all yours and other ideas .....still working to create a full accounting , customer record , vendor record, products record ,transiction record, all statement auto genration platefor.
@TimPingYeung
Жыл бұрын
Can I put it in network drive and let multiple users access it at the same time? Or this is for one user only?
@ExcelForFreelancers
Жыл бұрын
Hi and thanks so much, to share and sync your macro-enabled Excel workbook in a shared folder or network drive, please watch this training: kzitem.info/news/bejne/x5VnrqeIcmVhaH4
@asadnawaz2081
4 жыл бұрын
How to add search filter button and print button in this project please guide me
@ExcelForFreelancers
4 жыл бұрын
Hi I have done 'search' before in other videos, especially with the Employee Manager series so you can search my channel for that. Concerning the Print button, I have added this to the Invoice application on my channel so you can search for that as well. I hope this helps and thanks.
@edgardomachado2704
3 жыл бұрын
I also have a message of amhiguous name detected worksheet selection change. Is on the changes you place at the end
@ExcelForFreelancers
3 жыл бұрын
Hi Edgardo, you can only have one Selection change code per worksheet so double check that this has not been duplicated. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
@garretcunningham615
5 жыл бұрын
Hi There please help, when i click on Delete Contact i get a run time error 1004 Method 'Range' of object'_Worksheet failed points tio this row .Range(ContRow & "." & ContRow).EntireRow.Delete any suggestions please. Thank you!
@ExcelForFreelancers
5 жыл бұрын
Hi Garret, thanks for your comment. When you click 'Debug' when the error happens put your mouse over the ContRow. This is probably blank. You have to check the code above to see why this variable is blank. You have to make sure it contains a number. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here:bit.ly/groupexcel
@garretcunningham615
5 жыл бұрын
@@ExcelForFreelancers Thank you for your response, Hovering over ContRow gives me the row number. I will persevere.
@ExcelForFreelancers
5 жыл бұрын
Hi Garret, i see the error now. It should be ":" and not "." (colon and not a period) This should help
@gamesofduster9817
4 жыл бұрын
Hi randy. I'm realy a newby in this kind of excel. I try this sheet for a project for the camping were I do the financien. The begin is so far so good till the first Code: =Mod(Row(),2)=0. I get an error that if I don't want to write a code bla bla bla. So I can't use the code. Do you have an alternative code? Regards Jeroen
@ExcelForFreelancers
4 жыл бұрын
HI and thanks for your comment. Based on your regional settings, Excel will replace a comma with a semicolon so please try =Mod(Row();2)=0 I hope this helps and thanks.
@gamesofduster9817
4 жыл бұрын
@@ExcelForFreelancers Hi Randy....I don't get the error indeed however I don't get the table collors eather Regards Jeroen
@ExcelForFreelancers
4 жыл бұрын
Hi Games, Thanks for your comment. It would be difficult for us to help unless we see the specific bug for the conditional formatting you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 30,000 Members who would love to help you with this. Thanks so much.
Пікірлер: 1,1 М.