user input

  1. S

    AutoFilter Based on User Input Selection

    Hi All I am trying to write a macro the autofilters based on the user's selection. Here is an example. Column A Column B Row 1 Snacks SN1 Row 2 Snacks SN2 Row 3 Clothes CL1 Row 4 Clothes CL2 Row 5 Drinks DR1 Row 6 Drinks DR2 The user would run the...
  2. E

    data validation list question

    I have been using cascading data validation lists to standardize user inputs on a form we have at work. Sometimes, the input is a custom item that is not included in the predetermined table of items that the data validation looks up. I would like to allow the user to input whatever custom item...
  3. S

    Excel cannot read user input through drop-down list as a Hijri date!

    Respected Members, First of all, I want to thank everyone contributed to this forum. So much I learned for you! Hope you can help me on below issue I searched on the net and here in the forum and found several suggested solutions. Yet, none of it worked for me! When I use function today()...
  4. B

    Varied file loaction links

    I would like to set up a spreadsheet that has links to other documents. I know how to create links, but I would like a link which contains a document location which can vary with a cell contents. for exam if the file names were Report wk42, report wk43, report wk44 etc. and the cell I wanted a...
  5. jcoleman25

    Adding User Input to a collection (path of folder they want to search), then looping through each item with For-Each.

    I'm having a hard time getting this collection thing down. What I want this code to do is take the user input as a string and store it for use later when the For-Each code is run. I'm not having any luck so far and its probably because I'm having trouble wrapping my head around the concept...
  6. J

    Select cell during runtime and continue

    Hi - am developing a macro for users to use and need help refining one part of it. Essentially, the user selects a cell, then clicks a button to run a macro. This is the "From" cell. The macro then needs a "To" cell address to be able to complete. I have got it working using the following code...
  7. D

    Find and delete depending on answer to msgbox then continue loop

    Hello, I am trying to build a macro that will search a column for the word "TEST" and when it finds that word it needs to prompt the user with a YesNo message box (or something similar) if they would like to delete the entire row that contains TEST. If Yes is selected, it should delete the row...
  8. G

    macro to print "x" pages based on user input

    Hello, I have form that prints 3 to a page. I need a macro that will allow the user to input how many pages to print and only print those with data in them. Sometimes there might be 2 or 5, etc... I was thinking that maybe using "case" might work? Thanks, Julie Form example: <TABLE...
  9. P

    Help with VBA to allow user input in to cell with formula

    Hi all, I'm trying to make a worksheet to help me size the parts for cabinet doors. I've made it functional but I was trying to make a bit faster to enter the data and this is where I got a little stumped. Every door has 2 Rails (horizontal pieces), 2 Stiles (vertical pieces) and one raised or...
  10. g_purve

    Challenge for the VB experts

    Hello, I am trying to re-lable the first column of data into sections, usually 60 sample increments, in order to post process all of the samples that are contained within the recorded section. So I have a worksheet with column showing test step = usually ranging from 0-10 and the data recorded...
  11. P

    Input Box

    I don't know much (anything, really) about VB, but I'm usually pretty good and finding relevant code online and adjusting it to my needs; but today, my brain is not cooperating. Please help :) I have a worksheet and in cell B2, there is a data validation list, allowing the user to select...
  12. R

    Newbie Help - VBA to hide rows based on user input

    I am a complete newbie when it comes to writing macros, but I was wondering if someone would be able to help me? I want to click on a button (I know how to assign a macro to a button) and have a macro run that asks me which row numbers to hide and then pop up a print dialog. Is this doable? I...
  13. R

    User Input Vs Static Value in DateDiff Criteria

    While I have been able to resolve just about everything through the genious guidance of the fine minds on this forum, I just cannot resolve, nor find a solution to this seemingly simple issue: I am trying to allow the user to specify the 'age' of a record to obtain a list of aged loans. I have...
  14. D

    User Input as Range XL2010

    Hello everyone -- I am new to VBA (four days now) and have put together a relatively simple macro that creates a pivot table. I have found that I can select one of the options in the .xlPageFile (which are dates i.e. 11/17/2011, etc.) by using .PivotFields.CurrentPage = "nnnnnnnn" which is...
  15. C

    Accepting input from user

    I am developing a student grades report on excel for my students. I need to accept a number from the user(the number of students in the class) and allocate so many cells for various fields such as name, age, grades. To calculate grades, I need the formula to be automatically copied to as many...
  16. S

    Tab names and Workbook links

    Hello All!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Awesome forum!<o:p></o:p> <o:p></o:p> I am trying to create a tool to help with some calculations we do all the time. Every time we design a new product, we need to do several...
  17. M

    Display/Hide # of columns based on user input

    Hi all. This may be around somewhere in the forums, but I appear to be searching incorrect key words. I have a range of columns (I:AQ) that a user can freely use to enter quantitative data. Each column represents a province of Vietnam. Column AR contains qualitative data (comments) that...
  18. B

    User input and Vlookup

    Hi. I have a question and need to suggestion as well. I have a template in excel that I need to follow so I can't change or add any column. My problem is in column H I have the formula Vlookup. However, sometimes users also need to input different data in the column H as well because column H...
  19. B

    How Can I Change Columns Based on User Input?

    I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust (contract/expand) the number of columns pertaining to the number of months in the cash flow (the months are listed on the top of the...
  20. B

    Scale worksheet based on user input

    I have a worksheet that includes user input regarding the number of months required for the cash flow. I want the cash flow spreadsheet to automatically adjust the number of columns pertaining to each month in the cash flow (the months are listed on the top of the speadsheet). I cannot find out...

Some videos you may like

This Week's Hot Topics

Top