Wilfried_1983
New Member
- Joined
- Jul 17, 2008
- Messages
- 15
Hello there,
My first post on this forum! I am a VBA newbie and trying to program my first macro.
What I want to do is have a ComboBox (I think it should be a ComboBox, I want the user to be able to select multiple options at once) and display the names of the worksheets in the ComboBox. I could not find a way to do this directly with rowsource and thought about writing a loop to check the current worksheets with their names and put the values into cells, to this way have the names displayed in the ComboBox via rowsource?
Your help will be much appreciated
My first post on this forum! I am a VBA newbie and trying to program my first macro.
What I want to do is have a ComboBox (I think it should be a ComboBox, I want the user to be able to select multiple options at once) and display the names of the worksheets in the ComboBox. I could not find a way to do this directly with rowsource and thought about writing a loop to check the current worksheets with their names and put the values into cells, to this way have the names displayed in the ComboBox via rowsource?
Your help will be much appreciated