wow you consider learner m wondering what your expertise be :O
you all are rockstar here....
thank you very very much for the help....
I crave learning from you wonderful people. Thank you for takin time to
prepare the screen shot tuts
Regards,
Sunita
On Wed, Jul 11, 2012 at 2:53 PM, Deba Ranjan <drdeva...@gmail.com> wrote:
> Its Ok Sunita Ji, You are part of this lovely forum, Definitely help you
> out, Let me tell you, i am also a learner in this group.
> Hence any way , i will send you ASAP by through screen shot step by step
> from the beginning for better understanding. I just preparing it the same.
>
>
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
> ****
>
>
> On Wed, Jul 11, 2012 at 2:32 PM, सुनिता पौडेल <tosune...@gmail.com> wrote:
>
>> Dear Deba ji,
>>
>> Can you please check where I went wrong? Sorry for giving you trouble
>> again and again...
>>
>> Regards,
>>
>> Sunita
>>
>> On Wed, Jul 11, 2012 at 2:35 PM, Deba Ranjan <drdeva...@gmail.com> wrote:
>>
>>> Dear Sunita Ji,
>>>
>>> After Alt + F11,
>>> Go to View And Select Project Explorer,
>>> Selcect Projects Windows too, it will help to change its Properties.
>>> Select the desrie requirements in the Project Explorer, Double click the
>>> desire objects, you will find the codes. And refer the before attached file.
>>>
>>>
>>> Thanks & Regards,
>>> *Deba Ranjan P*
>>>
>>>
>>> ****
>>>
>>>
>>> On Wed, Jul 11, 2012 at 2:15 PM, सुनिता पौडेल <tosune...@gmail.com>wrote:
>>>
>>>> Dear Deba ji,
>>>>
>>>> While I do Alt+f11 blank workbook shows. What to do?
>>>> However I inserted userform and followed upto step 10. Here i got
>>>> stuck. Do I have to copy the codes twice ? I am so blank....
>>>>
>>>> Regrds
>>>>
>>>>
>>>> On Wed, Jul 11, 2012 at 11:06 AM, Deba Ranjan <drdeva...@gmail.com>wrote:
>>>>
>>>>> Dear Sunita Ji,
>>>>>
>>>>> Hope below step may help you, Rest By our Lovely Experts will
>>>>> elaborate you more.
>>>>>
>>>>> 1. Go to Developer
>>>>> 2. Click Insert
>>>>> 3. Button (Form Control)
>>>>> 4. Assign Macros to Buttons
>>>>> 5. View Code (Alt + F11)
>>>>> 6. We need 1 Userform, so insert userform
>>>>> 7. Insert 1 List Box in the userform
>>>>> 8. Insert 3 command buttons in the Userform
>>>>> 9. Insert I checkBox
>>>>> 10.Double click the desrire buttons or List box and Insert the codes.
>>>>> (See the attached file of the user form and codes)
>>>>> 11. Initialize UserForm and write code given below.
>>>>>
>>>>> See the attached file and by pressing Alt + F11 , please see the
>>>>> coding , hope you will understand the basic.
>>>>>
>>>>>
>>>>>
>>>>> Eg:-
>>>>>
>>>>> Option Explicit
>>>>>
>>>>> Public OriginalSheet As Object
>>>>>
>>>>> Private Sub CommandButton1_Click()
>>>>> MsgBox Sheets.Count
>>>>> End Sub
>>>>>
>>>>> Private Sub Label1_Click()
>>>>>
>>>>> End Sub
>>>>>
>>>>> Private Sub UserForm_Initialize()
>>>>> ' Recorded by deba to show Sheet Names
>>>>> Dim SheetData() As String
>>>>> Dim ShtCnt As Integer
>>>>> Dim ShtNum As Integer
>>>>> Dim Sht As Object
>>>>> Dim ListPos As Integer
>>>>>
>>>>> Set OriginalSheet = ActiveSheet
>>>>> ShtCnt = ActiveWorkbook.Sheets.Count
>>>>> ReDim SheetData(1 To ShtCnt, 1 To 4)
>>>>> ShtNum = 1
>>>>> For Each Sht In ActiveWorkbook.Sheets
>>>>> If Sht.Name = ActiveSheet.Name Then _
>>>>> ListPos = ShtNum - 1
>>>>> SheetData(ShtNum, 1) = Sht.Name
>>>>> Select Case TypeName(Sht)
>>>>> Case "Worksheet"
>>>>> SheetData(ShtNum, 2) = "Sheet"
>>>>> SheetData(ShtNum, 3) = _
>>>>> Application.CountA(Sht.Cells)
>>>>> Case "Chart"
>>>>> SheetData(ShtNum, 2) = "Chart"
>>>>> SheetData(ShtNum, 3) = "N/A"
>>>>> Case "DialogSheet"
>>>>> SheetData(ShtNum, 2) = "Dialog"
>>>>> SheetData(ShtNum, 3) = "N/A"
>>>>> End Select
>>>>> If Sht.Visible Then
>>>>> SheetData(ShtNum, 4) = "True"
>>>>> Else
>>>>> SheetData(ShtNum, 4) = "False"
>>>>> End If
>>>>> ShtNum = ShtNum + 1
>>>>> Next Sht
>>>>> With ListBox1
>>>>> .ColumnWidths = "100 pt;30 pt;40 pt;50 pt"
>>>>> .List = SheetData
>>>>> .ListIndex = ListPos
>>>>> End With
>>>>> End Sub
>>>>>
>>>>> Private Sub CancelButton_Click()
>>>>> OriginalSheet.Activate
>>>>> Unload Me
>>>>> End Sub
>>>>>
>>>>> Private Sub cbPreview_Click()
>>>>> If cbPreview Then Sheets(ListBox1.Value).Activate
>>>>> End Sub
>>>>>
>>>>> Private Sub ListBox1_Click()
>>>>> If cbPreview Then _
>>>>> Sheets(ListBox1.Value).Activate
>>>>> End Sub
>>>>>
>>>>> Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
>>>>> Call OKButton_Click
>>>>> End Sub
>>>>>
>>>>> Private Sub OKButton_Click()
>>>>> Dim UserSheet As Object
>>>>> Set UserSheet = Sheets(ListBox1.Value)
>>>>> If UserSheet.Visible Then
>>>>> UserSheet.Activate
>>>>> Else
>>>>> If MsgBox("Unhide sheet?", _
>>>>> vbQuestion + vbYesNoCancel) = vbYes Then
>>>>> UserSheet.Visible = True
>>>>> UserSheet.Activate
>>>>> Else
>>>>> OriginalSheet.Activate
>>>>> End If
>>>>> End If
>>>>> Unload Me
>>>>> End Sub
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Thanks & Regards,
>>>>> *Deba Ranjan P*
>>>>>
>>>>>
>>>>> ****
>>>>>
>>>>>
>>>>> On Wed, Jul 11, 2012 at 9:55 AM, सुनिता पौडेल <tosune...@gmail.com>wrote:
>>>>>
>>>>>> Dear Noorain, Don and all,
>>>>>>
>>>>>> While doing as per your infomation the list of file names shows in
>>>>>> the first sheet. Please teach me as to how to assign a button so that
>>>>>> when
>>>>>> I click it shoes the list box like the one Mr.Deba has attached.
>>>>>>
>>>>>> Thanking all the wonder people,
>>>>>>
>>>>>> Sunita
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Tue, Jul 10, 2012 at 6:44 PM, dguillett1 <dguille...@gmail.com>wrote:
>>>>>>
>>>>>>> Sub listfiles()
>>>>>>> For i = 1 To Sheets.Count
>>>>>>> Cells(i, 1) = Sheets(i).Name
>>>>>>> Next
>>>>>>> End Sub
>>>>>>>
>>>>>>> Don Guillett
>>>>>>> Microsoft Excel Developer
>>>>>>> SalesAid Software
>>>>>>> dguille...@gmail.com
>>>>>>>
>>>>>>> *From:* amitkmr <amitjanku...@gmail.com>
>>>>>>> *Sent:* Tuesday, July 10, 2012 12:41 AM
>>>>>>> *To:* excel-macros@googlegroups.com
>>>>>>> *Subject:* $$Excel-Macros$$ no of sheets in a workbook
>>>>>>>
>>>>>>> Dear Sir,
>>>>>>>
>>>>>>> Do we have a shortcut to know the number and name of the sheets in a
>>>>>>> workbook and also list them in sequence.
>>>>>>>
>>>>>>> Amit Kumar
>>>>>>>
>>>>>>> --
>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>>
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>
>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>>> in signatures are prohibited.
>>>>>>>
>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> To unsubscribe, send a blank email to
>>>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>>>
>>>>>>> --
>>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>>
>>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>>
>>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>>
>>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>>> measure.
>>>>>>>
>>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>>
>>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>>> in signatures are prohibited.
>>>>>>>
>>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>>
>>>>>>> To unsubscribe, send a blank email to
>>>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>>
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>>
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>>
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>>
>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>>> in signatures are prohibited.
>>>>>>
>>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>>> Forum owners and members are not responsible for any loss.
>>>>>>
>>>>>>
>>>>>> ------------------------------------------------------------------------------------------------------
>>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>>
>>>>>> To unsubscribe, send a blank email to
>>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>>
>>>>>
>>>>> --
>>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>>
>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>> Advice will not get quick attention or may not be answered.
>>>>>
>>>>> 2) Don't post a question in the thread of another member.
>>>>>
>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>> measure.
>>>>>
>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>
>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>>>>> in signatures are prohibited.
>>>>>
>>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>>> Forum owners and members are not responsible for any loss.
>>>>>
>>>>>
>>>>> ------------------------------------------------------------------------------------------------------
>>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>>
>>>>> To unsubscribe, send a blank email to
>>>>> excel-macros+unsubscr...@googlegroups.com
>>>>>
>>>>
>>>> --
>>>> FORUM RULES (986+ members already BANNED for violation)
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>>
>>>> 2) Don't post a question in the thread of another member.
>>>>
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>>
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>
>>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>>> signatures are prohibited.
>>>>
>>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>>> Forum owners and members are not responsible for any loss.
>>>>
>>>>
>>>> ------------------------------------------------------------------------------------------------------
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> To unsubscribe, send a blank email to
>>>> excel-macros+unsubscr...@googlegroups.com
>>>>
>>>
>>> --
>>> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> ------------------------------------------------------------------------------------------------------
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> To unsubscribe, send a blank email to
>>> excel-macros+unsubscr...@googlegroups.com
>>>
>>
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
