Allow data Entry into Excel Worksheet Via User Form Only

How to Allow data Entry into an Excel Worksheet Via User-Form or Macro Only.
Here's the complete VBA code:
Option Explicit
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdTransfer_Click()
Dim erow As Long
erow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Cells(erow, 1) = txtCustomerName
Cells(erow, 2) = txtMobile
End Sub
Private Sub Workbook_Open()
ActiveWorkbook.Sheets("Sheet1").Protect Password:="macr0@entrY", userinterfaceonly:=True
UserForm1.Show
End Sub
Private Sub cmdDisplayUserForm_Click()
UserForm1.Show
End Sub
Further Reading: www.exceltrain...

[@konsamprincesingh7763]

This was really a wonderful tutorial. I am not an expert on excel and VBA. But as a finance officer i keep making excel based VBA userforms and other related data management system for my office which makes my work more efficient and easier to maintain. But the issue was my data are always open for anyone to manipulate or make wrong entry by me by mistake. So looking for a way to lock. Thank you so much you made my day. I am going to subscribe now.

[@Jojosmith342]

Dinesh is the GREATEST teacher of VBA. Thank you so much for your hard work and the valuable lessons. Liked & definately subscribed ! Looking forward to more tutorials

[@AFRICANENERGY-p2k]

thank you sir i got what i was searching all the time

[@ramanathwal5767]

I learned so much from your video. It was exactly what I needed. Thank You!

[@Exceltrainingvideos]

Glad it was helpful!

[@barderians]

Thank you Dr. Am confident in you more.

[@Exceltrainingvideos]

All the best

[@Mark_Lacey]

Great video, exactly what I was looking for. Thank you Dinesh.

[@Exceltrainingvideos]

Glad it was helpful! Please share with your friends too.

[@tomkochka2058]

This was excellent. Exactly what I was looking for. Thank you!

[@Exceltrainingvideos]

Glad it was helpful!

[@Victor-ol1lo]

Great video Dinesh ! Thumbs Up !

[@Exceltrainingvideos]

Please share with your buddies too.

[@javedahmed8343]

Nice explanation

[@Exceltrainingvideos]

Thanks for liking.

[@hassantaha3116]

Yes sir you have alot of amazing videos. Appreciate your efforts

[@Exceltrainingvideos]

Thanks. Please share with your buddies too.

[@Rajan-kk8nl]

Thank you very much sir...

[@Exceltrainingvideos]

So nice of you

[@azhadshamim3122]

Excellent very Excellent

[@Exceltrainingvideos]

Thank you so much 😀Please share my channel on Excel with your friends.

[@azhadshamim3122]

@@Exceltrainingvideos inshallah

[@thomaslau5993]

Hi Dinesh I think your videos are amazing. Could you upload a video on how to capture username via userform for any editing or entry of records

[@Exceltrainingvideos]

The following VBA tutorial in Excel will help: www.exceltrainingvideos.com/advanced-user-form/ Or search www.exceltrainingvideos.com - there should be at least 20 videos on this topic.

[@muychamnan9993]

Wow! It is amazing video. I love it.

[@Exceltrainingvideos]

Please share with your buddies too.

[@azhadshamim3122]

Hi sir Greetings from heart Thank you so much for this code which allow only the userform to entery Which is completely offline software Thank you so much

[@Exceltrainingvideos]

God bless! Please share my KZbin channel on Excel VBA with your friends.

[@smug8567]

The way to count text is: =COUNTA(C8:C98). So if you want to know how many names you got for instance in Columns C8 through C98 then you could have this at cell at the top and it woud give you the number of people, etc.

[@Exceltrainingvideos]

Of course, you can.

[@dailytechwithsalman5153]

thank u sooo much

[@hassantaha3116]

Mr. Dinesh, Could you please make video for salaries comparing ( current & previous). This vedios will make my work easier. Sincerely,

[@Exceltrainingvideos]

Can you describe the task in greater detail?

[@hassantaha3116]

@@Exceltrainingvideos Yes sure, I have big two payroll tables (current month & previous month). May these tables have some of similar columns and other different. Example: Table A has columns of (names - basic salary - allowances - other deductions) Table B has columns of (names - basic salary - allowances - other deductions - penalties) I need to create a table of differences (exceptions) for every columns and what is the unique column. Sincerely,

[@Exceltrainingvideos]

This link will guide: www.exceltrainingvideos.com/compare-2-worksheets-to-create-report/

[@shahrukhshahid4134]

sir i enter data from column K2 to X2 and rows 2 to 201, now in column A1 i have reviewer name and B1 is current Date. now what i want do is whenever i put any data in K2, K3, K4, and so on my name and date get fetch automatically in column A and B respectively so sir can please help me with the code.....

[@Exceltrainingvideos]

This Excel VBA tutorial will help: www.exceltrainingvideos.com/search-multiple-values-in-worksheet-data/

[@8-bitninja122]

What is the code for the userform when there are multiple sheets? I would like for it to work independently on each sheet.

[@Exceltrainingvideos]

The following VBA tutorials will help: www.exceltrainingvideos.com/transfer-data-from-user-form-to-multiple-worksheets-in-excel-workbook-using-vba/ www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/ Fore more VBA ideas related to your Excel topic: www.exceltrainingvideos.com

[@seemoonhabeeb1478]

Hello, frankly, I have a problem with security.. When I put a password for a worksheet in Excel, and when I share with another computer on the network, a problem occurs.. How can this problem be solved.. Thank you

[@charlesthamba4514]

Dear Sir There's any android app can read an excel vba file, even execute macro? If "yes", please I need. Thanks

[@Exceltrainingvideos]

No idea.

[@charlesthamba4514]

@@Exceltrainingvideos But in 2020 there should be one. 'Coz run macros on mobile should be very amazing and easy some tasks in management. Please if any information about this kind of app, share. Thanks for all your videos

[@viankaleighpatron5950]

Sir can you help me how to put hyperlink on textbox in userform?

[@Exceltrainingvideos]

Why do you keep on repeating your queries? I already sent you the code!

[@viankaleighpatron5950]

@@Exceltrainingvideos sorry sir, maay i know sir where you send it?

[@markpollock8586]

Mines not going to the next line, it's just overwriting the same line with the new data

[@madhuraj8169]

Hello sir, how can we find month first and last working days by using vba. please help me sir

[@Exceltrainingvideos]

Yes. We can use the worksheet-function 'NetworkDays'.

[@viankaleighpatron5950]

It gives me compile error what must be the problem?

[@Exceltrainingvideos]

The problem is right in front of the computer. Check your code.

[@gmcomputercenter5890]

sir i want delete excel sheet on vba between sheet1:sheet10 delete only between sheets plese help me

[@Exceltrainingvideos]

You can run a looping process like so: Sub DeleteSheets() Dim s As Worksheet, t As String Dim i As Long For i = 10 To 1 Step -1 t = Sheets(i).Name If t = "Sheet1" Or t = "Sheet5" Then Application.DisplayAlerts = False Sheets(i).Delete Application.DisplayAlerts = True End If Next i End Sub

[@shahrukhshahid4134]

Sir please help

[@Exceltrainingvideos]

Check below.