How to get Sheet list?

[bhandari]

i am getting error,can i get some help here.how to collect the worksheet names in listbox by using macro?

i have around 20 sheets..i am planning to add few more sheets instead of finding all the sheets i want to find it through list box..

by using command buttons and listbox.

 

[bhandari]

is it possible to create sheet tabs by using cell reference
A1=200+000
A2=245+688
A3=658+555
by using range property
i got it..can you please solve this small issue,i wan looking for macro

 

[My Aswer Is This]

Well this is a copy of your other posting so we should be answering this question in your other post.
But you need to explain in more detail what you want. I do not understand:

is it possible to create sheet tabs by using cell reference
A1=200+000
A2=245+688
A3=658+555
by using range property

You want to create new sheets?

 

[bhandari]

lets move to that post no 1 is responding to tht post thast y iam trying to ask yu..i will give details there

 

[bhandari]

is there any way to select sheet tab by clicking command button to delete sheet tab @My Aswer Is This

 

[My Aswer Is This]

Assuming your now wanting to delete sheets.

Select the sheet name from the listbox and run this script.

Private Sub CommandButton2_Click()
Dim i As Long
Sheets(ListBox1.Value).Delete
ListBox1.Clear
    For i = 1 To Sheets.Count
        ListBox1.AddItem Sheets(i).Name
    Next
End Sub