Select same row in Listbox based on another Listbox Selected Row

[Michaels]

Hello

I have 2 Listboxes (single-select 1 column) on two Userforms and their row sources are same.

Listbox1 is on Userform1 and Listbox5 on Userform5. Userform5 also has a command button.

When I select a row on Listbox 5 and then click CommandButton1, how can the same row be selected on Listbox1.

I have tried the below code but to no avail.

Userform1.ListBox1.Value = Userform5.ListBox5.Value

Thank you for your help.

 

[Norie]

Perhaps.

Userform1.ListBox1.ListIndex  = Userform5.ListBox5.ListIndex

 

[Michaels]

Hi Norie,

Thanks for your reply and the code. It works . However, in the meanwhile, I tried the below code and its also working. Is the below code for Multi-Select listbox ?

UserForm1.ListBox1.Selected(UserForm5.ListBox5.ListIndex) = True

Thanks