user input

  1. S

    UX design for times in Excel. How to "scroll" the times ?

    So I am working on user interface on one worksheet and not sure how to make time fields more user friendly. Right now it is just validation list in increment of 5 for minutes and separate field for hours, while I want a user to be able to select any time. E.g 22:47 or 3:21 And I am thinking...
  2. C

    Calculating MATCH row based on user input.

    I have a column of data in B from row 5 to 23 (see below). I want to accept user input in cell M25 and use that input to to select a MATCH row of data from my list below. For example, if the user inputs $74, the row number is 3. (greater than 70, less than 80) My column data is similar and...
  3. J

    User Input

    I want to make a Dashboard that uses a userform or something. I want the form to have dependent cells. For instance: I am writing a spreadsheet to track sporting events (football and basketball, etc) the sports are on 8 separate worksheets with tables that are to be populated automatically based...
  4. K

    VBA Code that resumes if no input is done after a certain period of time

    Hello, I am trying to create a decision/choice game on excel using VBA. When the user clicks on the "Start" button, the excel will display a hidden sheet with a riddle on it. On this sheet, the user is required to give a numerical answer in cell C5. I want the vba code to either continue...
  5. D

    Checking user input and copying/pasting it to another worksheet

    So, my second post is a 'sequel' to my previous post I have this user input, UserId.Text , that is being checked to see if it exists on a certain sheet. I have a sheet named Users, with columns ID(unique), Name and Sirname. And I have a sheet where all the 'events' should be stored. So you...
  6. M

    Retrieve last input from user

    Hi All, I am searching for a way to retrieve in Excel VBA 2 points when user had input new data in a worksheet: 1. how to retreive what user had input ? 2. how to retreive where (address or range) user did this input? Currently I use activecell but it's not right because when you valid your...
  7. K

    Keep User input column matched with dynamically adjusting column

    Hi all, I hope I am using the proper terminology in this post, and hope I can explain it well enough for you to understand. I have a tracking worksheet that pulls a list of names from another workbook (the source) if their status is considered "Current" (this status is found in a related...
  8. A

    inputting multiple lines

    Scenario: User presses button input box opens user pastes several lines of text text gets pasted in column A each line in different row. Do I use inputbox for this or userform? Managed to create inputbox but it only gives me one line Don't know uesrforms
  9. A

    Validate User Input Data - Confirm against known list

    I have a range of cells 10 columns wide by 16 rows tall... it is assigned the range name of: "USER_CHANNELS" The cells in this range are validated against a range called: "VAL_CHAN_NAME" If the user is typing in data... and they get something wrong... it stops them and forces them to...
  10. P

    Sending an email using outlook

    I am wanting to send an email from outlook. It is all user input. The email address can be found on sheet 1 cell D17 and the user entered message in cell H5. Can anyone help? If i havn't been clear please get in touch
  11. M

    VBA to call UserForm for user input for use in same code

    Depending on the situation the value for a certain variable can be pulled directly from the workbook. In other situations, it will be best to prompt the user to make a selection from values that are pulled from the workbook. I have created a UserForm that displays under the right conditions and...
  12. C

    Loop Macro until Userinput, continue if no input

    Hello! I can't figure out how to make a code loop until user input and continue if there is no input. I don't want to use Ctrl + Break, because I am interested in how many times the code ran and how long it took. Is there a way to have the code pause and basically ask the user to stop...
  13. K

    How to use variables in a Userform?

    <tbody> I have a spreadsheet with 1000+ rows of data, that I want to filter down based on two separate columns of values. I know I can do this using the AutoFilter option, but I am trying to do this using an Excel VBA script which prompts the user for the values it wants to filter on...
  14. B

    Variable User Input - Either a Fixed Input or Cell Reference

    I would like to give a user the option of either inputting a fixed number or making reference to another worksheet, but all within one cell if possible. Therefore, it would be a decision first (do you want to input: 1) a fixed number or 2) utilize a reference to another worksheet that contains...
  15. T

    User input in a column, and creating option to select how many rows it will populate

    Hello Community, I am seeking the advice of any advanced users in my attempt to create an efficient user input, data entry form for the creation of table metadata. Scenario I am looking to design my sheet/Macro with the top two rows as user inputs, which will then paste these into a table...
  16. T

    Macro that allows user to set a sort range and then executes the sort

    I'm attempting to create a macro that will allow a user to set the sort range, field sort parameters, and then perform the sort. I'm able to have the macro bring up an excel input box (I copied an example from a John Walkenbach book) and have the user select the sort range but after that I'm...
  17. D

    VBA populate list using user input range

    So, i'm new to using VBA but have managed to get a few things done through online help etc. but i'm now trying to build my own macro instead of editing and adding to an existing example. basically i'm tryign to create a hypothetical summary of a company's stores' sales for the day. I want the...
  18. M

    User input controlled data

    Hi, I am not sure if this is possible but I think if it is I might have to use VBA! Due to my lack of knowledge this will be a learning curve :eeek: This is what I am hoping is possible. When you enter a number into cell A1 it automatically fills out data below depending on the value. For...
  19. E

    Create Button That Prompts User To Select Active Cell

    Hello, I have a macro that uses the active cell to sort through data and fill the acceptable data into three new columns. I wanted to see if someone could help me create a button that prompts the user to select the active cell and then runs through my macro code. This would be very helpful in...
  20. M

    Macro allowing user input to auto filter on pivot table

    Hello all. I have scratching beneath the surface of Excel for a little while now, but I'm finally stumped and hope to find some help here from someone with a little more knowledge... I am trying to write a macro that prompts the user to change the date range in a pivot table report. My current...

Some videos you may like

This Week's Hot Topics

Top