Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data present
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 -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401881 |
#2
|
|||
|
|||
You can use a dynamic range as the source for the combobox, and it will
automatically expand as you add entries to the list. There are instructions he http://www.contextures.com/xlNames01.html bach wrote: 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 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Will that work if the sheet currently is blank, it only has data in it when a macro is run ?? -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401881 |
#4
|
|||
|
|||
If the sheet is blank, there would be no items in the combobox list.
bach wrote: Will that work if the sheet currently is blank, it only has data in it when a macro is run ?? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
The first instances of the sheet will be blank, the user then gets data 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. -- bach ------------------------------------------------------------------------ bach's Profile: http://www.excelforum.com/member.php...o&userid=26134 View this thread: http://www.excelforum.com/showthread...hreadid=401881 |
#6
|
|||
|
|||
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.Addre ss End Sub There's information about application events at Chip Pearson's site: http://www.cpearson.com/excel/AppEvent.htm bach wrote: The first instances of the sheet will be blank, the user then gets data 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. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How to present the error margin of data set? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions |