input box

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi, Is it possible to get a dropdown list with VBA InputBox? The dropdown list has to refer to the table[column]: "TabelMatriaalinformatie[Materiaal:]" Thank you for you time. A part of the VBA code i have now: Dim Materials As Variant Sheets("Beginblad").Select Materials =...

Hello, Below standing code pops-up after worksheet-change event. I'm looking for a piece of code that ends after pressing "cancel" (and revert to previous value) or ends when no name is entered (and also revert to last entered value of the cell). Name in the offset function should only change...

Hi all, So I have this excel file with a lot of different hyperlinks which paths need to be updated every quarter. However I do not want to update all of them at the same time since they all have a different path. What I'd like to do is to (1) enter the range of the hyperlink I want to edit in...