user input

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...

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...

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...

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...

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...

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...

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...

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()...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...