Quickly enter a series of numbers or text-and-number combinations. Select the cell that contains the starting number or text-and-number combination. Drag the fill handle over the cells that you want to fill. Click the Auto Fill Options smart button, and then do one of the following. How to auto populate dates in Excel. If you need to insert dates in a range of cells, you can let Excel 'auto date' a column or row by using the AutoFill feature. Auto fill a date series that increases by one day.
![Excel Excel](/uploads/1/2/5/6/125639433/145753593.png)
How do you populate a combobox with values from a given range on a mac. I have been searching for answers for the last hour but none of the solutions seem to be working. I have a userform called Details and a combobox called CurrencyList that I would like to populate with values from A23:A30. There is no rowsource property that I can find.
I tried using the answer from as follows: Private Sub DetailsInitialize Me.CurrencyList.List = Worksheets('mySheet').Range('A23:A30').Value End Sub but the combo box comes up empty. Thank you for any help, Im sure its a very easy question!