Sending data to another workbook with command button

Hello, im trying to send a value of a list box from one workbook to a cell in another workbook and nothing that i can think of seems to work.

At first, i took a random cell in the workbook that contains the list box and gave it the list box value by using Index function with this Office support formula:

Tip: You can use the INDEX function to show an item name instead of a number. In our example, the combo box is linked to cell B1 and the cell range for the list is A1:A2. If the following formula, is typed into cell

Please Login or Register  to view this content.

, when we select the item "Sorbet" is displayed in C1.

Then, ive tried to copy that random cell that contains the value of the list box that i wanted to transfer to an another workbook cell and i just couldnt make it.

tried using this code

Please Login or Register  to view this content.

Massage i keep getting is subscript out of range and other things that wont work, help please!

Try something like this. Change "Sheet1" to suit.

Please Login or Register  to view this content.