I have an order form that I have created on an Excel spreadsheet and
would like to insert some code that would have a window pop up to
prompt the user for their name, address and voicemail box #. I would
like the pop up to occur each time the document is opened. I am not
very familiar with VB but I found this code (see below- I already
modified it for my document- cell reference, and text) but don't know
where to put it in the script and how to set it up so that it runs each
time the form gets opened. Also not sure as to where to put the < >
symbols.

Sub getvalue()
Range("B3").Value = InputBox("Enter your Name")
Next
Range("D3").Value = InputBox("Enter your Shipping Address")
Next
Range("H3").Value = InputBox("Enter your Voicemail Box #")
End Sub

Additionally, if my Excel document already contains some data
validation lists will that create a problem and if so whats the best
way to fix it.

My knowledge on VB is pretty lacking...Any help would be greatly
appreciated!