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, when we select the item "Sorbet" is displayed in C1.Please Login or Register to view this content.
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
Massage i keep getting is subscript out of range and other things that wont work, help please!Please Login or Register to view this content.
Bookmarks