trouble loading a range into a comboBox
your telling excel to set the range A1:a12 = to the form's combobox value. if
the combobox is empty, range("A1:A12") will be empty.
--
Gary
"Janis" wrote in message
...
Can you tell me why when I run this userform that it erases the values in the
range A1:A12?
The userform initialize procedure runs but it erases the values in the cells
A1:A12 and it doens't have the list in the comboBox but other than that it
runs.
Private Sub UserForm_Initialize()
ThisWorkbook.Worksheets("patients").Range("A1:A12" ) = Me.ComboBox2.Value
End Sub
And I ran it several times and get the same results.
What am I missing?
tnx,
|