Erdin? E. Ka
02-28-2008, 03:39 AM
Hi everybody :hi:
I have a problem;
I open an UserForm as vbModeless. I have a CommandButton on this Userform. Also, i open an another UserForm as vbModeless via click to this CommandButton on this Userform.
I find a data via typing on a TextBox on this second UserForm. Suitable datas are listing on a ListBox below then; on this ListBox i have double-click to a random data;
With this method i try to get a data from worksheet to a TextBox on the first UserForm via DblClick Event.
But there is returning an error message while i double click to a data on ListBox of the second UserForm...
I have attached my ?yeler.xls file (Uyeler.zip (http://www.vbaexpress.com/forum/attachment.php?attachmentid=7984&d=1204195138))
I try to define my problem with step by step via 6 pictures.
Could you help me please?
Thanks in advance.
I have a problem;
I open an UserForm as vbModeless. I have a CommandButton on this Userform. Also, i open an another UserForm as vbModeless via click to this CommandButton on this Userform.
I find a data via typing on a TextBox on this second UserForm. Suitable datas are listing on a ListBox below then; on this ListBox i have double-click to a random data;
With this method i try to get a data from worksheet to a TextBox on the first UserForm via DblClick Event.
But there is returning an error message while i double click to a data on ListBox of the second UserForm...
I have attached my ?yeler.xls file (Uyeler.zip (http://www.vbaexpress.com/forum/attachment.php?attachmentid=7984&d=1204195138))
I try to define my problem with step by step via 6 pictures.
Could you help me please?
Thanks in advance.