Using a form with Excel

Hello, can anyone help? I have created a input form in visual basic, i am trying to do two things that are making me pull my hair out! if anyone can help i would be very greatful. 1) i am trying to restrict the text box so that only a value between 1 and 4 can be entered. 2) once all the data has been added i am trying to get a macro to put these values in the correct place on a Excel spreadsheet (these spaces are cell dependent and have to be in the correct place for the program to work) again, i would be very greatful to anyone who can help. Thank you, Robert Couchman

Loader.
Up arrow icon