Making a userform checkbox view a chechmark if value = "X" in works sheet

[KiraJensen]

Hi

I'm trying to make a checkbox within a userform that can view the checkbox as checked off, depeding on there being a "X" ind the B column of the worksheet.

I found this code:

Private Sub Userform_Activate()
If [B1] = "X" Then
Me.Checkbox1 = True
Else
Me.Checkbox1=False
End If
End Sub

The code works just fine, but I'm in need of it being dynamic, so I can look up if there is a X in the entire B column, depending on which line in B column I'm looking up?

For me to look up the individual columns i have autogenerated ID Numbers in column A, where i have created a dynamic dropdown menu with all these numbers in.

Is it possible to make the userform look at the value in ComboBox_ID, for the userform to know which line it has to look at and set the checkbox 1 = true / False depending on there being a "X" in column B without me having to write the code staded above for the individual rows in column B?

Hope someone is able to help me with this due to me having 92 rows of information, and there being constantly added information to the worksheet.


Thanks in advance!
- Kira

 

[dmt32]

Hi,
If you are using the code as posted, then it does not show the update I provided in #post 6 to manage numeric values in your range

m = Application.Match(Val(Me.ComboBox_ID.Value), ws.Columns(1), 0)

add code shown in RED & see if this resolves the issue.

Dave

 

[KiraJensen]

Hi Dave

It works perfectly! Thank you so much for all your help!

Hope you have a fantastic day!

- Kira

 

[dmt32]

Hi Dave

It works perfectly! Thank you so much for all your help!

Hope you have a fantastic day!

- Kira

Glad managed to resolve

Many thanks for feedback

Enjoy your day

Dave