Adress Userform

[kirana2014]

Hi I am wondering whether you could help me with an excel formulae.

zie below excel file

when I do a search and edit from results I get an error. Please help. Thanks.


With Best regard

Kirana

[LeoTaxi]

Hallo Kirana

Please Login or Register  to view this content.

Kind regards
Leo

[gmr4evr1]

There are a couple of things to do
In your Sub Back() routine, add Dim a as Long between the sub tittle and the For statement
Also, in your Private Sub CommandButton5_Click() routine, add Dim ctl as Control then replace

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

[kirana2014]

Dear Leo,

Private sub listbox1_click() is working but I have one problem with :
Private Sub CommandButton5_Click() 'Search Button
Could you please check this for Me

thank you

[LeoTaxi]

Hello Kirana

in Sub CommandButton5 change this part

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Kind regards
Leo

[kirana2014]

Hello Leo

Thank you is working

well done

Kirana