how to select the sheet name from ddm Solved/Closed

Question

Hello, 
I want to select which sheet to store data from the drop down menu.
thank you .


Private Sub UserForm_Initialize()
Dim i As Integer
For i = 1 To Worksheets.Count
    Me.ComboBox1.AddItem Worksheets(i).Name
Next i
End Sub


Configuration: Windows 7 / Internet Explorer 8.0

rizvisa1 · Answer

you get the value from the combobox. This gives you the sheet name. Once you have the sheet name, you can use

Sheet(comboValue).select 

...

See this 
https://ccm.net/forum/affich-415639-remove-records-once-they-are-transfered#p420034

You need to look at the Private Sub CommandButton1_Click()     routine

How to select the sheet name from ddm

1 response

Similar discussions

Subscribe To Our Newsletter!