inputbox

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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