Selected Listbox item select in sheet cell

[tlchan]

Hi there,

I have problem of click on listbox to select the corresponding cell in worksheet which return error message "Run time error 1004-method 'Range of object'_worksheet failed"


what the error message means? I hope VBA guru will help me out.

Thanks

sample file enclosed

[jolivanes]

Something like this maybe (see attached)

[tlchan]

Yes this what I'm looking around.

Thanks jolivanes. You are great.