Happy New Year to you as well. Thank you for all the information you have shared.

Thank you very very very mutch

Hi Sir, Thanks for Such Information... the videos are too Good. And I have an issue with writing a code for one macro, Mentioning below. Please help me to write it. I have 2 Sheets in a Workbook. And In Sheet 1 Column J from row 2 to End row For Every Cell it has to match the Value in Sheet 2 Column A and if it's Matching then the Value of Column B from Sheet 2 has to Copy and paste it in Sheet 1 next to the value. it has to loop till the End Row value in that Column.

good year Mr DINESH

Sir your tutorial is good regarding conditional work and please tell me how i get "text in uppercase" when I type in textbox area

Sir what is the difference b/w 1. Textbox.text vs Textbox.value 2. A= Textbox.value vs a= me.Textbox.value

Sir i have some issues on some other questions, bit similar to this video. Adding data with user form in sheet1 everything goes fine, i want to add the data of sheet1 in sheet2 with different formate using vlookup. But i could not get the data of sheet1 even after using lookup value in sheet2. I could get the data visible in sheet 2 only after double clicking the sheet1 cell (value of lookup) that i want to add in sheet2. It happens only if i enter the data from the userform. I have to go on double clicking the cell (value of lookup) in sheet1 to be visible in sheet2. Please solve my proble sir. I wanted to get it solve without double clicking. For this issue, I am working with new Admission user form in sheet1 & data gets submitted in sheet1 itself. Next in sheet2, i made admission receipt for which i want to print the data in different formate n style using vlookup function. Even after entering the lookup value in sheet2 data doesnot get visible, i have to go back to sheet1 and double click the cell of lookup value, only after double clicking data gets visible in sheet2. Hope you Understood my problem sir.

Sir your userform video is very good regarding for excel work and please can you give link for download about this vba file for practice.

Thanks sir for all the informations. Please sir can we do with VBA a date reminder Which run automatically the excel workbook when the date was expired thanks

Dear Sir, I need to learn how to insert image in the cell by using this data entry form. Currently I have a project i dont know how can i do it.. sir please help

Thank you for all your videos. I have learnt so much. I wonder if you can help me with something. I have a data sheet where I make multiple entries for my students. One student can have multiple entries e.g. behaviour, fees, reward, absence etc. I need help creatung a report sheet where I want to be able to click on a particular student's name from a drop down list and all entries made for that student should come up. Can you please kindly help me with this. Thank you in advance.

PLs sir how do you add photo to user form in excel 2007 van. Thanks

Good work. sir How can qty sale same form.

very clear explaination but i still get error on vlookup function." it says " unable to get vlookup property of the worksheet function class" ..please help

Hello Sir Nice Work but i have one Error Private Sub cmdClear_Click() For i = 1 To 6 Me.frmCustomer("tb" & 1) = "" Next ( compile error: method or data member not found ) How I solve This Problem i Try this Code But Not Working ( On Error Resume Next) Same

Hello sir... i used the below code and this is getting highlighted and there is and error 424 saying Object required.. If WorksheetFunction.CountIf(Sheet24.Range("A:A"), "me.Reg1.Value") = 0 Then MsgBox "Please enter the correct Project Number" Me.Reg1.Value = "" Exit Sub End If please help