inputbox

hello. i have a sheet in which i record some projects, each one with a different color tag. i.e. the range C3:C21 is where the projects names are stored. I would need a macro that after pressing a button, show the items in the cells range like a list and allows me to add or delete dynamically...

hello :) i am currently working on an inputbox to fill in new data in a new last row, and that's working perfectly ! now i'm trying to adjust the macro to go through all data of an existing row. when going from K to Z it does not show the data of the column in the active row. but when i type...

I have a macro that creates an Outlook email with a table containing data from selected ranges in Excel. However, it does not work for non-contiguous ranges. When user manually types comma or holds CTRL to select multiple ranges, it only grabs the first set of continuous range. How can I make it...

Hi all, I have been playing around with the standard vba InputBox to make it more powerful and flexible. I have named this cutomized vba InputBox as InputBox4280Chars These are the main added features : 1- Takes up to 4280 Chars. 2- InputBox size automatically adjustable depending on the...

I have below code where code asks for date from user but there is help (?) in the prompt box. can someone hep to find out how to remove it. strdate = Application.InputBox(Prompt:="Enter the weekending date (mm/dd/yyyy)", Title:="WEEKENDING DATE", Default:=Format(Date, "Short Date"), Type:=1)...

Hi all You probably all know the AutoSave in Excel. And probably a lot will know how to disable it with VBA. Sub Workbook_Open() ActiveWorkbook.AutoSaveOn = False End If Situation: When a user is opening this file for the first time, Excel will ask to 'Enable Content' for security...

Hi Folks, My goal is to be able to filter a column in a dynamic table for strings that contain non-alpha characters like #, $, etc using wildcards (*). I wish to use an InputBox to specify the special character. Something unexpected is happening: If I directly code 'Criteria1' e.g., for #...

I have the following code but needs it to submit input value into an excel cell. Sub UserForm_Activate() Dim myInputBoxVariable As Variant myInputBoxVariable = Application.inputBox(Prompt:="Enter Product", Title:="Stock-Position Request") MsgBox "Your input was: " & myInputBoxVariable End Sub...

Hi, I have a problem: I need to line the same people in column B and currently it looks like this person is always in one cell from A-H but not always in column B as desired. If this person is in for example column H then I have to move him/her to column B and person from column G to column A...

Hello, I've been working on a complicated workbook but have ran into a problem that I can't seem to solve. I need to output a list of invoices to an external application (it can be imported as an .xls file but must be in a stand alone workbook on Sheet 1 for this to work). I have so far managed...

Hi, I have one question: I am trying to figure out how to add to the middle of my recorded macro part that will take a kid name from user and mark it green in the whole spreadsheet. I have tried the code below, but it doesn't work (error object required). Name = InputBox("Enter Kid's...

I am wanting to restrict the user entering into the inputbox to one of four answers. If not, the inputbox will loop until one of four answers is given. The answer would include both text and a number, a1, a2, b1 or b2. Would declaring the variable as a string be appropriate? I figured I could...

Hi All, I have following VBA code to remove extra hidden characters from a range. It works fine. But many times I need to change the range for removing extra hidden characters and for this everytime I have to go edit the macro. I want an inputbox to be appeared to select (from user) the range...

My dates are found in column B and in the format “dd-mm-yy” – this is how they look to my eyes but when I click on them, they look like “dd-mm-yyyy” in the formula bar. When I then do my search for the date with the inputbox entry, it throws back to me the message alert that the said date from...

Hello I've been searching a bit and seems like there's no real answer to this. As it is I can add the date (dd-mm-yyyy), but it won't see it as a date before I manually press enter on the cell. Problem is when another macro afterward search for the latest date and won't detect that cell as a...

Hey. Iam wondering if its possible to to code or do something with inputbox. The thing i need. my costumer is going to put in a value of 7 numbers/letters, and then press Yes. Is it possible to do the "yes" button automatic when 7 numbers/letters is filled in? Ex: inputbox is appearing...

I am trying to conduct an automated Find and Replace with VBA Inputbox to simply replace this: 07 July 2019\SpeeDee Royalty Calculation\07.27\Sales Reports\[07.27.2019 Nexgen SpeeDee Report.xlsx]rptCustomMonthlySalesOverview'!$A$4:$I$102,5,FALSE) To This: 08 August 2019\SpeeDee Royalty...

These 2 VBA expressions do not function as it the are documented to, and I found that these had been recently implimented and broke code I've been running for years. INPUTBOX The docmentation says that if you hit the "Cancel" key that the routine returns a FALSE. It now returns an Empty String...

Hello, I am trying to find VBA code which would find a header by name and then autofill that column from input box value to the last row. Currently I am using below code to replace value in column PostalCode by value from inputbox. It replaces "United Kingdom" in Column PostalCode with value...

When I create an Inputbox in the top left hand corner of the box is displayed Microsoft Excel. Is there any way to change that, remove it, hide it? Can't seem to locate anything about this. Thanks