Displaying all sheets in a workbook using a combo box
Posted by Bill Muirhead on June 27, 2001 1:24 PM
I've written a user form that allows expense sheets to be filled and calculated using a combination of text boxes and option buttons. The sheets are then copied and a new sheet created so that over a period of time a collection of sheets builds up. I would like to add the facility to print a sheet by choosing it from a combo box on the form. Is there a way to populate a combo box with the names of the sheets that exist so far and have this update as new sheets are added?
Am I going about this in the wrong way?