Python: List and Tuples
52:06
10 ай бұрын
VBA Double Quote in String
3:00
2 жыл бұрын
VBA String Manipulation
15:43
2 жыл бұрын
VBA Copy Table from another Workbook
8:07
VBA Copy Table to another Worksheet
3:24
VBA For Loop Table
3:04
2 жыл бұрын
UiPath - Invoke Code Activity
4:46
2 жыл бұрын
UiPath - Invoke Method Activity
5:02
VBA Format Cells
8:11
2 жыл бұрын
Get Table Last Row using VBA
2:50
2 жыл бұрын
Пікірлер
@AjayGupta-q1d
@AjayGupta-q1d 4 күн бұрын
Your video helps me a lot to develop this RE-Framework Assignment. In this video all the steps explained in proper manner which gives the clear understanding of RE-Framework. Thanks!
@georgemathew860
@georgemathew860 10 күн бұрын
Good example
@CletusBewaale
@CletusBewaale 13 күн бұрын
Interested in the system, please..... I have been following you for a long
@SoneXayPanya
@SoneXayPanya 20 күн бұрын
THANK YOU FROM LAOS
@jonnathanjon1
@jonnathanjon1 24 күн бұрын
Is Index(match ) faster than using For loop with array for search? Which is faster? I cant decide on this.. btw great video
@alesitomais4666
@alesitomais4666 Ай бұрын
Like 15 ads per video, it seems he wants to make more money than help.
@amylee1877
@amylee1877 Ай бұрын
Hello, Thanks for the explanations. The link doesn't work on my side. Is it still available? Thanks
@gecheung1155
@gecheung1155 Ай бұрын
Hello , love your code, but seem to run into a problem now then selenium couldn’t support chrome version 128, how can I resolve this, many thanks
@anasboussib7590
@anasboussib7590 Ай бұрын
hello i tried to make a macro like that one but it doesn"t work could you help to understand the problem and create a solution, i tried a lot of methods
@KR-zk2yh
@KR-zk2yh 2 ай бұрын
SIMPLE AND COMPLETE. THANKS
@KR-zk2yh
@KR-zk2yh 2 ай бұрын
Thanks!
@mrfusion3000
@mrfusion3000 2 ай бұрын
If you copy the out_YearlyReportPath from the description text above, remember to change the quotation marks from “ ” to " ".
@shantipurgulmi2592
@shantipurgulmi2592 2 ай бұрын
Sir please provide a soft copy
@iggyboyTV
@iggyboyTV 2 ай бұрын
very nice,it a big help for me
@marutimali8410
@marutimali8410 3 ай бұрын
Really, thanks to your thorough video, I was able to finish this project by following every step. I sincerely appreciate it.
@marutimali8410
@marutimali8410 3 ай бұрын
Kindly produce a video about the End to End project.
@kaaleechary9439
@kaaleechary9439 3 ай бұрын
Hello how do I randomize the questions at every reset use?
@truman7502
@truman7502 3 ай бұрын
Hello po. How can we contact you po via facebook?
@LoveCodingAndPlay
@LoveCodingAndPlay 3 ай бұрын
wlaa po akong fb eh , email po [email protected]
@Waveandsmileable
@Waveandsmileable 3 ай бұрын
Hello, thanks alot for your video! Could you please help: what if we need to copy only new data from another book - only for the columns with the same names? Thank you
@ilayaraja9169
@ilayaraja9169 3 ай бұрын
Sir, when open the following error arrived
@mohamedawadsalem1941
@mohamedawadsalem1941 3 ай бұрын
39:02
@LilyanaUzunova
@LilyanaUzunova 4 ай бұрын
That was clear and simple !! Thank you - wish I had watched it earlier, before spending 1hr to try to figure out what MethodNames I could use for a list of strings !
@MunugalaUmaShankarRao
@MunugalaUmaShankarRao 4 ай бұрын
HI i was not able to find get credntail sequence in hash key genetrator can you help that how to do
@DoersGen
@DoersGen 4 ай бұрын
Loved it...Clear explanations and we all end up with a working tool that can be tweaked to our requirements with the new found knowledge from this tutorial..THANK YOU
@sharadpatel07
@sharadpatel07 4 ай бұрын
i have to create multiple sheet from master sheet data file ,fatching specific data & paste in specific form in multiple sheet can it possible ???
@peteremmanuelololade9184
@peteremmanuelololade9184 4 ай бұрын
Thanks for the class but pls can you help create time base quiz and subject selction base quit too.thatnks
@binumathew721
@binumathew721 4 ай бұрын
Very good tutorial
@leonardoalleruzzo5994
@leonardoalleruzzo5994 4 ай бұрын
{"January","February","March","April","May","June","July","August","September","October","November","December"}
@Harsha-ou8qe
@Harsha-ou8qe 4 ай бұрын
Sir i tried 7 times but i did not able to compleat the module please help me sir.
@IPV-252
@IPV-252 5 ай бұрын
*Help ⚠️⚠️:Please reply to me 🙏🏻 🙏🏻 🙏 🙏🏻 😭* Make a video on "How to Generate/Prepare Annual Report - Upload" Please reply to me 🙏🏻 Did you Complete the "Yearly Report " ???? How to complete this task ???? Please give me some short cuts about it🙏🙏🙏 *My Assignment is still pending 😞🙏🏻*
@IPV-252
@IPV-252 5 ай бұрын
@WonderStudies *Help ⚠️⚠️:Please reply to me 🙏🏻 🙏🏻 🙏 🙏🏻 😭* Make a video on "How to Generate/Prepare Annual Report - Upload" Please reply to me 🙏🏻 Did you Complete the "Yearly Report " ???? How to complete this task ???? Please give me some short cuts about it🙏🙏🙏 *My Assignment is still pending 😞🙏🏻*
@DSX229
@DSX229 5 ай бұрын
Hey i do not want to add price to my items but i cannot add them without price
@rexbenemerito1943
@rexbenemerito1943 5 ай бұрын
Very well presented. This is the first of the tutorial that explained array in an uncomplicated way. Thanks very much. Can you make a Search Module tutorial using UserForm with multiple condition and output the result in a listbox. An example application system for tracking employee training where a company has more than 20 types of health & safety training. 1st search condition is employee lastname or employee ID, 2nd condition is training description and 3rd search is status of certification (expired: soon to expire:active). Hope you can provide some guidance. Thanks a lot.
@ModestHustler
@ModestHustler 5 ай бұрын
:]
@harshababu8321
@harshababu8321 5 ай бұрын
Maraming Salamat Po
@AbdulrahmanAlz
@AbdulrahmanAlz 5 ай бұрын
Which is good explain but I can’t open the link to get the copy and thank you
@mahinaiksmpbolthey1432
@mahinaiksmpbolthey1432 5 ай бұрын
Hii bro after running the project its loading again and again of work item pages continuesly first its loading 14 pages then again its loading all the pages like 14 times its loading i dont know the reason y its loading again and again i have follewed ur guidline but its loading
@generalspidrax9699
@generalspidrax9699 6 ай бұрын
This only works if my data workbook is already open before running the code. If the workbook I'm reading from is closed, attempting to open it results in most of my code being skipped over and ignored. I'm attempting to write a single string into a label on a userform, but when the data file is opened VBA just skips straight to the Show command, so nothing is read or written.
@mah77889
@mah77889 6 ай бұрын
Thanks it really useful
@azharkhanlangah
@azharkhanlangah 6 ай бұрын
can i use your video?
@LoveCodingAndPlay
@LoveCodingAndPlay 6 ай бұрын
Sure
@azharkhanlangah
@azharkhanlangah 6 ай бұрын
@@LoveCodingAndPlay Thank you So Much! You are great
@azharkhanlangah
@azharkhanlangah 6 ай бұрын
Superb, 💝💝💝💕💞💞💞💕
@tapasranjan5956
@tapasranjan5956 6 ай бұрын
can i use this project for my final year project
@diegorigl
@diegorigl 6 ай бұрын
Thanks for your tutorial well explain, just wondering how I can do the same but choosing a referent name first, show me the list linked to that referent name them made all changes need it, and if that referent name don't exist, add a new one to the list, please I can access to the download file!!
@shailendrasajwan3
@shailendrasajwan3 6 ай бұрын
can you do using Modern design studio
@elricho72
@elricho72 6 ай бұрын
Thanks for your videos, do you have an example of how to interact when the combos are loaded dynamically, or when you open a link but you have to wait for it to finish loading so that the code works correctly, I still haven't found a way to interact with those events and depending on what Sometimes it works and sometimes it doesn't.
@KetoprakMatcha
@KetoprakMatcha 6 ай бұрын
in section "Get Transaction Data Workflow" , how to solve, my io_dt_TransactionData value = null after debug, i was follow the instruction and i was check my scrapping data / table extraction it's not problem. argumen out_TransactionData can move the value to io_dt_TransactionData.. Someone can help? Thanks....
@deniskoech2636
@deniskoech2636 6 ай бұрын
Thank you . A good solution. However, how about when you have one match and multiple searches. Meaning the lookup value can be repeated each with different amounts . As it is now, it returns the first item in the loop( just as is the case with VLOOKUP) .
@TharakaMadushanka
@TharakaMadushanka 7 ай бұрын
Thanks for providing this valuable content. Even after two years, it is still helpful to us. Thanks for your commitment & consideration. Love from Sri Lanka ❤✨.
@gromajor
@gromajor 7 ай бұрын
nice. 👍 the only thing I miss is to see how to call such a form from within a macro, but that was quite a lot of help. merci. 🙂🙂
@LesibaMaphoso-j6d
@LesibaMaphoso-j6d 8 ай бұрын
What a good presentation. I followed you and everything is working well except that Score does not increase in userform. The score is always zero. Where did I missed it? Option Explicit Private btnClicked As String Private questionNo As Integer Private question As String, code As String, a As String, b As String Private c As String, d As String, answer As String Private score As Integer Private Sub cmdA_Click() btnClicked = "Answer : A" cmdA.BackColor = &HC000& cmdB.BackColor = &HC0FFFF cmdC.BackColor = &HC0FFFF cmdD.BackColor = &HC0FFFF End Sub Private Sub cmdB_Click() btnClicked = "Answer : B" cmdA.BackColor = &HC0FFFF cmdB.BackColor = &HC000& cmdC.BackColor = &HC0FFFF cmdD.BackColor = &HC0FFFF End Sub Private Sub cmdC_Click() btnClicked = "Answer : C" cmdA.BackColor = &HC0FFFF cmdB.BackColor = &HC0FFFF cmdC.BackColor = &HC000& cmdD.BackColor = &HC0FFFF End Sub Private Sub cmdD_Click() btnClicked = "Answer : D" cmdA.BackColor = &HC0FFFF cmdB.BackColor = &HC0FFFF cmdC.BackColor = &HC0FFFF cmdD.BackColor = &HC000& End Sub Sub resetButtonColor_Click() cmdA.BackColor = &HC0FFFF cmdB.BackColor = &HC0FFFF cmdC.BackColor = &HC0FFFF cmdD.BackColor = &HC0FFFF End Sub Private Sub cmdSubmit_Click() If cmdA.BackColor = &HC000& Or cmdB.BackColor = &HC000& Or _ cmdC.BackColor = &HC000& Or cmdD.BackColor = &HC000& Then 'Validate if the answer is correct If btnClicked = answer Then score = score + 1 End If questionNo = questionNo + 1 If cmdSubmit.Caption = "End Exam" Then 'Save the record Dim nRow As Integer nRow = rSH.Range("A" & Rows.Count).End(xlUp).row + 1 rSH.Range("A" & nRow).Value = username rSH.Range("B" & nRow).Value = Now rSH.Range("C" & nRow).Value = score ' Debugging: Display the value of score MsgBox "Score: " & score frm_score.lblName.Caption = username frm_score.lblScore.Caption = score frm_score.Show Unload Me Else 'Get the next quiz item Call getQuiz lblQuestionNo.Caption = "Question " & questionNo & " of 10" End If Else MsgBox "Please select an answer", vbCritical, mTitle End If End Sub Private Sub UserForm_Initialize() Call init_SH questionNo = 1 score = 0 ' Initialize the score variable Call getQuiz End Sub Sub getQuiz() ' Simulate a button click event on the resetButtonColor button Call resetButtonColor_Click Dim row As Integer row = questionNo + 1 ' Retrieve data from worksheet question = qSH.Range("A" & row).Value code = qSH.Range("B" & row).Value a = qSH.Range("C" & row).Value b = qSH.Range("D" & row).Value c = qSH.Range("E" & row).Value d = qSH.Range("F" & row).Value answer = qSH.Range("G" & row).Value ' Assign values to controls txtQuestion.Value = question txtSampleCode.Value = code cmdA.Caption = a cmdB.Caption = b cmdC.Caption = c cmdD.Caption = d ' Validate question Number If questionNo = 10 Then cmdSubmit.Caption = "End Exam" End If End Sub