Wednesday, February 24, 2016

[Solved] Checkbox values based on worksheet condition

Checkbox values based on worksheet condition

I have six checkboxes on a user form.  Each checkbox makes a condition in
the worksheet true if checked on the form.  After clicking OK on the
userform, each worksheet condition is set to false, and only the checked
boxes are set to true.  Is it possible to show the status of each worksheet
condition when the user form is opened by showing the corresponding checkbox
as checked?

Example:

In the worksheet,
Cond A = true
Cond B = false
Cond C = true
Cond D, E & F are all false.

When opening the user form, is it possible to populate the checkboxes for
CondA and CondC with an 'x' on the userform?

If so, how?
This is what I have so far, the name of the form is Manage_Feeds_Form.

Sub ShowFeedsForm()
'Check status of feeds and indicate on form

    Manage_Feeds_Form.Show

    If "CondA in the worksheet = true" Then cb_CondA.Value = True
    ditto for CondB thru CondF

End Sub

Thanks,
Steve

Keys to the Problem Checkbox values based on worksheet condition

Download SmartPCFixer for Free Now

Hi,
Like this
Private Sub UserForm_Initialize()
CheckBox1.Value = Sheets("Sheet1").Range("A1").Value
End Sub
 
add similar lines for other checkboxes and (obviously) change the range to suit each checkbox

If this post answers your question, please mark it as the Answer.
Mike H

System Update Readiness Command: To Fix Checkbox values based on worksheet condition

On running the System Update readiness Command, it will Detect & Replace Incorrect Registry data with the Correct one. Which may ultimately Solve Checkbox values based on worksheet condition in Windows.

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

Reboot your Windows & see if error Checkbox values based on worksheet condition still comes up.

Note: Your administrator's password might be needed.

Another Safe way to Fix the Problem: Checkbox values based on worksheet condition:

 

 

How to Fix Checkbox values based on worksheet condition with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your computer. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Time I Try To Open My Internet Explorer It Says (Not Responding),No System Maintenance Icon In Control Panel,How I Put Two Ip In Two Lan Card In Win 7,Excel 2007 Copying Cells Into Filtered Rows,Detect When User Adds New Column To Sheet,Can't Type Quotes In Some Forums,Im Looking For A Formula To SORT & Match To Get Max,Part II - Need Help With Nested IF(AND Statements,Task Manager (and Perfmon) Report ~50% CPU But Processes List Says System Idle Process 96%,Cannot Uninstall Juno Internet Software From Windows 7 Enterprise 32
Read More: Host Process stopped working. Vista based system,How to Fix Error - error code 0x800c0155.2 when opening windows live mail?,How Can You Fix - My toolbars now only shows up when I put the curser at the top of the screen. Not sure what I did to cause this but how do I get it back so my IE and Google toolbars are always up there again??,Troubleshooting:Internet Explorer broken after Windows 8.1 in-place upgrade Error,windows 7 hangs during shut down [Solved],USB Mouse freezing,IE8 Auto Complete not working,How to get a "Text to Columns" macro and other macro to work together?,IE not working message pos up when trying to attach a photo file to email,Help with password protected file

No comments:

Post a Comment