Clearing Form

[Noz2k]

How do you clear a form in VBA

I was using Call Userform_initialize at the end of the code for the cmdSend button but when I do this it messes up my combo boxes by adding the items on top of the items already in there (so I have duplicates of each choice)

Any idea why this is happening?

 

[rs2k]

Have you tried;

TextBox1=""

Or post your code.

HTH
Colin

 

[Noz2k]

Not sure which part of the code you want, this is what I would think relevant in my initialize code

Private Sub UserForm_Initialize()
    txtN.Value = ""
  
With cboS
    .AddItem "A"
 
    .AddItem "B"
 
    .AddItem "C"
 
    .AddItem "D"
 
    .AddItem "E"
 
    .AddItem "F"
 
    .AddItem "G"
 
    .AddItem "H"
 
    .AddItem "I"
 
    .AddItem "J"
 
    .AddItem "K"
 
    .AddItem "L"
 
End With
    cboS.Value = ""
 
With cboP
    .AddItem "A"
 
    .AddItem "B"
 
    .AddItem "C"
 
    .AddItem "D"
 
End With
    cboP.Value = ""
 
With cboT
    .AddItem "A"
    .AddItem "B"
    .AddItem "C"
    .AddItem "D"
    .AddItem "E"
End With
    cboT.Value = ""
 
txtN.SetFocus
 
End Sub