kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
Hello to you all,
I have this code that i am using to populate my combobox when the form initializes. I want to add a new combobox so that in that box i will have the words "one", "two", "three". Then when i select any of those words from the ccombbox, i want only certain sheets to show in the list in the combobox1. How do i code it?
Please help me out with this.
Thanks
Kelly
I have this code that i am using to populate my combobox when the form initializes. I want to add a new combobox so that in that box i will have the words "one", "two", "three". Then when i select any of those words from the ccombbox, i want only certain sheets to show in the list in the combobox1. How do i code it?
Please help me out with this.
Thanks
Kelly
Code:
Private Sub UserForm_Initialize()
Dim ws As Worksheet
For Each ws In Worksheets
Select Case ws.CodeName
Case "Sheet2"
Case Else
End Select
Next ws
End Sub