I want to load a userform with 2 checkboxes. I want the Checkboxes text to equal whatever is in two specific cells on my spreadsheet. i.e. I want to initialise the checkbox text to be the vale of cell A1 and A2 on sheet 1 when I load the userform. To load my userform I am using
Sub Prepare_Sites() ' Application.ScreenUpdating = False Load Select_Sites_Separation 'Loads up userform Select_Sites_Separation.StartUpPosition = 2 Select_Sites_Separation.Show Application.ScreenUpdating = True ' End Sub
and then I thought on the userform I would use the following private function but this isnt working.
Private Sub UserForm_Initialize() Bmth_CheckBox.Name = Data.Range("A9").Value Dub_CheckBox.Name = Data.Range("A10").Value End Sub
Can anyone tell me what i'm doing wrong.