Data present

B

bach

Hi,

I need to copy all information either in a colum or in a range across
to another sheet or a combo box.

Example I have a colum populating a combo box so when data is added to
this will update the combo box. I get a combo box with a lot of blank
enteries, because I have selected the whole colomn.

Is there a way to check how many rows in that coloum have data in them
and update this to the combox???


Bach
 
B

bach

Will that work if the sheet currently is blank, it only has data in i
when a macro is run ?
 
B

bach

The first instances of the sheet will be blank, the user then gets dat
via a macro and from then on data is always present.

Or could it be done in VBA using the control drop-down list object.

Bach
 
D

Debra Dalgleish

If you're using the combo box from the Control Toolbox, you could use an
event procedure to update the list. For example:

Private Sub Worksheet_Activate()
Me.ComboBox1.ListFillRange = _
ActiveWorkbook.Names("MyList").RefersToRange.Address
End Sub

There's information about application events at Chip Pearson's site:
http://www.cpearson.com/excel/AppEvent.htm
 
Top