ComboBox ListFillRange whit list from another workbook

Thank you for The reply, but it doesn't Work: I have tried both methods:

'[ExampleList.xlsm]Sheet1'!A1:A30 

And the formula of the linked cells, but when I paste it in to listfillrange Field and Press enter, The Field return empty

You can only directly use the ListFillRange in another workbook while the other workbook is open so it is best to set up a link to the source data list and this link will update when the source workbook is not open. This is the best method even if you want to have both workbooks open simultaneously.

1. Open both workbooks
2. Select the workbook containing the list
3. Select the range containing the list and Copy
4. Change workbooks to the one with the ComboBox
5. Select the first cell of the range where you want the list (Can be on different worksheet to the ComboBox)
6. Right click and select Paste Special -> Paste Link.
7. Now the ListFillRange will be something like the following (Which from your question you already know.)

Sheet2!A1:A30

If you have any spaces in the worksheet name like the following then enclose the sheet name in single quotes.

'Sheet Two'!A1:A30

If you always want both workbooks open then you could use something the following for the ListFillRange

'[Example List.xlsm]Sheet1'!A1:A30

You can get most of the syntax from the first cell of the previous explanation. Select the first cell of the linked data and copy the formula in the formula bar (but NOT the equals sign). It will only have the first cell of the range so just edit it in the ListFillRange field and add the colon and last cell of the range.

Would you like to upload both files to OneDrive and I will have a look at them because it works for me. (It is nearly 9pm in my part of the world and I have some other stuff on tonight so it will be tomorrow before I look at them.)

Guidelines to upload a workbook on OneDrive. (If you already use OneDrive and your process for saving to it is different then you can probably start at step 8 to get the link but please zip the file before uploading.)

1. Zip your workbooks. Do not just save an unzipped workbook to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected files and select Send to -> Compressed (zipped) folder). By holding the Ctrl key and left click once on each file, you can select multiple workbooksbefore right clicking over one of the selections to send to a compressed file and they will all be included into the one Zip file.
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Select "Get a Link" from the popup menu.
10. Click in the field displaying the link and Ctrl and A should highlight the entire link and then Copy and Paste the link into your reply on this forum. (I suggest that you avoid the "Copy" button on the "Get a link" screen because it introduces additional steps that are not required.)

No, I placed both files on desktop folder

If you have followed my guidelines then I don't know what the problem is. Maybe because it is at a remote location "Dropbox"