Posts by charliejs

Nice!

So can you help me?

Hey again

I have now been asked to make this shape flash when it appears (to make it more obvious to click it). Is there any easy way to go about this?

My code for the shape is:

Private Sub Worksheet_Calculate()

ActiveSheet.Shapes("Rounded Rectangle 13").Visible = UCase(Range("I34").Value) = "PASS"

End Sub

I don't know what I was doing wrong before but it is now working! Thank you so much to both of you for all your help

Attached is a new excel with the same format as my sheet. I have cleared all information from the sheet that is not relevant as this is for my employer and cannot be shared

So I would like the Rounded Rectangle 4 - "Next Stage" button to only appear when the cell to the left of it shows "Pass"

Thanks

So basically this spreadsheet is a checklist

I have 5 questions which can either be a “Pass” or “Fail”. These cells are changed to pass or fail by macro buttons. These cells are G35:G43 in every other cell

The cell in question I34 holds an if equation to verify if overall the case is a pass or fail:

=IF(COUNTIF(G35:G43,”Fail”)>=2,”Fail”,IF(COUNTIF(G35:G43,”Pass”)>=2,”Pass”,””))

I hope this makes sense - there probably is an easier way to go about this but as I said, I’m not 100% proficient at VBA

Aha! I think we are making progress here - using your code Worksheet_Calculate, the shape disappears as soon as a button is clicked (the other macros that change I34) but I am afraid it doesn’t reappear when I34 says Pass

Yes I have tried this, I have entered the code into “Sheet 1” but am unable to gain the intended result

Do my other macros also need to be in this sheet instead of in modules?

Hey Carim! Thank you for your speedy response!

I have put in your code to Module 1 of my VBA but I’m afraid it isn’t working

I believe the issue is that my sheet holds other buttons which change other cell values

I then have a long IF formula in cell I34 which either outputs “Pass” “Fail” or “” which is determined by the other cells which changed based on my macro buttons

I hope this makes sense and I’m hoping there is an easy fix?

I have a spreadsheet which holds a shape “Rounded Rectangle 4”

Another cell (I34:L36) holds an IF formula which outputs either “Pass” “Fail” or remains blank

I would like to make this shape only appear when the word pass appears in the cell as a result of the formula

I am not very advanced with VBA so please make it as simple as possible. I have tried using multiple guides on google on how to achieve this but I cannot make it work

Thanks in advance