exit

I have a macro enabled workbook through which the user can select a single .csv file, which is then edited by a macro in the relevant module, and the edited version saved alongside the original, in the original folder. I am now trying to change it so the user can select multiple files and have...

Please tell me how to combine these into a single VBA. Each one runs alone but I cannot figure out how to combine. Thanks. (The first one allows entry of date without use of / key and the second allows entry of time without : Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim...

Is there a way to get this code to apply to multiple cells - say C2 through C9? Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim rInterest As Range Set rInterest = Range("H2") Dim rTotal As Range Set rTotal = Range("C2") Dim rList As Range Set rList = Range("J1") Dim lRow...

Hello, I would really appreciate any help that can be given. I have created a userform where I can track missed scan labels from my production team. I have 6 text boxes per ticket I need to fill in the userform. (all for different tracking purposes) What I need the userform to do is only check...

I've got a list of names (A1:A4) and one of objects right next to it (B1:B4). Every time the list of names changes I would like Excel to 1) check if the name that was just entered exists within range J1:J4 2) if it does, enter its matching value (K1:K4) in the cell right next to it (so, column...

PLEASE ASSIST: I have a worksheet, with a string value on cell A2. I need to search through for that value in columns D5:D1000. if it exit, then display the row number. I will really appreciate ur contribution. thanks

Hi Experts Need some urgent help I'm working on a macro where I want macro to go to a particular date and then perform another function. So I picked coding from my previous macros and compiling a new one... But the problem is - My earlier Macro Says "EXIT SUB" after it finds a particular date...

I’m new to VBA/Excel Coding and I am trying to do the following… When I click on a cell on the CALENDAR sheet the userform opens automatically and I fill it out. What I want to do now is, when I click OK on the userform, I want all of the data to go into the same single cell I selected to open...

Hi Guys This code is what I am using to add Data recorded from a userform to the next empty row in a sheet It was working but now nothing is being added to the chosen sheet Do one of you amazing guys out there have any ideas why??? Private Sub cmbSave_Click() Dim LastRow As Long, ws As...

I've tried looking for Asc 13 in both KeyUp and Keypress events but it is ignored. This isn't how it should be is it? Doesn't show in the Exit event either. How an you tell if a user has pressed Enter, or instead has clicked away from the text box?

Dear, I would like my Excel worksheet to be sent by email (as pdf) by running a macro. I am using the below mentioned script. However, I would like to edit the script so that the file name is saved as a specific cell within the current sheet (for example F2) instead of the worksheet name, and...

Hi Guys I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry The code I have used for single entries is working fine but I can't get the dual entry to work The codes I use are as below: For the single entry If cmbStatus.Value = "" Then MsgBox...

Hi Can anyone advise for a macro that will check cell A2 for a value of "True" If cell A2 does contain "True" then return a messagebox "Are you sure this is the correct selection?" vbyesno if vbyes is pressed then continue with code or if no is selected exit sub This must be run from a command...

Hi there! I'm new to this forum, so please let me know if I'm doing anything wrong! I'm not versed in the arts of VBA, but have managed to find the codes I need through Google. The codes read: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 1 Or Target.Cells.Count > 1...

Dear MrExcel experts, I'm trying to save my girlfriend, who is a manager at a warehouse for a non-profit organisation, some time with filling out the time sheets/logs for staff and volunteers. She's not very good at converting AM/PM to 24H format which would basically fix our little...

I have the following snippet of code below Sheets("recon").Select If Range("d8") = 0 Then MsgBox "No JNL required" Exit Sub End If I would like it amended so that if range D8 or D9 is 0, then message box to be activated and message to say "No JNL required" and Macro to exit If range D8...

Hi Experts Here comes a new problem. I want to filter a field "Sr" in my table "Visits". The field "Sr" contains data in form "A 0001" and counting goes on. So I want to filter giving input a record number for example "0499" I tried to write a code using my previous few codes but it is not...

Hi, I have a form to add new employees (LastName and FirstName with new unseen EmployeeID) to Employees table. I have a save (it saves the record and goto NewRecord) and cancel button RunMenuCommand Command UndoRecord, which basically delete what is typed in both fields of the...

Hi All, Please help me with this error (Run-time 1004) that comes up each time I run this code. Sub Saveaspdfandsend() Dim xSht1 As Worksheet Dim xSht As Range Dim xFileDlg As FileDialog Dim xFolder As String Dim xYesorNo As Integer Dim xOutlookObj As Object Dim xEmailObj As Object Dim...

Hey All I need an excel formula does the following calculation: Notification Date Exit Date Cost July18 Aug18 Sept18 Oct18 Nov18 Dec18 Jan19 Feb19 Mar19 Apr19 01st Sept 18 31st March 100k 14.3k $14.k $14.k $14.k $14.k $14.k $14.k I need...