Thanks Mike.Thank you so much.

Mike Fogleman wrote:
For your OptionButton and Jim May's dynamic sheet name list, both can be
done in the UserForm Initialize code:

Private Sub UserForm_Initialize()
Dim ws As Worksheet

For Each ws In Worksheets
Me.ComboBox1.AddItem ws.Name
Next ws

Me.OptionButton1.Value = True
End Sub

Before you ask, the use of Me refers to the object that this code module
belongs to. This is Private code that resides in UserForm1, so Me referes to
UserForm1. If the code belonged to UserForm2 or Sheet1,etc., then Me would
refer to those objects. Kind of a short cut way to write the object's name

Mike F

Thanks,Mike,Its working great.How to enable optionbutton1 as default(true)
,
[quoted text clipped - 25 lines]
code.
How to achieve this?.Any help is sincerely appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200608/1