case

Hello, I created a form whose value could be edited via userform. in same userform, there is a cell that shows the result of that calculation. how to make it dynamic? 'Diğer değişkenler için burayı planladımPrivate Sub tbBINR_Change() Select Case tbBINR Case "<1,7" X = 1...

Wouldn't it be advisable to avoid using a lower case "L" for, say, a loop when it (l) looks too much like the number 1?

Dear MrExcel, I need to coloring textbox based on its value. I've tried to write the code below, but it wont works. If value = 0% then backcolor is Red If value > 0 and <= 50% then backcolor is Yellow Else backcolor = Green Can somebody help me? Private Sub Train3_Progress_Change()...

Good morning, I'm trying to write a function to search and replace, thus: Set AnimalColumn = Sheets("Database").Range("Col_AnimalType") ReplaceWithSpecies AnimalColumn Function ReplaceWithSpecies(RangeToProcess As Range) With RangeToProcess Select Case UCase(.Formula)...

I am after some code/advice for Access. I have a list of Order Numbers(Unique) and what cubic metres that each are, I also have a cost benefit per Order. I would like to run some code to be able to find every combination of Orders but within a given constraint of Cubic size (65Cube) to find the...

I have an excel sheet that lists the opened and closed date/time for a ticket. Our SLA’s are based upon created date/time during the coverage hours – 8am ET until 5pm ET (weekends and national holiday’s, both US and India, excluded). If ticket is received prior to 8am ET or after 5pm ET, the...

Evening, I currently have the working code supplied below in use, This is how it works. I complete each cell with values in row 7 & i see cell B7 10th character change to red & also the value in cell E7 show in red. The red part of the code is applied from values entered into the cell B7 BUT i...

I am running a macro that saves a certain cell data to a property in sharepoint metadata. It works great. But, there's always a but, there are times that the string has a comma, then an intentional space at the end. When that is the case, I receive the following error: "method value of object...

I have a userform with several text boxes. Two are tied to select case statements. What I'm after is if the defect is "sheet metal (bent)" and the reason is "bent to long" I need it to put 01001 into a cell. That part is simple enough. The problem I have is that with each defect there are...

Good day, I have a three checklists with a lot of checks for a specific equipment, Sheet 1, 2 and 3. The only cell value that should change on the checklist is the equipment number which is in cell A3. When i run the print macro, it should print out (a preview) the checklist based on the...

Hi there I'm having an issue with a VBA macro- the first half works, however the second 'rule' isn't (in bold type below). I've scoured the forums but can't find an answer. Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C23")) Is Nothing Then Exit Sub...

Hi all. I have a user form with two buttons for a selection by the user. It is either the one or the other. You can not select both. If you select Mobile then the word "Mobile" is to be in cell M1. If you select In Shop then the text "In Shop" is to appear in cell M1. If no button is selected...

I am looking for some help to add too the following code Private Sub Worksheet_Change(ByVal Target As Range) Dim ws As Worksheet Dim rng As Range Set rng = Range("C11") If Target.Address = rng.Address Then For Each ws In Worksheets Select Case UCase(ws.Name) Case...

Hi, Below is a section of my working code. When it runs the year is entered into cell E7 I just need to add to the existing code that when the entered year is placed in E7 it needs to be Red. Maybe .Font.ColorIndex = 3 but where does it need to be added to the code below Please advise thanks...

Hey all, feeling very dumb here. I'm trying to make a simple userform with one textbox, and when the user hits the "Retire" button it will input the data from the textbox into a specific cell (B14 in my case). This feels very simple and I've done it before, but for some reason I can't get it to...

I have this function to randomly generate certain numbers. Then I am calling for its verification with another Sub. And display an alert. Then I found out that if there is a match, instead of the alert showing me the value for the match, it goes on to generate a new set of numbers from the...

I want a way to generate any of these numbers at a time: 1234 0000 1111 2222 3333 4444 5555 6666 7777 8888 9999 I have this line below here which can check for the availability of those pins . I have been staring at it for a while now hoping to find a way around it but no success yet. I need...

I have some code that copies data to other sheets depending on various options that are selected. This is part of my code that is working: Select Case tblrow.Range.Cells(1, 6).Value Case "Yir" DocYearName = tblrow.Range.Cells(1...

I need a little guidance. I do not want to use Data Validation to restrict data entry in the cells as the warnings for accidentally typing will decrease productivity. I want the user to be able to select from the list in the Table column C and it lock the unnecessary cells so they can quickly...

I using this code that formats the number as I type. I would like to make more dynamic to be able to choose the format base on a variable enter in another textbox. Currently the format is hard coded to two zeros after the decimal. I would like to enter (ex. 3) and the format would show $0.000...