MartinLiss was really helpful to give me a code to get a form to pop up. After i closed the question, i realized one more thing. Here's the code:
Dim lngLastRow As Long
lngLastRow = Range("A65536").End(xlUp).Row
Range("A2:E" & lngLastRow).Select
On the columns A-E, I acutally do't want column C to show up on the form, how would i change the code to show columns A, B, D and E?