Macro to create User input window with 10 fields

Hi guys,

I am rewriting an old project that I have, and I need to write a macro that will ask the user to insert 10 things to be stocked in 10 variables in the code. Will also need to check if the information stored exists in one column in the spreadsheet.

Recap:

-User inputs 10 fields in a window
-Macro stores 10 fields in 10 variables
-Macro checks each fields to make sure the data exists in one column and tells the user which field is wrong.

Any help would be much appreciated. The code as it is works, but I have to rename a bunch of things each time I use another spreadsheet.

Many thanks!

Originally Posted by royUK

You need to create a UserForm, check out this example

Thanks, was looking yesterday a bit into user forms, need to get my kung fu on the playing field for those! Thanks for the reply!