pop up boxes to enter multiple info

[disley123]

Hi,
I was hoping that someone could give me the code for thefollowing.
I wanted a pop up box for users to fill in 4 columns ofinformation.
Col A would be “Date” B “Site” C “Tonnage” D “Reason” isthere a way that it will auto fill the newt row? So row 1 has the header titleso the info would need to be filled into the next available row each time.

Any help would be appreciated.

Kind regards

 

[Joe4]

Welcome to the Board!

Unless you want to write your VBA code to open 4 different Input Boxes, you would typically use a User Form for this type of data entry.
Therre are lots of tutorials on-line that can show you how to do this (just Google "Create a User Form in Excel).
Here is one: https://www.contextures.com/xlUserForm01.html