• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pop up data entry box

I

iceblocks

Member
Hi,
Is there a short macro that enable a box to pop up every time a worksheet is open (the workbook has several other worksheets as well) and ask users to enter their ID number. Then that id number is entered at cell say C2 of the active sheet to enable calculation.

Many thanks.
 
Hi Iceblocks

Something simple like this but you are gonna need to build some error trapping in.

Code: 
Sub IDPal()
Dim ans As String
ans = InputBox("Your ID mate?")
[c2] = ans
End Sub

Take care

Smallman
 
You must log in or register to reply here.
Back
Top