This is userform initialize only works if text is already in the code to pull
With ComboBox10
.AddItem = "1"
.AddItem = "2"
End With
However, as i make edits to the same userform but in a different text box I need the combobox to auto update to just show the items from a certain set of textboxs.
While this next code, does not work at all, I am only putting it here to help show you what i want.
With ComboBox10
.AddItem = (New_Order_Renewal.TextBox87.Value)
.AddItem = (New_Order_Renewal.TextBox90.Value)
End With
So, as TextBox87 is change (Hundreds of Options) Combobox10 updates so that once I click on it it will show TextBox87 in the dropdown for me to select, along with TextBox90 if I had put anything in it.
With this I will build and if/then statement. So that based on which option I choose, it will fill another set of textboxes with data from other textboxes previously filled. (And yes, my form has 90+ textboxes/comboboxes and other things)
How would I do all this?
With ComboBox10
.AddItem = "1"
.AddItem = "2"
End With
However, as i make edits to the same userform but in a different text box I need the combobox to auto update to just show the items from a certain set of textboxs.
While this next code, does not work at all, I am only putting it here to help show you what i want.
With ComboBox10
.AddItem = (New_Order_Renewal.TextBox87.Value)
.AddItem = (New_Order_Renewal.TextBox90.Value)
End With
So, as TextBox87 is change (Hundreds of Options) Combobox10 updates so that once I click on it it will show TextBox87 in the dropdown for me to select, along with TextBox90 if I had put anything in it.
With this I will build and if/then statement. So that based on which option I choose, it will fill another set of textboxes with data from other textboxes previously filled. (And yes, my form has 90+ textboxes/comboboxes and other things)
How would I do all this?