useing another form to add value to combobox

[rnzb]

Hello,
i have a userform which include combox that i filled it's data from userform activate event , which get them from a range in a worksheet "items"

i have another form that add items to this worksheet "items"

i have a label in first userform to load the second user form
i use

form1.hide
form2.show (false)

now my question is whenever i exit form 2 i need the combobox in form 1 to update it's values
can anybody guide me
thank you in advance

 

[Case_Germany]

Hi,

here an example:

UserForm to UserForm

 

[rnzb]

Hello case Germany
thank you for the fast reply
please can you change the example to fit my needs

i am currently using the following code in order to fill the combobox and not
Set prov = Sheets("providers")
n = prov.Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count
i = 0
For Each Item In prov.Range("B2:B" & n)
ComboBox1.AddItem Item, i
i = i + 1
Next
and not the following as you specified
ComboBox1.List = WorksheetFunction.Transpose _
(.Range(.Cells(2, 1), .Cells(.Rows.Count, 1).End(xlUp)))


while in the userform2 i use the following code in order to add to the range
h = ComboBox1 & " " & ComboBox2 & " " & " " & TextBox2
Set items = Sheets("items")

RowNum = 0
On Error Resume Next
RowNum = Application.WorksheetFunction.Match(CStr(h), cli.Range("B:B"), 0)
On Error Resume Next
If RowNum = 0 Then
k = items.Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count + 1
If k = 2 Then
idcounter = 0
Else
idcounter = items.Range("A" & k - 1).Value
End If
items.Range("a" & k) = idcounter + 1
items.Range("b" & k) = h
items.Range("c" & k) = ComboBox2
items.Range("d" & k) = ComboBox1
items.Range("e" & k) = TextBox2

TextBox2 = ""
ComboBox1.ListIndex = -1
ComboBox2.ListIndex = -1
Else
MsgBox (h & " is already exsits")
Exit Sub
End If
thank you in advance

 

[Case_Germany]

Hi,

please upload a sample file.

 

[rnzb]

thank you sir
i fixed the problem
the trick was in your example which is

when i load userform2 i must call it userform2.show (false)
while when i return to userform1 i must call it userform1.show without (false)

thank you a lot