userinput

Hello guys, I have a form where it will display the random questions from "Questions" Sheet to the User. User will Select the Answer in the Form. I Need to Save all those Random Questions (as of now its 10) and Answer which User attend, Save it in "Answer" Sheet. Can you please Help on this...

I have a workbook with different worksheets. As these have different orientations you can't simply select and print them, as the page orientation is the same on all of them as on the first page. Now I would like to create a macro with which I can print the selected pages (which are not always...

Hallo, Tried to use the below code from the book on page 136 but it doesn't work. I use excel 2010. Private Sub Worksheet_Change(ByVal Target As Range)Dim ThisColumn As Integer Dim UserInput As String, NewInput As String ThisColumn = Target.Column If ThisColumn < 3 Then If Target.Count > 1...

Hi Excel-masters, I am new to this forum, and I read the rules, but please inform me when I'm not abiding to those rules. Also, I looked into the forum for previous, related questions, but couldn't find one. But if I missed a thread that's already answering my question, please excuse me. So...

I am trying to design an excel spreadsheet which can do this First: A pop up box for user to enter a long sequence of 2-digit numbers. Each number has a code assigned to it. I have already finished this conversion using VLookUp. Then, the program will pick the second input number, known as...

Greetings, **What code does:** I have a code that reads the files in a folder, prints the names in the active workbook, and then puts the names in ascending order. **Obs1:** I have follow up codes that use this information for calculations, but this part is not relevant to the current...

Hi, I am trying to create a MACRO that based off two different times that the user inputs into a message box will automatically create a thick bold border. For example: <tbody> Line Time Name Age Destination 1 9:15 Chris 21 NV 2 10:15 Janet 22 NY 3 11:15 Lura 34 CA 4 12:15 Matt 52 CO...

Hi, I,m trying to allow a user to input a year (between 2004-2012), each of which will be stored into an array. Since I don't know how many years the user will choose I'm required to use a dynamic array. For some reason when I run the code below it takes a valid input but then exits the loop...