Dynamic Row source for Combo box on Userform.

hello forum,

i had been trying for some time about providing rowsource for a combo box on a userform.tried with the below code for updating combo box when there are values in the next column.

Please Login or Register  to view this content.

rngdynamic : =OFFSET(Sheet1!$A15,0,0,COUNTA(Sheet1!$A:$A),1)

Where the rngdynamic implies the Named Range in the worksheet SHEET1 .my requirement is to update the combo box with the rowsource when there is data in the next column of the existing column...
Please help me where i m missing the code....

Thanks for the reply but my requirement is not fulfilled dear jindon.
i will elaborate the problem....I had a list in column A...This will be the Rowsource for the combo on the form initially when the form is loaded.
New lists will be added to columns daily from B, C,D, and so.on.
i want the rowsource to be updated for the combo daily..

You want the rowsource from different columns?

Originally Posted by royUK

You want the rowsource from different columns?

yes mr.roy

the code should check the data in the columns,if the data exists in one of these columns say for example,i had copied some data in to column A,the same should be reflected as rowsource in Combo box,next day i had copied data into Column B,then the Rowsource changes to the columnB,like wise,the code should check the last filled column and treat it as Rowsource for the combo....

I think mr.steven is very nearer to my requirement.i m just trying to make necessary changes for the code to work....

WOwww..thats great thanks mr.steven..your code is working great & this is my exact requirement.thanks a lot....