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.

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!

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 !

Cool video! Thanks !

Amazin work bro thank you so much tthis is what i burn the google search weel !! for

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...

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 ?

Hey Don, I get debug for following : x = x + 1 ' next row number, solution?

Really nice! Thanks for sharing! :)

How to make a previous button through Macro in MS EXCLE

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

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

Thank you so mutch.

Thanks Nice one!!!

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?

Why you restrict acces to download the file????

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!

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.