I know this is a long tittle but I really don't know how to put the title to what I am looking for so sorry for that.
Right, basically my question is for the excel spreadsheet. And I will use an example on the cells names such as A1, B2, C3 and so on.
I am trying to make the the cell G2 to automatically be filled with a text such as example "Hello World", only when the cells A2, B2, F2 are typed in (with any text).
I'm hoping someone will be able to help me solving this.
Thank you in advance.
Try an if statement:
=IF(AND(NOT(ISBLANK(A2)),NOT(ISBLANK(B2)),NOT(ISBLANK(F2))),"Hello World","")
Test all cells for blank and if all are filled in then give "Hello World".
For your second question (you should start another question): Put this code in the Sheet code; not in a module and not in the Workbook.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not VBA.IsNumeric(Target.Value) Then
If target.address = "$E$1" Then
Target.Value = UCase(Target.Value)
End If
End If
End Sub
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments