with the RowSource property do you include the worksheet reference?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ajit" wrote in message
...
I am playing with add-in's today and sorry to post another add-in question
..

I have a form & data in my xla, which have a listbox with rowsource
property - a range which is also in the add_in(xla). It works perfect when i
run it as xls. but when i attach the xla as add_in and try to open the same
form...it opens but the listbox does not have any value.

Any idea what could be the possible reason.