I am trying to populate a combo box with no's 1 to 100. What's the best way of add this text to combo box w/o typing
cmbNo.Additem "1"
cmbNo.Additem "2" etc. till 100. i.e. I want to automate the no. generation

Sorry for my ignoreance but your help is much appreciated.