input box

  1. 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...
  2. 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:="...
  3. 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")...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. X

    Input Box Range to Cell

    I am new to VBA and having trouble. I have created a button that i want to prompt a pop up input box that triggers the user to enter a range of cells. I then want to use that range in a formula. However, doing so through the vba may be over my head at this point but if it is a simple process...
  12. S

    repeatinng a macro the number of times specified in a cell

    I have a macro that calculates a sheet, waits 1 second, then does it again. After 12 seconds, it switches to the next sheet and does the same thing. I'd like the macro to run certain number of times, based on the value of a cell that the end user inputs into a box. I've minimal experience with...
  13. H

    Excel VBA with SQL - Using an Input Box to filter Criteria

    Hello - Below is the VBA Macro with the SQL. The input box is prompting me, but not producing a result. Please help update my code if possible: Sub SO() ' ' SO Macro ' ' 'Initializes variables Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim ConnectionString As String...
  14. S

    Trouble With Dialog Box Applying to All Files in a Folder

    Hi Everyone! I am realatively new to VBA and have been piecing together this code from other posted codes. However, I am having trouble with an Application DialogBox The Project: I am designing a macro for a packing company that allows the user to select a folder and enter a date. The macro...
  15. L

    Copying from a filtered range in VBA

    Hi all! I am trying to filter a data file till there is only one row of data (excluding headers) and then I copy the relevant cells in that row. However, there will be some instances where my filter criteria is not enough to filter till one row of data. If that is the case, I want the user to...
  16. N

    Vlookup from Input Box VBA

    Hello and thank you in advance. I am looking for a way to do a vlookup from an input box using VBA. Basically I need to be able to enter a part number into the input box have it do a vlookup on my spreadsheet and select three cells from the row it finds the PN in to copy. So for example in...
  17. S

    Inputbox

    I have tried unsuccessfully to achieve this Display Input box "Please enter a reason" If the X or Cancel is pressed the the routine ends If OK is pressed and the input contains nothing, then display a message "Reason is required" I cant seem to get this combination to work correctly Sub...
  18. S

    Reject Special Characters in Input Box string VBA

    I have a spreadsheet with a macro to add new countries. The macro adds a new sheet for each country and users enter the name into an Input Box. I have the code to reject country names with spaces (because it messes up later steps) but special characters other than underscore also mess it up...
  19. J

    Object not found from inputbox; need to handle error

    My input box fills the inboxfldr in this code Set Fldr = olNs.GetDefaultFolder(olFolderInbox).Folders(inboxfldr). If the object isn't found the vba gives a run time error. I want to suppress that error, prompt a message box that folder isn't found and just re-promt my inputbox. Looking for some...
  20. J

    Need InputBox to input value into another function in VBA

    I would like to put this inputbox value.... inboxfldr = InputBox("Enter Outlook Folder Name", "Inbox Alert Folder") Into the below so that the value that the user input replaces the "GLAM" in the Set FLDR line. Sub GetFromInbox() Dim olApp As Outlook.Application Dim olNs As Namespace Dim...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top