Computer Error Fixer: Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists [Anwsered]

Wednesday, March 30, 2016

Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists [Anwsered]

Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists

If A1 = a specific text value, I want to run a macro that that changes to a custom view in which A2 is visible. If A1 is does not equal that specific text value I want a different maco which hides A2. I know how to create custom views, and how to record
a macro, however; I don't think I know how to activate a macro based on the text value of a cell.
Also, if A1 = a specific text value then A2 must contain a numeric value. If the user fails to enter the numeric value then I want a dialog box to pop open and remind them to do so. If A1 is blank then A2 should also be blank which will be no problem since
it will be hidden.

Thanks.

Solutions to the Problem Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists

Download SmartPCFixer for Free Now

Hi Lilly,
There are several steps to doing what you want to do.
The key is what developers call "trapping the event" and choosing the event you want.
In this case, you want to put your code in the worksheet that you have the A1 you are checking, and trap the events
Worksheet_Activate and Worksheet_Change.
This ensures that every time the user opens or switches to your worksheet, that cell is checked

Private Sub Worksheet_Activate()
CheckA1
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
CheckA1
End Sub

Public Sub CheckA1()
If Me.Range("A1").Value = "Y" Then
Rows("1:3").Select
Selection.EntireRow.Hidden = False
Me.Range("A2").Select
Else
Rows("2:2").Select
Selection.EntireRow.Hidden = True
Me.Range("A1").Select
End If

End Sub

That takes care of the showing and hiding.
Now for ensuring only numbers.
For that you need the Data tab and to choose "Data Validation" I don't see a way to attach screen shots here, but basically you tell data validation you want a number within a certain
range (if you just need any number choose >=0) and tell it what information you want to give the user if they put a wrong value in.
Make sure to check "Ignore Blanks" so if the user hasn't entered anything or doesn't need to you do not get a validation error.

Good luck!
Joey

Running System Update Readiness Command

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists in Windows.

Open CMD as Administrator by Simply Right Clicking on Start button > Command Prompt (Admin).
Now Type or Copy paste "DISM.exe /Online /Cleanup-image /Scanhealth" and hit Enter,
Now again Type or Copy paste this "DISM.exe /Online /Cleanup-image /Restorehealth" and hit Enter.
Close the Command Prompt Window because we are done.

Try and see if you still get the same error Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists in your Windows.

Note: You may be prompted to enter your administrator's password when you try to execute certain system tasks!

Another Safe way to Repair the Problem: Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists:

How to Fix Activating a macro based on the value of a text cell. Also, send a message to user when a condition exists with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Computer Error Fixer