input box

  1. D

    Vba copy sheet and rename with input box then hide new sheet

    Hello fairly new with vba but having some issues... I have a workbook with 3 sheets. Lets say sheet A sheet B and sheet C. Sheet B is a a form with data entered in certain say cell C5 , F11 and G15. In a nut shell I want to make an archive by copying a sheet, rename it, hide it, and clear the...
  2. G

    VBA copy entire row based on multiple criteria

    Hello! I'm working on a macro and i need some help. I need to copy the entire rows from another workbook to my active workbook if a condition is met. The condition is a combination or 3 other conditions conected with OR. I'm giving an example below. Lets say i have the below table and my...
  3. E

    copy and paste rows in excel to another worksheet vba using input box for the amount of rows to copy

    Hi, I'm new to VBA and have been trying to find a code that will transfer data from sheet 1 to sheet 2 using an input box on the amount of rows to copy over. Sheet 1 is where the user will input the invoice information from D6 to P6, once the information has been checked it would then be copied...
  4. W

    Input Box Column and Row Offse

    I can't for the life of me figure out how to adjust my code to offset the location of where the answer to my second input box question goes. How my macro is supposed to work. . . if A4 (for example) is my active cell and where the macro starts, that's where I want the answer to the very first...
  5. R

    input value default by 1.

    Hi anyone can help me? I've been having difficulty in making the input box value default by "1" Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A:A")) Is Nothing Then If Target.Cells.CountLarge > 1 Or IsEmpty(Target) Then Exit Sub Dim ans As String ans =...
  6. M

    Fill Input Box called by another macro

    Hi, I have written a macro which calls another macro (called 'Step1'). Unfortunately, 'Step1' is locked by my company so I cannot review or edit it. When 'Step1' is called, it requires a string to be entered into an input box. Is there any way I can send a string from my macro to fill this...
  7. K

    New Input Every Loop

    I have some code that allows a user to select multiple items from a list box and clear them out from the list. I'm trying to add a feature to allow the user to input comments for each entry if desired however the issue that I'm running into is that it will only ask for input once then it exits...
  8. tlc53

    Add Second Input Box

    Hi, Can someone help me with this please? Originally I was having trouble with entering a date in the input box, but that now works really well. Now I want to add another input box which asks for the user name (see last 2x lines of code below. This part isn't working or looking right. I...
  9. T

    Input Box to Delete Columns

    Goal: Need an input box where the user enters in numbers. if this is not possible, maybe loop the input box until the value is blank? This is where I am stuck on how to go about this. The numbers entered are searched through each worksheet in the workbook Row 12 is where the numbers are...
  10. B

    VBA inputbox user new line

    Hi, I have a VBA code that gets input from the user. I want that click on ENTER will get a new line.
  11. E

    Clear Contents two cells to the left if input date is <

    Attempting to modify a MACRO that deletes rows based on input box date < criteria - that works great! Now need to just clear contents of cell two cells to the left and not an entire row. Not sure what needs to be done on this line: ActiveCell.Offset(0, -2).ClearContents - not working. Dates...
  12. lmmay

    Sort using an input box to select the column

    I am using the following to sort an excel sheet: Sub Sort() 'Unprotect Worksheet ActiveSheet.UnProtect Password:=" cover700" Selection.Sort Key1:=Range(Selection.Address), Order1:=xlAscending, DataOption1:=xlSortNormal ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Password:="...
  13. E

    Copy and paste into separate sheet

    Hi all, Can someone help with my code below? I cannot work out why it's not working? The line in bold is highlighted by the debugger. Sub Macro10() ' ' Macro10 Macro ' ' Dim myValue As Variant myValue = InputBox("Enter the confirmed start date below", "Start Date Confirmation")...
  14. B

    MACRO (Scanning 2 barcodes for each row) - Need ASAP

    Good morning gurus, I have a problem that I need some assistance with. I need to be able to scan into an input box 2 variables. The first box will be a barcode scan of a serial number, and the second barcode scan will be a weight. I need for the 1st scan (Serial Number) to be in column A...
  15. K

    Input box to filter rows

    Hey! Looking for some help with creating an input box to filter an Excel spreadsheet that has about 1900 rows of data. I want to have a push button control that will produce an input box where the end user will enter data to filter the list. Data will be located in column A starting in row...
  16. B

    Excel VBA: Input Box returning "SN Found" or "SN Not Found"

    Hello Guys and Gals, I found this macro elsewhere, and modified it slightly to fit my needs. However, I'm unsure how to turn it essentially into an IF statement where it returns "SN Found" if it does find the serial number or "SN Not Found" if it does not find the serial number. I would also...
  17. S

    VBA to unhide a very hidden tab and then hide current tab

    Hi, I have a code that I use to launch an input box, when the correct password is entered it unlocks a specific tab, that was previously VeryHidden. I'd like to modify it so it also hides the current sheet when the answer is correct. When I try to modify, I end up hiding the active sheet...
  18. M

    tracking bad paswords

    So i have a lot of password protected macro buttons in my project and I am tracking the user name of anyone who enters the correct password on a hidden sheet called "users" its kind of a built in audit trail . I would also like to capture the user names of people who enter a bad password...
  19. L

    MSForms.DataObject "no variable"

    I have the Forms 2.0 Object Library loaded. I have a value in a string variable (strNum) I have a new form data object (doNum) when I use: Dim doNum As New MSForms.DataObject Dim strNum As String Dim strMessage, strTitle 'Input box to prompt for opers to query data strMessage = "Enter...
  20. X

    Error when Inputbox is Canceled

    I have an input box set up to prompt the user to select a range of cells. When i select cancel and no data range was selected, i get a run-time error '13: type mismatch. Clicking on debug it refers me to my set calculated_range line of code. Not sure what i am doing wrong. The code works...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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