Combobox Rowsource

[Mahal]

Hi guys. I'm trying to set the rowsource of my combobox to data on a worksheet. The range of cells I want to refer to is dynamic, but I don't want to refer to a range. Here's what I have and I'm not sure why it's not working:
Dim toEnd As Double

toEnd = 5

Do Until Sheets("Trial Balance").Cells(toEnd, 2) = Empty
toEnd = toEnd + 1
Loop

frmTransEntry.cbx1.RowSource = "'Trial Balance'!b5:b" & toEnd - 1

Any help?

 

[GS]

Hi guys. I'm trying to set the rowsource of my combobox to data on a

worksheet. The range of cells I want to refer to is dynamic, but I
don't want to refer to a range. Here's what I have and I'm not sure
why it's not working: Dim toEnd As Double

toEnd = 5

Do Until Sheets("Trial Balance").Cells(toEnd, 2) = Empty
toEnd = toEnd + 1
Loop

frmTransEntry.cbx1.RowSource = "'Trial Balance'!b5:b" & toEnd - 1

Any help?

I don't see why you can't use the name of the dynamic range since, if
properly defined, it will only contain data within its boundaries.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mahal]

Never mind. Got it.