I have a spreadsheet that uses numerous input variables which may start as a default value and then be changed based on the actual conditions. I have differentiated the input cells as a color to allow for them to be cleared, however, I find that on a sheet by sheet basis, it is easy to miss the inputs. I am trying to create a series of input wizards that allow for an orderly input of data. the program operates in VBA. The code does not run until the data is entered. Can someone point me to an input that allows the inputting of integers, dates, strings etc.

You can create a user form for every sheet, form that apears to user when selecting the sheet, like in picture attached.. But the best approach depends on the ammount of information that the user must enter. If there are just a few entries, it's easier to use application.inputbox.
You better upload a sample workbook, indicating what fields you need in every sheet, you will get faster answers...

Attached Images

1.jpg (43.5 KB, 6 views)