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!
Bookmarks