Macro startup user entry

[Peanuts890]

I'm writing a macro to transfer data from one worksheet to another worksheet based on four search criteria. On initial startup of the macro, is it possible to display a small form (like the message box) where the user is prompted to enter two integers and two dates.

 

[Trevor G]

look to create a userform in the VBA screen then add the 4 textbox with labels and then set the command when the workbook opens it opens the form. Add a command button to the form to function what ever it is you want to happen when they have completed the form text fields.

 

[Peanuts890]

Thanks Trevor you are a star for pointing me in the right direction, should be able to do this using the VBA help.