How do I force user to enter their ID# before filling other data?

  • Thread starter Thread starter Doc Pete
  • Start date Start date
D

Doc Pete

I am setting up a worksheet to help our staff calculate customer transaction
costs. I want to prevent the staff from entering any data into the worksheet
until they have entered their employee ID in the employee ID cell. In other
words, I want all other data entry cells to remain locked until the person
filling out the worksheet has typed in his or her employee ID.

Thank you for your help.
 
One way is to not allow ANY entries until entered. Right click sheet
tab>view code>insert this

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Range("a1") = "" Then
MsgBox "Enter ID in A1"
Target = ""
End If
Application.EnableEvents = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox-2 entires should select by Clicking Listbox-1 entires. How 2
Program a macro to print 1
Preventing incorrect data from being copied 8
fill in data that is not empty 1
VBA vlookup enter data into one textbox have another auto fill 0
Point me in the right direction 2
Referencing other worksheet data using a drop-down list 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0

Back
Top