inputbox

  1. 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...
  2. sparky2205

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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
  7. 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...
  8. sparky2205

    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...
  9. 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...
  10. 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 =...
  11. 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...
  12. D

    Show/Hide Rows by user input

    Hi probably been asked 100,s of time but can't see what I'm looking for. Can you open a worksheet in excel & only show rows relevant to whats types into an "InputBOX" ie a number code. Also ensure nobody can view rows that are not relevant to themselves.
  13. A

    How To Save File With User Enter path with Input BOX

    Hello Every one Dim T as Variant T = InputBox("Enter Your CORP ID") ChDir "\\Client\C$\Users\T\Desktop" ActiveWorkbook.SaveAs Filename:= _ "\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _ FileFormat:=xlOpenXMLWorkbookMacroEnabled...
  14. A

    Activeworkbook.Close Problem

    Hi everyone, im unable to open my workbook due to the code below Private Sub Workbook_Open() Dim user as string User = Inputbox ("Please type your password") If typename(user)="albert" Msgbox "thank you" Else activeworkbook.Close End sub I tried a lot typing albert in the inputbox but still...
  15. G

    Modifications to code to allow cell references rather than InputBox popup

    Hi, Trying to modify the code below to allow the direct use of cell references instead of popping up an InputBox. I've tried e.g. Set tags = Range("B2:I2") but this isn't working. Also wondering why the code below works with Set used only once rather than at the start of each line? Dim...
  16. A

    VBA Date picker or calendar in Inputbox?

    Hello, I want to create a series of inputboxes to ask questions to get the information I need to fill a row in my excelsheet. One of the question is asking the date of a transaction. I now use the code below to enter a date. Is it possible to add a calander oor date picker in an inputbox to...
  17. S

    VBA inputbox - vlookup and edit

    I need an inputbox to vlookup "part number" and then replace/update its current batch number "batch". part number batch 0501322391 0529765 0501218232 0539866 4464335010 4699467 4464335009 6204844
  18. H

    Filter a Row Field in a PivotTable using xlDateBetween

    Hi all, I have an error with these lines of code: Dim StartDate as Date, EndDate as Date StartDate = InputBox("") EndDate = InputBox("") ActiveSheet.PivotTables("xLabor").PivotField("CSVFile].[Account].[Account]".PivotFilters.Add2 , xlDateBetween, Value1:=StartDate, Value2:=EndDAte...
  19. kelly mort

    Form number combinations of two from an InputBox entry

    Hi, I need a script that takes an InputBox entry separated by commas then form number combinations of two from the data entered. The InputBox will always take a maximum of 5 numbers separated by commas. Example "00,01,02,03,04" And then form all the combination of two : "00-01" "00-02" "00-03"...
  20. kelly mort

    Copy data from rows when InputBox entry is met

    Hi, I am looking for a script that takes an InputBox entry then compares it with the last two characters in cells in column C. When the match is found, I want the data copied to another sheet. say from Sheet1 to Sheet3. The data table starts from B1 to H100 Thanks In advance Kelly

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top