Nice video! Is there a video where I can type on the userform something like the name and with a "load" button it louds all the other informations in a way a can edit them to fix any mistake? Thanks!
Hey sir, Thanx for all this tutorials I want coding for a "textbox in a userform" named as OUTPUT which provides combined data with separater like ", or / " of all the above "textboxes and combobox of same userform" and then by clicking on command button "DONE"....it will paste the output item in excel. Please sir provide a solution for it...
Hi Danial, Hope this is what your name is spelt. I watched your video on Userforms today and I am wanting to develop one for the game that we play. You asked then (5 years Ago ) for input into what we were trying to accomplish. Are you still up for this. Andrew
Inventory Calculator, but cannot make coding for precentega-textbox to work! Hi i have made a inventory calculator for my personal use and i am 95% done. Its the precentage textbox that is left and i cannot do the coding. I have 5 boxes(textbox1) with 20 canes of beans in each box, and when i press the commandbutton to take away one cane of beans i want to see how big procentage is left in the inventory( in textbox2) So in my calculator i write in commandbutton1-> val(textbox1) = 5 (boxes) but in textbox2 ( the precentage) val(textbox.1)x20/val(textbox1)x20.=100% So when i press the command button to take away one can of beans= Val(textbox1)*19/Val(textbox1)x20=95% How do i do the Coding?? so i can se the result in textbox2 in the commandbutton? PLS help!! As well how do i do a reset button so the number of cans return to 20?
Thank you for sharing 👍 I need your help please. I have a workbook with a multiple worksheets which have external links and formulas. I need to Split the work sheets and sent to various recipients with other documents eg, one work book has c30 worksheets named as 1,2,3.4.5.6....30. And I need to send sheets 1&2 as one workbook to one recipient via mail and 2,3&:7 sheets as one workbook to another mail recipient and so on. And also I need to attach another document with these workbook as well before I mail to the relevant recipients every month. Could you please kindly post a video to automate this process via VBA solution on you channel please . It’s very urgent. Thank you so much!
Number one, make sure you use Option Explicit. Number two, you have to declare x as an Integer for this to run. This example, in the previous video and this one (perhaps this is an Excel 365 thing)...you have to do that or it'll choke on the code. Here's the code I used when adding the Next button: Private Sub btnNext_Click() Dim x As Integer
Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") x = Me.lblRow
x = x + 1 'next row number
UserForm1.tbName = Cells(x, 1) UserForm1.tbColor = Cells(x, 2) UserForm1.cbIsParent = Cells(x, 3) UserForm1.lblRow = x Hope this helps. I've personally learned so much from these videos, thanks so much for posting them!
Thank you, mate. Love all your tutorials
Amazin work bro thank you so much tthis is what i burn the google search weel !! for
Awesome, thanks so much for posting this!
Nice! Hey I've been watching your for 3 years now. It actually helped me in the Army and now I'm pursuing a CS degree.
What the WHAT?! DUDE!!!! You just made my day. Probably week.
Thank you and God Bless you for letting me know!
Can we uses this form with if cundition to show just expiry data withen 6 month and what about evants that run it autumatic every hour for exxamble ?
Cool video! Thanks !
ExcelIsFun - you sir are a True inspiration. Thanks for being the freaking MAN!!!!!!!! We all love ya man! Blessings!
You da VBA MAn, man : ) !!!!!!!
Nice video!
Is there a video where I can type on the userform something like the name and with a "load" button it louds all the other informations in a way a can edit them to fix any mistake?
Thanks!
Thank you so mutch.
How to make a previous button through Macro in MS EXCLE
Very nice Thank you. Could you please show as how to capture hours into userform and specialy 6:00 AM and 12:00 PM? Thank you in advance !
Hey Don, I get debug for following : x = x + 1 ' next row number, solution?
Really nice! Thanks for sharing! :)
Thanks, Maciej! Glad you like!!
Hey sir,
Thanx for all this tutorials
I want coding for a "textbox in a userform" named as OUTPUT which provides combined data with separater like ", or / " of all the above "textboxes and combobox of same userform" and then by clicking on command button "DONE"....it will paste the output item in excel.
Please sir provide a solution for it...
Hi Danial, Hope this is what your name is spelt. I watched your video on Userforms today and I am wanting to develop one for the game that we play. You asked then (5 years Ago ) for input into what we were trying to accomplish. Are you still up for this. Andrew
Why you restrict acces to download the file????
Inventory Calculator, but cannot make coding for precentega-textbox to work!
Hi i have made a inventory calculator for my personal use and i am 95% done. Its the precentage textbox that is left and i cannot do the coding.
I have 5 boxes(textbox1) with 20 canes of beans in each box, and when i press the commandbutton to take away one cane of beans i want to see how big procentage is left in the inventory( in textbox2)
So in my calculator i write in commandbutton1-> val(textbox1) = 5 (boxes) but in textbox2 ( the precentage) val(textbox.1)x20/val(textbox1)x20.=100% So when i press the command button to take away one can of beans= Val(textbox1)*19/Val(textbox1)x20=95% How do i do the Coding?? so i can se the result in textbox2 in the commandbutton? PLS help!!
As well how do i do a reset button so the number of cans return to 20?
Note:- I have facing a problem when I run the code is showing error in loading DLL. Pls help
Pls confirm how can I correct the problem
Thanks Nice one!!!
Thanks Rajesh!
Thank you for sharing 👍 I need your help please. I have a workbook with a multiple worksheets which have external links and formulas. I need to Split the work sheets and sent to various recipients with other documents eg, one work book has c30 worksheets named as 1,2,3.4.5.6....30. And I need to send sheets 1&2 as one workbook to one recipient via mail and 2,3&:7 sheets as one workbook to another mail recipient and so on. And also I need to attach another document with these workbook as well before I mail to the relevant recipients every month. Could you please kindly post a video to automate this process via VBA solution on you channel please . It’s very urgent. Thank you so much!
Hello , pls can you make video on the below
Number one, make sure you use Option Explicit. Number two, you have to declare x as an Integer for this to run. This example, in the previous video and this one (perhaps this is an Excel 365 thing)...you have to do that or it'll choke on the code. Here's the code I used when adding the Next button:
Private Sub btnNext_Click()
Dim x As Integer
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("Sheet1")
x = Me.lblRow
x = x + 1 'next row number
UserForm1.tbName = Cells(x, 1)
UserForm1.tbColor = Cells(x, 2)
UserForm1.cbIsParent = Cells(x, 3)
UserForm1.lblRow = x
Hope this helps. I've personally learned so much from these videos, thanks so much for posting them!
Hi
Nice! Hey I've been watching your for 3 years now. It actually helped me in the Army and now I'm pursuing a CS degree.