I like the "From Scratch" videos and I learned a lot. But I think that a beginner can't handle it because a lot of it isn't really from scratch, but has already been created. For example, the combobox can only access the table if it is already created and the named range already exists. For beginners it is easier if you first see how the data sheets are created and then the user form. But for advanced users it is very instructive.
HI and thanks very much for your feedback and comment. These Tuesday trainings are exclusively for intermediate and advanced users and my weekend trainings are for beginners. ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
Hi and thanks for your comment. I have added more feature to the updated version on our Patreon platform here: www.patreon.com/ExcelForFreelancers You are also welcome to download this for free and customize it however you like. I hope this helps and thanks so much.
Hi and thanks for your comment. You can use INDEX if you want instead of OFFSET. More information on that here: www.mrexcel.com/excel-tips/learn-excel-replace-offset-with-index/ I hope this helps and thanks so much.
Very good application and video! Thank you Randy. In the form of this application there is a restriction of the number of categories (max 6), subcategories (max 12) and products (max 18). Is there a way to make these scrollable like a listview can? So you can use more then the restricted items.....
Hi and thanks, yes for sure. Instead of using a picture or button you can use a listbox to display the categories, which can be scrollable, and allows for unlimited categories. Just increase the font on these and when selecting they will load the sub-categories (which can also be in a list box) I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
Dear Randy , thank you on your presentation What if I have more then 20 Categories , idea is that some day I will have less then 20Categories other day I will have more then 30? What is solution for that?
HI and thanks very much for your comment. You can run and advanced filter (without any criteria) in order to get the unique # of categories. Once you have a list of unique categories you then run a loop from the first category to the last category. I will then create those shapes based on each category. Make sure to name the shape the same as the category name, so that when someone clicks on a category, it is the name of the shape, the category name, that is used as the criteria to display all of the items within that category. I hope this helps and thanks so much.
Hi Randy. Trying to learn VBA in my old age. Is there any way to show the subcat pics and labels for only the items that appear in the subcat list in the database. Eg. When i Click on a Category A it shows all the subcats correctly, but when I click on Category B it shows all the assocated subcats for Cat B AND the subcats for Category A. I was hoping that each time we selected a Category the SubCats will be cleared and the new items for the next Category will show up. Is There a simple script to achieve this. Thank you kindly.
Hi and thank very much. When you select a Category, you want all the sub-categories to show and when a sub-category is selected, you want the advanced filter to run to display those sub-category items. Please check your advanced filter settings to make sure the correct sub-category criteria is being placed. 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
@@ExcelForFreelancers Thank you sir. All works fine. If CAT A has 12 Subcats. All 12 will show up. CAT B has 8 Subcats and all eight show up however the two subcats from CAT A remain still remain in the list of subcats in slots 9 10 11 and 12. The Subcats dont clear up when another Category is selected. Just looking for a routine that will clear the subcats before loading the new subcats. Thank you kindly for replying and offering help.
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.
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.
Hi and thanks yes for sure. There are many ways to add new products. I have made updates to this application on my Patreon platform here: www.patreon.com/ExcelForFreelancers Thank you for your Likes, Shares & Comments. It really helps.
Thank you so very much, I really appreciate that and I am so glad you loved the training. Thank you for your Likes, Shares & Comments. It really helps.
hello sir, how can I change all the dollar signs in the currencies to pesos because it doesn't change when I use it in the user form, the dollar sign is still on the receipt when the receipt is printed
Hello, thanks a lot for all your tips. But I do have some issues using your tutorial of Point of Sales System in Excel. I am trying using your tutorial using only the last step without any subproducts. But i am missing some insights. And i need to finish it by next week-end. Can you help me please?
Hi Claudia, thanks for your comment. If you need help with this, 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.
Hi and thanks. Yes for sure every single one of my applications contain macros. If you have downloaded a template and macros are blocked, 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.
@@ExcelForFreelancers I appreciate the response so dearly much, thank you!! Sorry to bug again, but if I wanted to implement this to using the share and sync, how do I get it to actually start sharing and synching? Do we have to manually run the macros for it to work, or should it just function in the background? I got everything set up correctly minus the pictures but am having no luck. Many thanks for all your help!
Hi and thanks very much. Each person has their own duplicate workbook and only the data is shared across all users with a shared folder. To share and sync your macro-enabled Excel workbook, please watch this training: ruclips.net/video/f_1HsR9305I/видео.html
Hi and thanks so much for your comment. I make all pictures, icons and resources available for download for our Patreon members here www.patreon.com/ExcelForFreelancers
Hi and thanks very much. Some countries and banks offer 'Cash Back' when paying with a credit card so i wanted to leave this option open, however you are welcome to download this and customize it however you like. I hope this helps and thanks so much.
Hi and thanks Paul. Yes for sure this can be used. You would want to customize it and secure it, but it certainly can be used in a real-world situation. Thank you for your Likes, Shares & Comments. It really helps.
can you add ingredient tracking to the POS?, I'm looking for a cheaper way to run my business. app POS are getting to expensive to run. would love to talk more about this with you.
HI and thanks anything is possible, however I am unable to take on any custom job. Feel free to post a PAID JOB 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.
Hi and thanks you can check my Ultimate ERP template and training and customize this to fit your exact requirements here: ruclips.net/video/HE-g2BAC5Ks/видео.html I hope this helps and thanks so much.
Hi and thanks so much. Make sure you have jpg images and that the file path to the images are correct. I will create a VBA Basic training on working with images in userforms in the near future. I hope this helps and thanks so much.
First of all, I would like to apologize for the inconvenience I cause you from time to time. Well, sir, will the pictures in the folder be the same size? Best regards.
Hi and thanks for your comment. The pictures do not need to be the same sizes, however they might look better if they have similar sizes. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks, yes for sure there is. You can customize this using the features that I show you in my Payment Manager training here: ruclips.net/video/DfNDr8DFkb8/видео.html I hope this helps and thanks so much.
Hi and thanks very much. Every single one of my template downloads are absolutely free, using the links in the description under the word 'DOWNLOAD' If you want all 300 at the same time, then you could pay for that here: bit.ly/300WkBks_Randy I hope this helps and thanks so much.
Dear Randy thanks for your efforts, it's really useful, have a question. Is it possible to make this excel application in multi languages? I Mean there be an option to choose our language and whole application change to other language Thanks
Hi and thanks, Yes for sure this is an option, no doubt. Perhaps in the future, I will create a training on how to make a 'multi-lingual' application I hope this helps and thanks so much.
Is it possible to add a discount button? For me I have a product that if they buy 5 of the product it is at discount cost. (I.e. individual cost is $5, 5 product $8). How would I do this with this system? Also, how can I link credit card and bank icons to my bank account to actually get paid?
Hi and thanks. Anything is possible with this template. You are welcome to download it and customize it however you want, or if you want to have it customized for you, feel free to email me and I can refer a developer at a fair cost (Randy@ExcelForFreelancers.com ) I hope this helps and thanks so much.
Hi and thanks very much. You are welcome to download this and use it for any type of retail or service. Just add your own pictures and names and customize it however you like. I hope this helps and thanks so much.
Hi and thanks so much. It is an interesting idea, can you expand on this idea for me a bit? What did you have in mind beyond a checklist? I have a Kanban board, maybe i could follow something like this? Can you let me know what you would like to see?
I have sent detail on same email kindly check spam as well I have sent it again two time with subject name getting things done or GTD with video and flow chart explain hope it will help
Hi and thanks very much. Yes I hare received both emails now. (4 emails total actually) I will have a look at it and try to get to this in the near future. Much appreciated
Hi Randy. Great Utility. Why do i get Runtime error 481 Invalid picture. Debug points me to this , " Then SubCatPic.Picture = LoadPicture(PicPath) Else ". This happens when I click on the 3rd Category , Meats and Seafood. Will really appreciate any pointers. Thank you kindly.
Hi and thanks, this will mean that the PicPath is not correct. So you would want to check the PicPath and see how it is different to the actual picture on your computer. I hope this helps and thanks so much.
HI and thanks you can check the exact picture names, as there is some issue preventing these specific pictures from loading. I hope this helps and thanks so much.
Hi Aaron, thanks for your comment. I have not tested this on a Mac so there may be some modifications required. Mac's do not allow ActiveX components so if you are using a Mac it is better to run something like this using Parallels which will run PC Windows in a Mac: www.excelforfreelancers.com/go/rwm-parallels-YTDesc I hope this helps and thanks so much.
Hi and thanks so much. I have all of the pictures, icons and other resources available already on my Patreon platform here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Your content is amazing! Can you create a version for florists with website sales and POS integration? That would be awesome! Thanks for your genius work!
HI and thanks so much. This would be a custom job. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Hello teacher. Sorry to bother you again. Teacher, I managed to bring the images, but even though I changed the names of the product subcategories and producs under the subcategory of the products excel worksheet, the names do not change when I open the user form. I would like to ask for your help regarding this problem. Best regards.
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.
Hi and thanks you can change any category you want. Please make sure to watch the entire training video to help you do this. I hope this helps and thanks so much.
Hi and thanks for your comment. The template is unlocked and you are welcome to customize it however you like, including adding, updating or modifying formulas however you like. I hope this helps and thanks so much.
HI and thanks all of my templates are unlocked, and you can click the link under the word DOWNLOAD in the video description. I hope this helps and thanks so much.
Yes sure. I make the all of the pictures, icons and additional resources from this training as well as all other trainings on our Patreon platform here: www.patreon.com/ExcelForFreelancers
HI and thanks for your comment. 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.
HI and thanks so much. I share and explain all of the code that I used within this training, so please make sure to watch the full video. I hope this helps and thanks so much.
HI , thanks for the information. 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.
This is great. Man can you also make a tutorial about classroom management? Columns are: Col1 "College" Col2 "Year Level" Col3 "Course/Program" Col4 "Subject Code" Col5 "Subject Description" Col6 "Classification" whether lecture or laboratory Col7 "Number of Units" Col8 "Equivalent Hours" Col9 "Total Students" Col10 "Time Start for class" Col11 "Days Schedule" e.g. Mon/Thu;Tue/Fri,Wed/Sat,Mon,Tue,Fri, and so on. Col12 "Time End for class" Col13 "Total Hours Rendered" Col14 "Class Group" e.g. Whole Semester,Block 1 & 2,Block 3 & 4 Based on this data, there will be a graphical view to show the schedules and it has a conditional formatting as an indicator whether the subject is belong to the criteria in Col14.
Hi and thanks i have that already. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries I hope this helps and thanks so much.
Hi Randy thank soo much great video , how to we can integrate this POS app with mobile delivery manager excel for freelancer "ruclips.net/video/WRIBkgF61rc/видео.html" it is possible?
Hi Nelson, thanks so much. I do have a Mobile POS application you may be interested in here: ruclips.net/video/FMq9OYMviq8/видео.html I hope this helps and thanks so much.
Thank you very much for your great apps as usual. But answer but after seeing the recommended app I don't see that it has the option to manage delivery integrated. assignment of the order to drivers, scheduling of delivery to the customer, digital signature to certify that the product was delivered to the customer. etc@@ExcelForFreelancers
Hi and thanks very much. The closest I have is the Mobile Delivery Manager here: ruclips.net/video/WRIBkgF61rc/видео.html If you would like help with customizing any of these to your requirements please feel free to post a PAID JOB 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. I hope this helps and thanks so much.
![Optimize Your Shopping Lists With The Ultimate Excel Shopping Manager Application [FREE DOWNLOAD]](http://i.ytimg.com/vi/rGr7yN7Aq8A/mqdefault.jpg)
![Optimize Your Shopping Lists With The Ultimate Excel Shopping Manager Application [FREE DOWNLOAD]](/img/tr.png)
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
this man is not real, he’s a unicorn. You won’t find somebody willing to teach you all of this information for free anywhere else. 👏🏾👏🏾
Thank you so very much, I really appreciate that and so glad you love all of the training and content :)
@@ExcelForFreelancersThank you very much, merci beaucoup, 👍👍✅🌹🌹🌹🌹🌹🌹🌹
For sure, you are very welcome @andalusi423
I can only agree to your comment, followed Randy for a couple of years
and he still blows me away, amazing guy.. 🙂
This is a super fantastic application. Thank you Randy for your continuous brilliant ideas and inspiration.
For sure, you are very welcome Neren and thank you so much for your continued support. I am so glad you enjoyed the training.
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
I like the "From Scratch" videos and I learned a lot. But I think that a beginner can't handle it because a lot of it isn't really from scratch, but has already been created. For example, the combobox can only access the table if it is already created and the named range already exists. For beginners it is easier if you first see how the data sheets are created and then the user form. But for advanced users it is very instructive.
HI and thanks very much for your feedback and comment. These Tuesday trainings are exclusively for intermediate and advanced users and my weekend trainings are for beginners. ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
I hope this helps and thanks so much.
Thank you so much Randy for this amazing video. It's fantastic.
For sure, you are very welcome Syed. I am happy to help and share
Sir Ji this is very very helpful video and exciting application can you add some feature like price discount item wise and manually encrease quanriry
Hi and thanks for your comment. I have added more feature to the updated version on our Patreon platform here: www.patreon.com/ExcelForFreelancers
You are also welcome to download this for free and customize it however you like.
I hope this helps and thanks so much.
Hi Randy, what non-volatile formulas can be use in the list box to bring the data in instead of OFFSET?
Hi and thanks for your comment. You can use INDEX if you want instead of OFFSET. More information on that here:
www.mrexcel.com/excel-tips/learn-excel-replace-offset-with-index/
I hope this helps and thanks so much.
Very good application and video! Thank you Randy.
In the form of this application there is a restriction of the number of categories (max 6), subcategories (max 12) and products (max 18).
Is there a way to make these scrollable like a listview can? So you can use more then the restricted items.....
Hi and thanks, yes for sure. Instead of using a picture or button you can use a listbox to display the categories, which can be scrollable, and allows for unlimited categories. Just increase the font on these and when selecting they will load the sub-categories (which can also be in a list box)
I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
Loved it. You are amaizing.
Thank you so very much, I really appreciate that, very kind of you
Dear Randy , thank you on your presentation
What if I have more then 20 Categories , idea is that some day I will have less then 20Categories other day I will have more then 30?
What is solution for that?
HI and thanks very much for your comment. You can run and advanced filter (without any criteria) in order to get the unique # of categories. Once you have a list of unique categories you then run a loop from the first category to the last category. I will then create those shapes based on each category. Make sure to name the shape the same as the category name, so that when someone clicks on a category, it is the name of the shape, the category name, that is used as the criteria to display all of the items within that category.
I hope this helps and thanks so much.
Hi Randy, was waiting for something like this using Userform, hope it covers stock as well. You the best.
Thank you so very much, I really appreciate that and I am sure you will love the training
Hi Randy. Trying to learn VBA in my old age. Is there any way to show the subcat pics and labels for only the items that appear in the subcat list in the database. Eg. When i Click on a Category A it shows all the subcats correctly, but when I click on Category B it shows all the assocated subcats for Cat B AND the subcats for Category A. I was hoping that each time we selected a Category the SubCats will be cleared and the new items for the next Category will show up. Is There a simple script to achieve this. Thank you kindly.
Hi and thank very much. When you select a Category, you want all the sub-categories to show and when a sub-category is selected, you want the advanced filter to run to display those sub-category items. Please check your advanced filter settings to make sure the correct sub-category criteria is being placed.
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
@@ExcelForFreelancers Thank you sir. All works fine. If CAT A has 12 Subcats. All 12 will show up. CAT B has 8 Subcats and all eight show up however the two subcats from CAT A remain still remain in the list of subcats in slots 9 10 11 and 12. The Subcats dont clear up when another Category is selected. Just looking for a routine that will clear the subcats before loading the new subcats. Thank you kindly for replying and offering help.
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.
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.
You can use controls.add then a code for class module for a dynamic adding of products..
Hi and thanks yes for sure. There are many ways to add new products. I have made updates to this application on my Patreon platform here: www.patreon.com/ExcelForFreelancers
Thank you for your Likes, Shares & Comments. It really helps.
Wonderful sir you so good i can't explain
Thank you so very much, I really appreciate that and I am so glad you loved the training. Thank you for your Likes, Shares & Comments. It really helps.
hello sir, how can I change all the dollar signs in the currencies to pesos because it doesn't change when I use it in the user form, the dollar sign is still on the receipt when the receipt is printed
HI Michael, thanks for your comment. You can update the currency in the Cell Format option in Excel. I hope this helps and thanks so much.
Hello, thanks a lot for all your tips. But I do have some issues using your tutorial of Point of Sales System in Excel. I am trying using your tutorial using only the last step without any subproducts. But i am missing some insights. And i need to finish it by next week-end. Can you help me please?
Hi Claudia, thanks for your comment. If you need help with this, 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.
Do you need Macros to run in order for this to all work?
Hi and thanks. Yes for sure every single one of my applications contain macros. If you have downloaded a template and macros are blocked, 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.
@@ExcelForFreelancers I appreciate the response so dearly much, thank you!! Sorry to bug again, but if I wanted to implement this to using the share and sync, how do I get it to actually start sharing and synching? Do we have to manually run the macros for it to work, or should it just function in the background? I got everything set up correctly minus the pictures but am having no luck. Many thanks for all your help!
Hi and thanks very much. Each person has their own duplicate workbook and only the data is shared across all users with a shared folder. To share and sync your macro-enabled Excel workbook, please watch this training: ruclips.net/video/f_1HsR9305I/видео.html
@@ExcelForFreelancers Okay great, will do! I appreciate you so much! Many many thanks!
you doing great.. how can i get picture folder
Hi and thanks so much for your comment. I make all pictures, icons and resources available for download for our Patreon members here www.patreon.com/ExcelForFreelancers
super fantastic application amazing but I see that you are given change when paying with credit card ??
Hi and thanks very much. Some countries and banks offer 'Cash Back' when paying with a credit card so i wanted to leave this option open, however you are welcome to download this and customize it however you like.
I hope this helps and thanks so much.
Thanks for that love watching your videos please keep it up
For sure, you are very welcome and thanks o much
Amazing again Randy, so could be used in real time in a store?
Hi and thanks Paul. Yes for sure this can be used. You would want to customize it and secure it, but it certainly can be used in a real-world situation. Thank you for your Likes, Shares & Comments. It really helps.
can you add ingredient tracking to the POS?, I'm looking for a cheaper way to run my business. app POS are getting to expensive to run. would love to talk more about this with you.
HI and thanks anything is possible, however I am unable to take on any custom job. Feel free to post a PAID JOB 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.
Very good, but can you write a sales management file that remembers the most recent price of each product and each customer?
Hi and thanks you can check my Ultimate ERP template and training and customize this to fit your exact requirements here: ruclips.net/video/HE-g2BAC5Ks/видео.html
I hope this helps and thanks so much.
Sir, I could not bring images with buttons in this application. I would be glad if you could help me with this. Best regards.
Hi and thanks so much. Make sure you have jpg images and that the file path to the images are correct. I will create a VBA Basic training on working with images in userforms in the near future. I hope this helps and thanks so much.
First of all, I would like to apologize for the inconvenience I cause you from time to time. Well, sir, will the pictures in the folder be the same size? Best regards.
Hi and thanks for your comment. The pictures do not need to be the same sizes, however they might look better if they have similar sizes. Thank you for your Likes, Shares & Comments. It really helps.
Thanks..
I just created a VBA Basic training on how to work with pictures in Userforms that will be available in 1 week. Thanks again
Thank you 🎉🎉🎉🎉❤
For sure, you are very welcome Thank you for your Likes, Shares & Comments. It really helps.
Is there a way to have split payment type?
Hi and thanks, yes for sure there is. You can customize this using the features that I show you in my Payment Manager training here: ruclips.net/video/DfNDr8DFkb8/видео.html
I hope this helps and thanks so much.
Hi I have a question does all the downloads you have cost to download them
Hi and thanks very much. Every single one of my template downloads are absolutely free, using the links in the description under the word 'DOWNLOAD'
If you want all 300 at the same time, then you could pay for that here:
bit.ly/300WkBks_Randy
I hope this helps and thanks so much.
Can't wait !!!!!
Great, thanks so much Keita :)
Dear Randy thanks for your efforts, it's really useful, have a question.
Is it possible to make this excel application in multi languages? I Mean there be an option to choose our language and whole application change to other language
Thanks
Hi and thanks, Yes for sure this is an option, no doubt. Perhaps in the future, I will create a training on how to make a 'multi-lingual' application
I hope this helps and thanks so much.
Thanks so much, will wait for it
Is it possible to add a discount button? For me I have a product that if they buy 5 of the product it is at discount cost. (I.e. individual cost is $5, 5 product $8). How would I do this with this system? Also, how can I link credit card and bank icons to my bank account to actually get paid?
Hi and thanks. Anything is possible with this template. You are welcome to download it and customize it however you want, or if you want to have it customized for you, feel free to email me and I can refer a developer at a fair cost (Randy@ExcelForFreelancers.com )
I hope this helps and thanks so much.
Can I ise this for other retail services? And where can I find the file please help me out.
Hi and thanks very much. You are welcome to download this and use it for any type of retail or service. Just add your own pictures and names and customize it however you like.
I hope this helps and thanks so much.
The best ❤
Thanks so much. Very kind of you and very glad you enjoyed this. Thanks for your continued support
@@ExcelForFreelancers
your student from the Ivory Coast
Thank you so very much, I really appreciate that
Hi Randy Austin please make an excel template on Getting thing done flow chart of productivity
Hi and thanks so much. It is an interesting idea, can you expand on this idea for me a bit? What did you have in mind beyond a checklist? I have a Kanban board, maybe i could follow something like this? Can you let me know what you would like to see?
I have sent detail through email. Have you received it.
Hi and thanks. I have not received it. Please make sure to send it to Randy@ExcelForFreelancers.com
I hope this helps and thanks so much.
I have sent detail on same email kindly check spam as well I have sent it again two time with subject name getting things done or GTD with video and flow chart explain hope it will help
Hi and thanks very much. Yes I hare received both emails now. (4 emails total actually)
I will have a look at it and try to get to this in the near future. Much appreciated
Hi Randy. Great Utility. Why do i get Runtime error 481 Invalid picture. Debug points me to this , " Then SubCatPic.Picture = LoadPicture(PicPath) Else ". This happens when I click on the 3rd Category , Meats and Seafood. Will really appreciate any pointers. Thank you kindly.
Hi and thanks, this will mean that the PicPath is not correct. So you would want to check the PicPath and see how it is different to the actual picture on your computer.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks Randy. But this only happens to the Meat and Seafood option. Everything else works. Thanks again
HI and thanks you can check the exact picture names, as there is some issue preventing these specific pictures from loading. I hope this helps and thanks so much.
Thanks again. I just wrote a little if snippet to bypass the error. Thank you for your patience and also to answering to almost every post on here.
For sure, you are very welcome and I am happy to help
I have OpenOffice will the pos work on it
HI and thanks. This will only work on the desktop version of Microsoft Excel
Can this track inventory to
Yes absolutely. Feel free download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Does this work on a Mac?
Hi Aaron, thanks for your comment. I have not tested this on a Mac so there may be some modifications required. Mac's do not allow ActiveX components so if you are using a Mac it is better to run something like this using Parallels which will run PC Windows in a Mac: www.excelforfreelancers.com/go/rwm-parallels-YTDesc
I hope this helps and thanks so much.
@@ExcelForFreelancers Okay not a worry at all. Nothing a VM can't fix! I appreciate the response so much, and thank you for all your work!
For sure, you are very welcome Aaron
Mr Randy we need to get pecture of items
Hi and thanks so much. I have all of the pictures, icons and other resources available already on my Patreon platform here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much.
Your content is amazing! Can you create a version for florists with website sales and POS integration? That would be awesome! Thanks for your genius work!
HI and thanks so much. This would be a custom job. The application is open and you are welcome to customize this to fit your exact requirements, however I am unable to take on any projects of my own. If you would like some help with this, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet)
You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project.
I hope this helps and thanks so much.
Sir
I will try scrollable listview in userform but I don't know how it makes......
Please mention sir
Hi and thanks, yes on the bill, this is a list of items, when it fills up, it becomes scrollable. I hope this helps and thanks so much.
Hello teacher. Sorry to bother you again. Teacher, I managed to bring the images, but even though I changed the names of the product subcategories and producs under the subcategory of the products excel worksheet, the names do not change when I open the user form. I would like to ask for your help regarding this problem. Best regards.
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.
So sir, I want to change the name of wine in the sub category to green tea, for example..
Hi and thanks you can change any category you want. Please make sure to watch the entire training video to help you do this. I hope this helps and thanks so much.
Wonder full but one thing there are no any option for quantity update
Hi and thanks. I have a video on that coming up next week. I hope this helps and thanks so much.
Can't wait
Great, thanks so much. I am sure you are going to love this training. :)
great waiting
Thank you so very much, I really appreciate that, and i am sure you will love this training.
Items qty manually added to the row are not present so sent add manualy qty send me
Hi and thanks for your comment. The template is unlocked and you are welcome to customize it however you like, including adding, updating or modifying formulas however you like. I hope this helps and thanks so much.
send the details unlocked and customize tell me sir very useful for me @@ExcelForFreelancers
HI and thanks all of my templates are unlocked, and you can click the link under the word DOWNLOAD in the video description. I hope this helps and thanks so much.
I can have pictures folders?
Yes sure. I make the all of the pictures, icons and additional resources from this training as well as all other trainings on our Patreon platform here: www.patreon.com/ExcelForFreelancers
กราบขอบพระคุณเป็นอย่างสูงครับ
Kap Khun Ma krub :) :)
You will teach us from scratch really ?
Yes for sure, I hope this helps and thanks so much.
Why the file i downloaded always get warning especially the macro.
HI and thanks for your comment. 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.
Waiting for it
Great, and thanks so much Keith :)
Thank you for your Likes, Shares & Comments. It really helps.
But what about the code before desinging???? Idk
HI and thanks so much. I share and explain all of the code that I used within this training, so please make sure to watch the full video.
I hope this helps and thanks so much.
can I hire you?
HI , thanks for the information. 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.
❤❤❤❤❤
Thank you so very much, I really appreciate that Mosha-Aldisri
🎉🎉🎉
Thanks so much. I am glad you enjoyed the training
This is great.
Man can you also make a tutorial about classroom management?
Columns are:
Col1 "College"
Col2 "Year Level"
Col3 "Course/Program"
Col4 "Subject Code"
Col5 "Subject Description"
Col6 "Classification" whether lecture or laboratory
Col7 "Number of Units"
Col8 "Equivalent Hours"
Col9 "Total Students"
Col10 "Time Start for class"
Col11 "Days Schedule" e.g. Mon/Thu;Tue/Fri,Wed/Sat,Mon,Tue,Fri, and so on.
Col12 "Time End for class"
Col13 "Total Hours Rendered"
Col14 "Class Group" e.g. Whole Semester,Block 1 & 2,Block 3 & 4
Based on this data, there will be a graphical view to show the schedules and it has a conditional formatting as an indicator whether the subject is belong to the criteria in Col14.
Hi and thanks i have that already. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much mate.
For sure, you are very welcome
Download
Hi, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
Wonderful Mr Randy this is what we were
Thank you so very much, I really appreciate that Waleed :)
Hi Randy thank soo much great video , how to we can integrate this POS app with mobile delivery manager excel for freelancer "ruclips.net/video/WRIBkgF61rc/видео.html" it is possible?
Hi Nelson, thanks so much. I do have a Mobile POS application you may be interested in here: ruclips.net/video/FMq9OYMviq8/видео.html
I hope this helps and thanks so much.
Thank you very much for your great apps as usual. But answer but after seeing the recommended app I don't see that it has the option to manage delivery integrated. assignment of the order to drivers, scheduling of delivery to the customer, digital signature to certify that the product was delivered to the customer. etc@@ExcelForFreelancers
Hi and thanks very much. The closest I have is the Mobile Delivery Manager here: ruclips.net/video/WRIBkgF61rc/видео.html
If you would like help with customizing any of these to your requirements please feel free to post a PAID JOB 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.
I hope this helps and thanks so much.