Regouin
03-14-2005, 01:21 AM
I want to populate a Combobox with only the cells that contain data within a certain range, say (A2:A44). Now the sheet would look like this
Monthly
grease ball bearings
grease conveyor belt
3-Monthly
refill oil
Yearly
change conveyor belt
4-Yearly
change ball bearings
now the amount of maintenance tasks can vary so instead of 1 or 2 I want to be able to add a maintenance task and have the combobox pick it up.
Preferably I would like to have the combobox not show the monthly, 3-monthly, yearly and 4-yearly but only the maintenance tasks.
Any help would be appreciated, What I have now is that it points to certain cells but when you add one task i doesnt pick it up.
TIA
Frank
Monthly
grease ball bearings
grease conveyor belt
3-Monthly
refill oil
Yearly
change conveyor belt
4-Yearly
change ball bearings
now the amount of maintenance tasks can vary so instead of 1 or 2 I want to be able to add a maintenance task and have the combobox pick it up.
Preferably I would like to have the combobox not show the monthly, 3-monthly, yearly and 4-yearly but only the maintenance tasks.
Any help would be appreciated, What I have now is that it points to certain cells but when you add one task i doesnt pick it up.
TIA
Frank