Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble loading a range into a comboBox
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, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble loading a range into a comboBox
You are currently forcing an empty ComboBox value into A1:A12, even if you
reversed the assignment it would still not load the ComboBox......use the following to achieve that. Dim c As Range ComboBox1.Clear For Each c In Worksheets("patients").Range("A1:A12") ComboBox1.AddItem c.Value Next c -- Regards, Nigel "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, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble loading a range into a comboBox
Try this.
Private Sub UserForm_Initialize() ComboBox2.RowSource= "patients!A1:A12" End Sub Hth, Merjet |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble loading a range into a comboBox
Nigel
Thanks for the answer. It really is urgent. Helped immensely. :) "Nigel" wrote: You are currently forcing an empty ComboBox value into A1:A12, even if you reversed the assignment it would still not load the ComboBox......use the following to achieve that. Dim c As Range ComboBox1.Clear For Each c In Worksheets("patients").Range("A1:A12") ComboBox1.AddItem c.Value Next c -- Regards, Nigel "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, |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
trouble loading a range into a comboBox
Check your first post, too.
Janis wrote: 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, -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trouble loading excel files | Excel Discussion (Misc queries) | |||
Trouble with a ComboBox on a UserForm | Excel Discussion (Misc queries) | |||
Loading Combobox, but avoiding duplicates | Excel Programming | |||
Loading sheet names in Combobox | Excel Programming | |||
Maps.........Having Trouble Loading things | Excel Worksheet Functions |