inputbox

Hi, I have a bit of an odd issue. Ive got a button that is going to open a MsgBox or InputBox and allow the user to enter in information. This information is there stored in a sheet called "Essential Info" and will store to cells "I2:I13" What i am looking to do is display the input question...

Hi all, I have developed a macro that auto-fills selected cells based on an inputbox. I am in need of assistance to finish it off. Sub Initials() Dim r As Range Dim c As Range Dim name As Variant Set r = Application.InputBox("Select cell(s)", "Demo", , , , , , 8) r.Select name =...

Hello, I am looking for a macro that will take user input from an InputBox then filter all rows that contain the input numbers and display the outcome into a listbox. That is, when the InputBox appears, it takes the first number then second number and then searches through the range of data...

I would like to write vba code that asks the user "which column" they want to filter; and then "what date" they want to filter that column by (ie any date after mm/dd/yyyy) Something like: Sub FilterByInput() Dim iPutFound As Range Dim mycol As String Dim mydate as Variant mycol =...

Hi, if I close the Inputbox without entering anything, excel will give me this error message: "Run-Time error '13" - Type mismatch". How can I improve the code so I wont get that error message when I close inputbox suddenly. Thank you so much. +++++ Sub colorall() Dim x As Integer x =...

Hi I have the following path in vba which at the moment is static: "C:\Completed Scorecards\May" Rather than May being fixed, is it possible to prompt the user to key this in using an InputBox so the user can specify June, July etc? thank you

I've looked around quite a bit and I can't seem to find any way to display a ≥ sign in the text (prompt) of an inputbox. ChrW(&H2265) doesn't work. It just gives me an = sign and the ansi/ascii character set doesn't include a ≥ sign so I can't just use chr() to get one either. I really would...

I have a problem I created and am not sure if it is even possible to accomplish what I am trying. I have one function of my workbook putting activated by a button macro that goes into a series of inputbox arguments. Big problem is, if the information does not need updating, is there away to tell...

Hi, I've been trying to search for ways on how a userform can function as an inputbox of type:=8 but still got no luck. Basically, what I want is to let the user choose a workbook and a worksheet that is why I use the type:=8 of InputBox method but I want to replicate it using a userform because...

Hi, I am working on an analysis sheet that i have created to review & analyse the RFP responses. I need an automated way to populate the responses from the supplier. The suppliers use an standard template to provide the responses. I already have a macro to copy the relevant data. What I need...

Hi all, I have a macro that combine data from a column into a cell. The macro ask to enter a separator in an inputBox and then combine all the data from a column range in a cell separated by the separator of interest. Now I want to combine my data in selection with "alt-enter". I am not sure...

Hello, I'm trying to use application.inputbox with nested if statement but something is going wrong. So basically what I want done. there will be a button on the spreadsheet that when pressed will run the macro. But I don't want just anyone to run the macro. so I want to make it password...

hi all, I am stuck in a macro. find below my requirement: I have a VBA array such as CodeClean = array (AB, BC, ZA, CT, YR, UT..........) I want to enter few data in an inputbox. The data are like BC, CT If the any individual entry in the inputbox does not match with value provided in array...

Hello- I have a workbook with values in column A and the corresponding reference workbook, sheet in column B and C respectively (Col B has workbook name and C has sheet within the workbook). I need a code such that if a value is missing in Col A, then it should bring up an inputbox, open up...

Hello, I have a named range (rangeAdded) that is created with an inputbox rng = Application.InputBox("Select a range", "Obtain Range", Type:=8) ThisWorkbook.Names.Add Name:="rangeAdded", RefersTo:=rng For example, rangeAdded = Sheet1!$D$3:$F$5 Next, I use the inputbox again and...

Hi I have a Table B3:AD6 on multiple sheets (YYYY-Registration). Cell B1 shows the location of the vehicle. I want to create a table on Sheet (Chart Output) that is the sum of selected tables from other sheets, which sheets are used depends upon the year selected and the Location selected via...

Greetings! I am new to VBA so this might be a simple question. I have an excel sheet where the cell D23 has a formula such that the integer value in D23 changes automatically once previous parameters are changed. Anytime D23 value changes, an inputbox prompts for a value for cell D24. This...

Hello Given a selection, I want to copy the cells fills of it to another part of the sheet I have a macro that stores the cell fill colors and patterns of a selected range in arrays. Then the arrays data are used to paint the cells of another zone This macro takes about a second to run But...

I am writing a macro but the start needs to ask the user to input a date (formatted as "yyyy-mm-dd") and filter all the data where the date in column N is greater than or equal to the date that the user inputs. There is a header row so the first row with data is 2.

Hi all, I have seen this requested on some occasions and the usual answer is to create a userform that looks and behaves like an inputbox and then use OnTime to schedule the closing of the userform upon time-out. In case anyone is interested, I am showing here an alternative that uses the...