input box

My original excel macro is here, where I have to manually go into the excel macro to adjust the values If a(i, 1) <= 0.3 Or a(i, 8) < 30 Or a(i, 11) < 50000 Then b(i, 1) = 1 Option Explicit Sub Delete_Rows_Multi_Criteria() Application.ScreenUpdating = False Dim ws As Worksheet Set...

Hi all, Just need some quick help if possible. Am after a sheet code that will, when a cell value is changed to contain a "?" anywhere in the cell, will prompt a input box that the user must enter a comment which will then be applied to that cell as a comment. Also, imptorantly, it must add the...

Hello excel experts, I need your help with the following: I have a range named "Database" with about 5000 entries and growing, on the same worksheet I have a small calendar that populates tasks according to the current month and date from the database, this calendar places items for each date...

Hi to all of you, I have an excel sheet with an Inputbox, where i'm asker to put the number of the month, the year and a third value. Problem is, it was working as intended during 2023, but now, it's swaping the month for the day. I'm in Europe, we use dd/mm/yyyy and I'm trying to make the...

Hi all, I need a VBA code in excel for the following: If I use “inputbox” and I want the text in a cell, there are two buttons. Ok and cancel. If I fill in text and click ok. The text will be filled in in the cell. Thats good. If I leave the text empty and click ok, the cell will be empty...

Hello, I’m trying to copy columns A:C down to row 52. ( Attached image source1 and 2) However the amount of rows I want to copy can change day to day. I want to create a macro that will copy in the data but since the amount of rows can change day to day I’m having issues. I’ve thought about...

I am having trouble handling the cancellation of an input box that pops up for this macro. Currently, if I press cancel it will continue Next instead of Exit Sub. I am not sure what the issue is but I assume it's due to the range input box.. The second input box cancels fine. Public Sub...

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

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

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

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

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

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

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

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

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

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

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

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

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