exit

Hi The below code was kindly provided to me some time ago.Sub GlobalCommentsCell() If ActiveSheet.Name <> "Training Log" Then Exit Sub 'If Selection.Value <> "" Then Exit Sub If Selection.Column <> 9 Then Ans = MsgBox("This routine will only work in Column I!" & vbNewLine & _ "Would...

I have a simple Yes/No message box that will exit the sub if the user clicks "no". I saw on another forum where someone mentioned that we can "add another condition to test the user's response for something else in addition to vbYes (perhaps to test for no response by clicking the X to close...

Hi, I am wanting some help to refine this date private sub code. Could somebody please help me include another step so that this sub will only perform if the range in I:L has got data in the cells. Currently it will perform if I put data in the L column. It needs to be similar to an AND...

Hi, I am using VBA to automate values in a specific column for a tracking sheet. It works great but as always is the case I am wanting more. Can anybody help me reorganise these 2 pieces of code so that they work simultaneously in the same worksheet change? Here is the code: Private Sub...

Hi there, Can somebody please help me refine my code so that when I delete cells in column C and D at the same time that I will not produce a run-time error 13 mismatch. Just because I have six other people using this sub and they have zero knowledge or VBA or resetting a sub. For context the...

Hello,</SPAN></SPAN> For now using 3 different worksheet functions to select entire C:H columns for 3 different targets cells "1st for L:V", "2nd for AB:AL" and "3rd for AO:AY"</SPAN></SPAN> Would it be possible use " Worksheet_BeforeDoubleClick" for all targets? </SPAN></SPAN> Data looks...

Hi Everyone, The code below is on a button which opens a table when the password is entered. I need to mask the password as it is being typed in the dialog box if someone could help me with that please. Thank you! Private Sub Command58_Click() 'Attached to On Click event of...

I have this string of VBA code in Sheet3(WIP), the first "Option Explicit" runs as written. The next VBA code runs as written However the bottom VBA code "Option Explicit" very similar but for reason it doesn't run as written, I get no error message. maybe there is a conflict with two VBA...

Hi guys, I got a little issue I would need some help from you. I got a class Module where I import Excel Files and then modify this file to suit. All works quite well. The issue is that I like to import the file and then run the next sub afterwards from that sub. Sub AuszuegeImportieren()...

Hi folks, I am having trouble handling particular cases when using a range input with an inputbox. I want to capture when a user does not make an entry but still presses OK. I have done this previously, successfully, when the input value is a number or text. But with a range type specified for...

Hi folks, I am having a problem with an inputbox. Specifically handling the situation where a user doesn't enter any information and presses OK. I have dealt with this before, successfully, when the input to the inputbox is numbers or text. However, my input is a range. I have trawled through...

Hello All, Thank for for helping all those who are in need! I created a macro where it looks at the all required fields and then emails to approver. I have the same command button to trigger email function from requester to approver to final user. My issue is I need approved message box only to...

First, thanks to mole999 for the help with the first phase of this. I thought I'd be able to use the principles to implement the next phase, but my limited VBA knowledge and research hasn't been enough. I am trying to have cut, copy, and paste inactive for most users, but if the user enters a...

Hello How can i list down the in-between dates in (dd-mmm-yyyy) format from below textboxes ie txtFromDate.text and txtToDate.Text also the list to contain the dates txtFromDate.Text and txtToDate.text with in-between dates Option Explicit Dim fromDate As Date, toDate As Date Private Sub...

morning i currently use the code below, but i also want to include 'invoice-" & the text in "G1" Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Set Target = Range("a10") If Target = "" Then Exit Sub On Error GoTo Badname ActiveSheet.Name = "Invoice WC"...

Still relatively new to coding. I'm trying to build an equipment schedule so I know where gear is going/has been. I'm trying to set it up so I can double click the piece of equipment which will in turn run a user form. It works for my first line (A3), but not for anything after. Private Sub...

We have a file for managing our projects and their milestones... a number of months ago i created a UserForm to assist salesman to "upload" a new project into this file. Essentially, it had 24 text or combo boxes, and upon clicking the submit button, it: 1- Verified that each text/combobox...

I need to update a Tab Name on one worksheet from a manually entered value on another worksheet. I tried modifying the code below and had no luck (almost no VB skills). Any assistance would be appreciated. Shaun [CODE Private Sub...

TextBoxes 4 thru 21 require a numeric value to properly process the procedure. Instead of inserting 18 instances of this code, how can it be written to loop thru the 18 textboxes and set focus on the appropriate TextBox? Even better, MsgBox would indicate the missing value (i.e.: "Value Required...

Hi. I've got a formula that returns a cell address. I set up a worksheet_calculate event that's supposed to extract it (as a value) and give me the address of the cell next to the one originally returned by the formula among the other things. Sometimes it works but eventually it always crashes...