input

Hi, I'm working on a project to design a revenue forecasting tool in Excel, with various User input controls and restrictions and then need to see aggregate data from multiple files and different reports based on different views (e.g. Single Client, practise type etc) I think building this...

I have written the following VBA. It works well when the input is within cell width. However, when the input is too long and exceeds the cell width (which some part of input will be hidden), the function seems not functioning properly. Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target...

Hello, I was actually looking for a way where i can have 2 data tables, with data by day where a user can select which data should be used\shown in table 3 (the input table). Which formula or VBA should i use to achieve this? The input table should be dynamic so there will be no empty or zero...

I have the following code below I would like the input box to appears to input the date only if the date in A3 on sheet BR1 +30 < date , otherwise exit sub It would be appreciated if someone could amend my code Sub Date_Input() Sheets("Sales").Select Dim MyDate As String...

I am using a macro to link data (18,000 rows) to a website for automatic input. I've figured out how to call one line "A3" and it will go to the website, log in, input data and hit submit. I am at a loss how to get it to then input the next row of cells "B3" then hit submit, then C3... etc, I...

HI5 folks, i wish to find triplets of numbers with the difference of 11 within each row/line in the excel spreedsheet. three any numbers (x,y,z) whose difference is 11 , in other words z-y=11 , y-x=11. I use excel 2007. I tried it by using this code below: Sub FIND1()...

When using he code below it also minizes the input box. I want to keep the input box viewable. Sub MNMZ() ActiveWindow.WindowState = xlMinimized 'want to keep this visable Range("A2").AutoFilter 1, InputBox("Please Enter Site #") i = Cells(1, 1).End(xlToRight).Column...

<tbody> input input formula (arrived on site - driving time) DRIVING TIME ARRIVED ON SITE STARTED DRIVING 1:00 15:00 14:00 3:00 19:30 16:30 18:00 3:00 gives negative number ######## - should be 9:00 </tbody> Who can help me solving above? I calculate the 'started driving time" by...

In Word, I've created a template for a payment coupon book. So far I've written some code to load an input box/user form upon opening the word file. The user inputs stuff like name, payment date, payment amount, etc. After hitting submit, the user input is automatically entered into the template...

Hi, I am trying to ignore the blank cell whenever the marco finds it. I need is the output workbook to be copied a blank cell if the Input workbook has one. Instead of this, I am getting the output of values from the input that is in the subsequent cell and everything moves upwards...

I have a button assigned to open up a UserForm with a text box. I sort of have it set up so that when you input the unprotect pword in to that text box, then it unprotects the sheet. However I have an issue that when the incorrect pword is entered it gives me a run time error. Can someone help...

Hi, been a while since last time... Right now I have a large amount of calculations that produce a range (results) of outcome on the spreadsheet (calc). A single input change all the outcome. I have a macro that loop through all the input (1...1000), copy results and then transpose and paste...

I have a section of code below from a much larger piece. The section of code worked when using an input box to acquire a userinput. However, I'd like to have userform replace the inputbox. I've tried just using a userform and inserting the line (as seen below) but that didn't work. I need the...

Hello, Is there anyway to format a cell in such a way that if I enter an integer then in the cell I see just the integer, then if I enter a decimal (say 6.5) I see 6.5 in the cell, Currently I can't get the format to automatically change, I see 6 (when I input 6) and then 7 if I input (6.5)...

Hello, I'm very new to VBA and I'm trying to copy a certain amount of Worksheets into a Workbook based on input that a user puts in a textbox on a userform. Basically, I have multiple users that will be using the same template. Depending on the user will depend on how many template worksheets...

Hi all, I have a user who wishes to have an input cell and a macro will automatically filter input data based on the value in the cell. The input data that he would like to filter on is numerical but his input will be a text string. For example, user inputs: "1-3, 6" in the input cell. My data...

I have a column of alphanumeric values separated by commas (and maybe a comma followed by space) that I'm wishing to return the array position (or row number). Formula input "3" would return 1, input "6" returns 4. The problem I'm having is the formula below is returning 3 for input of 6...

Hi, I found this code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.EnableEvents = False On Error GoTo exitHandler If Target.Column = 10 Then gCountryListArr = Sheets("RESOURCES").Range("Table2[COD]").Value gCellCurrVal = Target.Value...

Hi, I am trying to find a formula that if the date in cell A4 is within a year of the date in cell f1, it will do one formula, if it is between 1 and 2 years it will do another. Any input will be greatly appreciated.

Hi, I'm trying to do a lookup / match based on both on specific criteria (Product and Type), but also on a date that isn't exact. Here is a sample of the table. It's a list of products, types and Effective Price Dates. <tbody> A B C D Product Type Effective Price Date Price Hats...