inputbox

I have been all over the place with this one. What I'm looking for is a small piece of code to do the following. I get a monthly file with the turnover from departments from multiple states. I the files are stored on the Y:drive Every month the send the file in with a slightly different name...

Hi, Is there a function in inputbox that would let user choose 2 columns separately for comparative analysis? I can have 2 inputbox method that will pop up simultaneously but I want it just one inputbox that will prompt and can be editable until user will click on OK button. Or it can be a...

Hello and thank you in advance for reading my post and attempting to help me. I have created a macro for my housekeeping department in which I would like to be able to type in one of my housekeeper's names and have my macro bring me directly to their data in my spread sheet. However, I also...

Hello, Is it possible to select an entire column through inputbox vba by inputing a number, for example if we input 1 in input box it should copy columnn A , if 2 then column B and so on. Thanks, Hari

Hello, how do I ensure myValue when entered in the inputbox in the first sub below, carries through to the section without being asked again? Many thanks. Sub D42_Forecast_Macro() Dim myValue As Variant myValue = InputBox("Enter the railway period, e.g. 1804") End Sub Public Sub...

Hello, I use email subs routinely to pass WS/WB information around all the time. A request was generated that I add in a function so that users could send me a note about comments or suggestions on how certain WB's are working for the users; kind of like a "contact the webmaster" kind of thing...

What I would like to do is have the default of an input box be the value of one of my cells. If the cell is blank, then I would like the default value of the input box to be blank. If it's populated than it's value is the default value. It seems that I get an error message when I store the value...

Hello everyone. is there any idea how to make input value in inputBox become UpperCase here is my several codes, and it's not working. In = Ucase(Inputbox("my message")) --- In2 = InputBox("my message")) In2 = StrConv(In2, vbUpperCase) Any and all help is greatly appreciated. Thank you!

I'm creating a worksheet that has one column and one header for the column. There is a button that prompts an input box and creates a new row in the column for the inputted value. I am trying to create a procedure that sorts the column alphabetically after the input box value has been added as a...

Is it possible to search for a specific string while using the getopenfilename function? I'm just trying to narrow down the files in the folder to be more relevant to the user. Currently my code takes a few inputs from the user and then opens windows explorer to let them locate the files they...

Hi guys, I'm trying to create a macro which activate when I'm clicking on add new worksheet. What I'm trying is that an inputbox appear, there I can add the name I want. But if the name is already exist, an other inputbox appear till I don't put a value which can be the name. Thank you!

Dear Experts, I have following macro which split a mastersheet into multiple sheet based on its city, Sub DataSplit_2() Dim City As String Dim Lr As Byte Range("C2").Activate Do While ActiveCell.Value <> "" City = ActiveCell.Value On Error Resume Next...

I am having trouble adding in code to display a msgbox when a user inputs a variable text value into my inputbox that cannot be found. My code is looking for a outlook folder matching what the user entered into the inputbox (this value is variable) and if it doesn't find it, the vba will error...

Sub text2() Dim userDate As String Sheets("Sheet11").Select Range("Z1").Select userDate = InputBox("Please type a date to search in MM/DD/YYYY format") If userDate = vbNullString Then Exit Sub Sheet11.Range("Z1").Value = Application.WorksheetFunction.SumIfs(Range("O:O"), Range("B:B")...

I would like to only allow the user to enter a date in the inputbox in the format of 'mm-dd-yyyy'. If they do not I want to send msgbox. Here is what I have, just am unsure of how to get the validation. Sub Populate_Date()On Error GoTo NotValidInput Dim myvalue As Date myvalue = InputBox("Enter...

Hey all, As per the title, I'm trying to figure out how to automatically ask the user to input data after I show a Userform. Relevant Code: Private Sub Start_Click() Userform.Show number = InputBox("Please enter a number", "Enter a number") End Sub When I execute the above code, it...

Hi, I have an issue regarding the Index;Match formula. The idea of the macro is to update the formula for some cells which are dependent on which sheet the user wish to do the measurements for. The macro looks like this: Sub ReportTest4_FormulaUpdate() ChooseYourSheet = InputBox("Please type...

Hi there, I was hoping to create a MsgBox or InputBox where the user can select a date (or use the date in the selected cell) with three different formulas. The InputBox might read "Select Date"-- it would be extra cool if there's some way to incorporate a calendar to click the date, but maybe...

<tbody> 10131 ..other infromation. ... . . 10132 .other infromation.... .. . . 10133 other infromation. .. . 10134 other infromation. . . . 10135 other infromation. .. . . </tbody> Dear Gents, I would like to setup a macro that can let me enter the two visit sequence numbers...

I have written a macro that sends text from excel to an input box on a website to be used as for a search. The code works fine for other textboxes, however this textbox is giving me issues. It seems that it is inserting the text as a input mask instead of the actual value. Here is my VBA code...