input box

Hi All I found some code online to run a basic value search on a column. I have modified it to suit my needs, but as I would like to add the function to "Try Again" if the returned result is not the correct one. I need this because the search is for names, and the sheet used by lots of people...

1. How would I use the input box to store a value to a variable in a number format (such as double), but at the same time prevent the subroutine from crashing by using the variant data type for the variable? It always ends up saving as a string, and then why I try to compare the number to...

Hello I really need some help, I would like to set up a Macro/VBA that filters the contents of my table based on the contents of a cell in another sheet. Key Info: The table is in a sheet called: 'GOALS ANALYSIS 2.0' The table ranges from cells: A4:HQ368 (Including headings) The column I...

Hello, I have a spreadsheet that I am trying to finish this morning and for some reason I can't get the Input box to work. My macro scans through code and filters data based on whether it is greater than a number, less than a number or the change between cells to the left of the selected cell is...

Hello I have this worksheet. Sample Data from "Demand Planning Prem" worksheet <tbody> Date SKU Name Begin FG's Add Returns Demand FG End FG's Weeks FG Excess FG 6/20/2014 ASDRK-301 Tent 5718 1 58 5661 98 5339 6/27/2014 ASDRK-301 Tent 5661 7 36 5632 156 5310 7/4/2014 ASDRK-301 Tent...

Hi all, Apologies if this has been answered. I searched a lot but cannot find anything... I'm filling in lots of data that will be updated monthly. The data is structured with the months of the year in columns across the top. As there are quite a few tabs and lots of automatic calculations and...

Hello all, I hope that someone can help me out with a VBA I am trying to write. I am hoping to create an input box that has four blank inputs 1) Description 2) Total amount 3) Amount paid 4) This period amount Then, once I run the macro, I want each of these inputs to fill into the next...

I have written vba code to hide columns when a range of cells do not match a specific initial. This piece of the code works. I want to expand the code with a message box to ask for input (Please enter initials?). Once initials entered run the below code based on the initials entered. Then...

Hi, i need a macro to paste the below formula in a range for cells, however i need to select the cell reference with help of a input box because the value is not always in A2 and i also need to select the range where the formula has to be pasted...

Hi, I have macro I have written that once clicked on from an object pulls certain named tabs from a file, paste them as values, and saves that file outside of the existing workbook they came from. What I am trying to do is auto-fill the input box prompt with a specific naming sequence instead...

Hi again, I am using Input Boxes to fill in information in a table. I'm getting a runtime error 1004 (Application-defined or Object defined) when I tried extending the range one column over and filling that in with an Input Box. I'm not sure what the problem is. Could someone help me? Sub...

I have a workbook that I've created that I continually add data to. I was wondering if there's a way once I paste the data in to have a message box, or something of the kind, pop-up asking for 2 pieces of info, "Date_Thru" & the "Type". THEN using the 2 pieces of info I provide automatically...

So I have recorded a Macro that formats a column that does 3 things (removes all "-" from cells, multiplies every cell by 1, and also a text-to-column function). These are all to help with formatting to create a Vlookup. I will do this on many different spreadsheets but not necessarily the same...

I am in need of VBA code so that I can fill out an input form generated by someone elses macro input box. (I am the user, not the one developing the input box). I am working to streamline a whole cluster of macros and this input box is currently my bottleneck. When the input box pops up...

I have code that saves my file as xlsx properly, but I need to modify the file name with user input each time. ' Save workbook as XLSX file and append date</SPAN></SPAN> ActiveWorkbook.SaveAs Filename:="C:\Users\aurgaiha\Documents\Playground\Amanda\Daily VMI Report" & Format(Now, "...

Hello, I am very new to VBA, and am trying to make a PowerPoint show that is a quiz. I have all of the programming pretty much figured out, except I want to take the viewer's name (which they enter via an Input box on the first slide) and place it on a printable certificate that can either be...

I started creating a macro that asks the user to enter the number of rows into a message box. The message box needs to take that value and make the last row of the graph that value. Dim myColm As Range Set myColm = Application.InputBox("How many rows are there?", Type:=8) On...

I'm sure this question must have been asked somewhere, but I haven't been able to find it. Is it possible to bring up an input box in VBA by clicking on a cell or its contents? Like a hyperlink sort of thing? Ideally, I don't want to have to introduce a button, as I would like to be able to do...

I am using the below code to search a column of data and I am getting an error when I enter a value that contains both numbers and letters (ex. 88006E) but does not cause an issue when using just numbers (ex. 880066). If I step through the process the error happens right after I enter the value...

Hello! I am very happy to post my first problem here for the expert community. :) I made a selection and coloring macro, the filter is based on the inputbox that pops up. What I would like to do here is, that when the box pops up it would have a written date in it, which is the today always...