input

is it possible to input 1 and 2 only in textbox ?

Hi, I have a spreadsheet that gets dates manually inputted into it. What I need is a formula to return a date 7 days on from the manual input but has to be a Monday, Thursday or Friday. I.E. Manual input is 1/10/19 or 2/10/19 I would want the returned date to be 10/10/19. Manual input 3/10/19...

My workbook contains many sheets and before closing the workbook I would like to replace the same cell on all worksheets with the same text. For example, certain cells replace all that start with "rateid_???". I have tried the following code but receive an error on the IF ws.Range…… row. Could...

Good day everyone. I'm looking for some help regarding a VBA script. I have an Excel database that a user must input data for a weighbridge/landfill facility. When a truck comes in, it is weighed, its data is captured and the truck can dump its cargo. When it leaves, it is weighed again and the...

I am working with a user form (Cost Sheet) that allows for input into disjointed fields that was created for aesthetic :laugh: purposes, but does not lend itself to easy data analysis. I'm attempting to automate the process of collecting all of the data line combinations and put them in columnar...

Could anyone please advise on conditional formatting? I'm trying to use a formula to have say cell a1 to change colour IF cell d1 has any input? I've been trying conditional formatting in cell a1 as - If(d1="",TRUE,FALSE) but no change happens with input to cell d1. Any help would be greatly...

Dear all, Sorry if I duplicating a thread, but I don't know what words to search for to see if this has been asked. I have a workbook and on one sheet is all of the data. What I would like it to do if possible, If I go onto another sheet and input in one cell the location that is then...

Hey. Iam wondering if its possible to to code or do something with inputbox. The thing i need. my costumer is going to put in a value of 7 numbers/letters, and then press Yes. Is it possible to do the "yes" button automatic when 7 numbers/letters is filled in? Ex: inputbox is appearing...

I would like help creating VBA that creates a unique list based on input in cell 'H1' and provides vertical output starting at cell 'E5'. (cell 'H1' will always be a 1- or 2-digit number) Starting in cell 'A5' of the sheet named "Products" I have a list of unique product numbers. Starting in...

Good Evening Could someone assist. I am attempting to save a current sheet (Active sheet) into a new workbook and include in the Name the reference to Range B2 which is Start & C2, which is the user input date. Also would like to include B3, which is the End & C3 which is the user input end...

Hi I need a vba code that converts a decimal input to real time and does nothing if it's time. for example: 2.5 convert to 2:30 3.5 convert to 3:30 and if input is time do notting 2:30 convert to 2:30 3:30 convert to 3:30 . . .

I am trying to update a range of cells in my database which is an excel sheet with another input range. The range in the database is named "MyRange". The Input Range is named "Input" When I use this code: Range("MyRange") = Range("Input") nothing happens When I use: Range("MyRange") =...

Hi There, I'm trying to multiply a cell within a table that I would input a number into by another cell and struggling with the VBA formula. For example, I would input 5600 into F2 and want it to multiply by D2 and display the result within F2. <tbody> A B1 C D E F G 1 material Desc...

Hi, I want to be able to input data which will automatically be subtracted from another number. For example, in cells E25 to E33, I want the input to be subtracted from 0.880. In cell E34 I want the input to be subtracted from 0.860. Does this have to be done by code? Thank you. :)

Hello Everyone, I'm working on a simple GUI to input serial numbers. I have created a textbox in a userform to allow a input of a serial number using a hand scanner. The scanner will read serial number and submit an Enter command upon completion of input. Using the Enter command allows the...

Hello - Thank you for any help in advance. I'm still trying to learn VBA and have been trying to figure this out for a while - and need some help. I am trying to make certain fields required before the user can access the print button I created using the form tools on a specific worksheet. To...

I'm trying to make balancing my checkbook easier, but finding it hard to find a macro or formula that does what I need. I have two columns, one that has the charges according to my bank, and the other which has charges that I've documented myself. It's easy to find values that occur only in the...

Hi, I would like to be able to take a quantity and "round" it based on a list of rounding criteria. I am having trouble trying to find an exact example of what I an trying to do nor am I having any luck myself with the different formulas. I have created an example using fruit if someone could...

Hi all, I have this code which used to verify a value from a range of cells and that of my input. It used to work until yesterday when I did a few updates. I get the else alert for any item I feed the input box, except I feed it with the first item in the range – that is cell B4, where I get...

Good Morning, all, Hoping to get some help with a macro I'm trying to create. In essence, I'm trying to write VBA for excel to look at a value in a cell, take an inputted value from the user, and validate that the inputted value matches the value in the cell it's looking at. If the value does...