Forum

Hi Branden, This seems overly complicated to me, but maybe I'm not understanding exactly what you are trying to do. If services happen every 500...

Hi Steve, In the ThisWorkbook module use this event: Private Sub Workbook_BeforeClose(Cancel As Boolean) Cancel = True ' YOUR CODE GOES HERE ...

Hi Gabriel, You had two pieces of code setting the value of Birthday. The 2nd one set the value to a variable called cValue but this had no value ...

Hi Mariam, Have you read this post Regards Phil

Yes, just change Range("A1") to Range("A2")

Hi Mel, You could do this with VLOOKUP or XLOOKUP and avoid having to create a form and write VBA to make the form work. Create a new sheet and c...

Hi Louise, It looks like you are working with numbers stored as text. The RIGHT function is for strings. So is everything a string or do you have...

Hi Shoaib, You can use a formula for this =VALUE(TEXTJOIN("",TRUE,IFERROR(MID(A1,ROW(INDIRECT("1:100")),1)+0,""))) If your version of Excel d...

Hi Taylor, If the invoice number is in A1 try this ActiveSheet.Copy After:=Sheets(Sheets.Count) Range("A1").Value = Range("A1").Value + 1 Reg...

Hi Steve, the columns in the column chart are all the same colour because they are not touching each other. There's no need to make them differen...

Hi Steve, As always, illustrating what you are talking about saves me a lot of time figuring it out. Please provide a workbook. I'm not entirel...

Hi Steve, You can set the series colours like this Sub ChangeSeriesColours() ActiveSheet.ChartObjects("Chart 1").Activate With ActiveChart...

Hi, Please provide your workbook so we can see what you've done. Phil

Hi Branden, What do you mean by 'suppress'? In cells E11:E14, how do you want these values to 'suppress each other'? If you can provide a wor...

Hi Duraivel, I like to make things as simple as possible. I've often found that 'requirements' for a job are actually focussed on how to do someth...