Clearing listbox
 

Hi

I have userform with 2 commandbuttons (Load and Clear) and 1 Listbox.
I tried using the below event to clear the listbox but i failed.

Private Sub cmdClear_Click()
'clear the data
Me.Result.Value = ""
End Sub

Hope someone knows why

Thanks in advance

Eli

Clearing listbox
 

Please try

Result.Clear

אלי wrote:
Hi

I have userform with 2 commandbuttons (Load and Clear) and 1 Listbox.
I tried using the below event to clear the listbox but i failed.

Private Sub cmdClear_Click()
'clear the data
Me.Result.Value = ""
End Sub

Hope someone knows why

Thanks in advance

Eli

Clearing listbox
 

under the button click command just clear it :
ListBox1.Clear
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"אלי" wrote:

Hi

I have userform with 2 commandbuttons (Load and Clear) and 1 Listbox.
I tried using the below event to clear the listbox but i failed.

Private Sub cmdClear_Click()
'clear the data
Me.Result.Value = ""
End Sub

Hope someone knows why

Thanks in advance

Eli

Clearing listbox
 

Thanks for your reply.

somehow i got "run time error'-2147467259(80004005): Unspecified error" when
i did it.

"John Bundy" wrote:

under the button click command just clear it :
ListBox1.Clear
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"אלי" wrote:

Hi

I have userform with 2 commandbuttons (Load and Clear) and 1 Listbox.
I tried using the below event to clear the listbox but i failed.

Private Sub cmdClear_Click()
'clear the data
Me.Result.Value = ""
End Sub

Hope someone knows why

Thanks in advance

Eli