ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Strange problem with a combobox and ListFillRange (https://www.excelbanter.com/excel-discussion-misc-queries/103593-strange-problem-combobox-listfillrange.html)

teddyk

Strange problem with a combobox and ListFillRange
 
I've a strange problem with a combo box. I'll try to explain...
I fill in a Combo Box by a range in a different Workbook, which is of course
open, as far as I settle it ...all is working properly, afterwards, when I
open it again my Combo Box is empty! If I settle again the "LinkFillRange"
simply erasing, f.ex: the 6 in ..$A$6.. and then rewrite it...as it was, all
is working again!!!!!!!!

Help!!!

Ciao
Teddyk


teddyk

Strange problem with a combobox and ListFillRange
 


"teddyk" wrote:

I've a strange problem with a combo box. I'll try to explain...
I fill in a Combo Box by a range in a different Workbook, which is of course
open, as far as I settle it ...all is working properly, afterwards, when I
open it again my Combo Box is empty! If I settle again the "LinkFillRange"
simply erasing, f.ex: the 6 in ..$A$6.. and then rewrite it...as it was, all
is working again!!!!!!!!

Help!!!

Ciao
Teddyk



....find out tanks to ' http://www.ennius.altervista.org/'

it's a matter of priority's file opening

Ciao
Teddyk



All times are GMT +1. The time now is 06:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com