View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Morgan Steve Morgan is offline
external usenet poster
 
Posts: 2
Default 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