I am very new to Userforms and have learned all I know by researching examples. I'm thrilled with a userform I set up, but can't figure out one final detail.
I have loaded a combo box with student names pre-loaded a worksheet using the following:
Private Sub UserForm_Initialize()
'Empty StudentGoalsCBox
StudentGoalsCbox.Clear
Dim tbl As ListObject
Dim cell As Range
'Store Table Object to a variable
Set tbl = Sheet87.ListObjects("MinutesTable")
'Load Combo Box
For Each cell In tbl.DataBodyRange.Columns(5).Cells
StudentGoalsCbox.AddItem cell.Value
Next cell
That works! Now, when a student's name is clicked, I want 6 labels to change in order to reflect goals specific to that student. I want it to look something like:
John Doe - Label 1 John will blah, blah
Label 2 John will blah, blah
etc.
Thank you very much!
I have loaded a combo box with student names pre-loaded a worksheet using the following:
Private Sub UserForm_Initialize()
'Empty StudentGoalsCBox
StudentGoalsCbox.Clear
Dim tbl As ListObject
Dim cell As Range
'Store Table Object to a variable
Set tbl = Sheet87.ListObjects("MinutesTable")
'Load Combo Box
For Each cell In tbl.DataBodyRange.Columns(5).Cells
StudentGoalsCbox.AddItem cell.Value
Next cell
That works! Now, when a student's name is clicked, I want 6 labels to change in order to reflect goals specific to that student. I want it to look something like:
John Doe - Label 1 John will blah, blah
Label 2 John will blah, blah
etc.
Thank you very much!
