inputbox

  1. T

    Loop Input Box if Entry is Invalid

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

    Inputbox to select the range from user to apply a specific function.

    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...
  3. kelly mort

    Having trouble with how to format search criteria to match dates in a column- vba

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

    VBA - Change inputBox date from US to UK standard (mm-dd-yyyy -> dd-mm-yyyy)

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

    Auto vbyes in Inputbox?

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

    VBA Inputbox Find and Replace Help

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

    ERRORS in VBA FUnctions "InputBox" & "Select Case"

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

    VBA Find column by header name and autofill column from inputbox to the last row

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

    Changing the name of Inputbox

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

    Outlook calendar export VBA with range period

    Hello guys, I am trying to modify a code that I found in order to export my calendar appointments in Excel. I need to export "Subject", "StartDate", "EndDate" and "Category". The main issue is that I want on a specific period of time by an Input Box, first to enter the start date and then the...
  11. S

    Handling blank entries in an Inputbox with input type range

    Hi folks, I am having a problem with an inputbox. Specifically handling the situation where a user doesn't enter any information and presses OK. I have dealt with this before, successfully, when the input to the inputbox is numbers or text. However, my input is a range. I have trawled through...
  12. L

    Input box cancel to not change the cell value even if its blank, but vbnullstring returns something?

    Hi all, following basic example: Sub testing2() Dim THG As Variant THG = InputBox("Try") If THG = vbNullString Then THG = "Blank" Sheet4.Range("C30") = THG End Sub I would like to input "Blank" in the field if the user hits OK, but if the user hits cancel I would like the original...
  13. L

    Inputbox stripping decimal

    Hi everyone I have the following code which is set to perform a unit conversion (multiple a cell value by a user input) on cells with specific text. The code works great except when the input number is less than zero; the problem being that the application.input drops everything after the...
  14. S

    start macro with data in input box

    hi This works: Sub startbox() Dim i As Long n = InputBox(" Where Should the Fill Color Start?") x = InputBox(" How many times to run?") Range("B" & n).Select For i = 1 To x With Range("A1:I1").Interior .Pattern = xlSolid...
  15. kelly mort

    Set PasswordChar for an InputBox entry

    Is there a way to set a passwordChar for an InputBox entry? I have been digging around for a while now. Can't seem to find anything viable. I want whatever i type into the InputBox look like asterisk just entering a password. Any help is appreciated
  16. C

    Search value the prompt for user form with three options, place in cell afterwards

    Hi, I want to click macro. it searches sheet3 A:A for a value. If it doesnt find it, message just says value not present. If it finds it, it pulls up a userform named "goahead", it consists of three choices yes, no, n/a. whichever one is selected, it places that in sheet3 column z for that...
  17. S

    InputBox value being assigned as date rather then string

    Hi folks, I have a macro that takes an entry from an inputbox and assigns it to variable a of type variant. A problem arises when the entry in the inputbox is similar to a date. e.g. if the value from the inputbox is FEB02. This is not a date, it just happens to resemble a date. When analysing...
  18. D

    Macro between 2 workbooks (one is shared)

    Hello all, I googled a bit and it seems like macros don't work within shared workbooks. Maybe there is a way around it or something, but this is what I need. In workbook one would be a code where in inputbox would be entered a number. That number would be searched withing shared workbook and...
  19. K

    How to open a file using inputbox to type file name

    Hello! I am quite new to VBA, but I am trying to create a program that allows me to push a button that asks for a file name, and after entering the file name, it opens up the file I requested. I have attempted this here, ______________________________________ Sub Start() Filename =...
  20. D

    VBA Inputbox issue with values higher than 1

    After multiple searches using different keywords, I've yet to find anyone having even a similar problem, so I'm not sure what to think here. I have an inputbox that requests a value (building it now so no code written for invalid value types yet). I've written code that adds the value input to...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top