Page 39 of 91 FirstFirst ... 29363738394041424989 ... LastLast
Results 457 to 468 of 1085

Thread: Excel Help Line مائیکرو سافٹ ایکسل ہیلپ لائن سینٹر

  1. #457
    uzair2020's Avatar
    uzair2020 is offline Senior Member+
    Last Online
    17th February 2024 @ 06:58 PM
    Join Date
    31 Jul 2008
    Age
    39
    Posts
    164
    Threads
    27
    Credits
    1,722
    Thanked
    8

    Default faraz problem

    faraz bhai ek koshish ki hai ap ki problem solve karnay ki.
    Attached Images Attached Images  
    Attached Files Attached Files

  2. #458
    uzair2020's Avatar
    uzair2020 is offline Senior Member+
    Last Online
    17th February 2024 @ 06:58 PM
    Join Date
    31 Jul 2008
    Age
    39
    Posts
    164
    Threads
    27
    Credits
    1,722
    Thanked
    8

    Default

    salam syar bhai mujhe excel main kuch problem thi or ek thread share ki thi per koi jawab nahi mila. ap ko link send kar raha hon plz help.



    http://http://www.itdunya.com/t352475/#post3657392

  3. #459
    faraz_24 is offline Junior Member
    Last Online
    10th November 2016 @ 01:34 AM
    Join Date
    19 Nov 2009
    Age
    38
    Posts
    4
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    thnx dear............bht bht shukriya apka.........mjhe lgta hai ke ye zaror kam karega....In Sha Allah........

  4. #460
    faraz_24 is offline Junior Member
    Last Online
    10th November 2016 @ 01:34 AM
    Join Date
    19 Nov 2009
    Age
    38
    Posts
    4
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    is mai ek masla ha...mjhe aise kahe sheet banane hote hai..ek ke bd ek.....isliye jb mia neche use copy paste krta hon...to formula ke range change hojate hai......kya ya range constant nahe rh sakti....

  5. #461
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote faraz_24 said: View Post
    is mai ek masla ha...mjhe aise kahe sheet banane hote hai..ek ke bd ek.....isliye jb mia neche use copy paste krta hon...to formula ke range change hojate hai......kya ya range constant nahe rh sakti....


    Replace your formula with this one and copy down as per attached by UZAIR

    in D46
    Code:
    =VLOOKUP($B$46,$B$2:$E$33,ROW(A2),FALSE)

  6. #462
    faraz_24 is offline Junior Member
    Last Online
    10th November 2016 @ 01:34 AM
    Join Date
    19 Nov 2009
    Age
    38
    Posts
    4
    Threads
    0
    Credits
    0
    Thanked
    0

    Default

    thnx dear...............:-)
    ye work krta hai.....:-)

  7. #463
    Rahmat Elahi's Avatar
    Rahmat Elahi is offline Senior Member+
    Last Online
    20th October 2015 @ 04:38 PM
    Join Date
    01 Nov 2012
    Location
    CHITRAL
    Age
    30
    Gender
    Male
    Posts
    102
    Threads
    9
    Credits
    0
    Thanked
    7

    Thumbs up NIce

    Bhut Khoob dosto Excellent

  8. #464
    uzair2020's Avatar
    uzair2020 is offline Senior Member+
    Last Online
    17th February 2024 @ 06:58 PM
    Join Date
    31 Jul 2008
    Age
    39
    Posts
    164
    Threads
    27
    Credits
    1,722
    Thanked
    8

    Default

    Quote uzair2020 said: View Post
    salam syar bhai mujhe excel main kuch problem thi or ek thread share ki thi per koi jawab nahi mila. ap ko link send kar raha hon plz help.



    http://http://www.itdunya.com/t352475/#post3657392

    salam syar bhai thanx k ap ne meri thread daikhi or reply kiya per ap ne kaha k
    excel main column range k ealawa kisi or column main autocomple function kam
    nahi karta."excel combo box" se meri problem solve ho chuki hai.
    Attached Images Attached Images  

  9. #465
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote uzair2020 said: View Post
    salam syar bhai thanx k ap ne meri thread daikhi or reply kiya per ap ne kaha k
    excel main column range k ealawa kisi or column main autocomple function kam
    nahi karta."excel combo box" se meri problem solve ho chuki hai.
    wasalam,

    Thanks for sharing. Actually m n jo aap ko kaha tha wo jese aap kah rahe the k list m lekhain aur auto complete ho tu us k leye kaha tha. Aur m n bhe aap ko dosri bar Combo BOx ka mashwara deya lekan light chale gai the jis ki wajha sa reply submit nahee ho saka. Aur phr m bhool gaya tha. Maqsad aap ka problem solve karna tha which i m glad k ho gaya ha. Yahan hm sab apne knowledge share karte hain, aur aik dosre sa sekhte hain.

    Thanks & regards,

  10. #466
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote uzair2020 said: View Post
    salam syar bhai thanx k ap ne meri thread daikhi or reply kiya per ap ne kaha k
    excel main column range k ealawa kisi or column main autocomple function kam
    nahi karta."excel combo box" se meri problem solve ho chuki hai.
    Aur ak totka bhe ha refer to http://www.itdunya.com/t285870/
    Code:
    for VBA solution follow ( I assume you are familiar with excel commands & VBA therefore i shorten the procedure)
     
    Step1.
     
    Apni list ko formula---->define name----> ka zarye as "list1" define karain.
     ( I also assume your list on sheet 1)
     Step2
     1. Press alt+F11 to open VBA editor Window
     2. Insert ka menu m sa form select karain. Ye form ki window open karai ga. Form ko apni marzi ka mutabiq resize kar lain
     3. left corner m form ki propoerties hote hain is m caption ki field m "Choose a Value" lekhai
     4. Toolbox m se combobox ko select karain aur form m apni marzi ka size ka toolbox bana lain.
     5. combobox ki propoerties m "ROWSOURCE" ki field m "sheet1!list" type karain.
     6. Toolbox m se command button ko select kar ka form m add karain.
     7. Command button ki propoerties m ja kar Caption ki field m OK select karain kyun k button sa ok Ka kam lena ha.
     8. button ki propoerties ma caption ka neeche "Default" ki field ko "TRUE" kar dain.
     9. Form m command button par right click karain aur "viewcode" ko select karain. is ki window m mojood code ko is code se replace kar dain.
     
    
    Code:
    Private Sub CommandButton1_Click()
    ActiveCell.Value = Me.ComboBox1.Value
    Unload Me
    
    End Sub 10. again Insert k menu m sa Module select karain aur ye code paste kar dain
     
    
    Code:
    Sub ChooseValue()
    UserForm1.Show
    End Sub 11. Close VBA editor window
     12. Developer k tab m sa Macro Select Karain. aap ko "Choose value" ki macro nazar aae gi. is ko select karain aur option m jain.
     13. option m shortcut key m ctrl+"l" (L) assign kar dain.
     
    ab jab bhe aap ko kahain paris list m sa name type karna ho tu "CTRL+L" press karain ge tu aap ki list aa jae ge aur ap pehle 2 ya 1 lafz type karain ge tu aap ko suggestion mil jae gi jesa aap chahte hain.AAp ko validation list ki zaroorat nahee rahe gi.
     
    " Mujh sa screen shot nahee bante is leye sorry." agar phir bhe masla ho tu apni file upload kar dain m kar daita hon. Is ka elawa bhee aik aur method ha jo ka is sa bhee pecheda ha. I hope this will help you.
     
    regards
     syar

  11. #467
    uzair2020's Avatar
    uzair2020 is offline Senior Member+
    Last Online
    17th February 2024 @ 06:58 PM
    Join Date
    31 Jul 2008
    Age
    39
    Posts
    164
    Threads
    27
    Credits
    1,722
    Thanked
    8

    Default

    Quote syar said: View Post
    Aur ak totka bhe ha refer to http://www.itdunya.com/t285870/
    Code:
    for VBA solution follow ( I assume you are familiar with excel commands & VBA therefore i shorten the procedure)
     
    Step1.
     
    Apni list ko formula---->define name----> ka zarye as "list1" define karain.
     ( I also assume your list on sheet 1)
     Step2
     1. Press alt+F11 to open VBA editor Window
     2. Insert ka menu m sa form select karain. Ye form ki window open karai ga. Form ko apni marzi ka mutabiq resize kar lain
     3. left corner m form ki propoerties hote hain is m caption ki field m "Choose a Value" lekhai
     4. Toolbox m se combobox ko select karain aur form m apni marzi ka size ka toolbox bana lain.
     5. combobox ki propoerties m "ROWSOURCE" ki field m "sheet1!list" type karain.
     6. Toolbox m se command button ko select kar ka form m add karain.
     7. Command button ki propoerties m ja kar Caption ki field m OK select karain kyun k button sa ok Ka kam lena ha.
     8. button ki propoerties ma caption ka neeche "Default" ki field ko "TRUE" kar dain.
     9. Form m command button par right click karain aur "viewcode" ko select karain. is ki window m mojood code ko is code se replace kar dain.
     
    
    Code:
    Private Sub CommandButton1_Click()
    ActiveCell.Value = Me.ComboBox1.Value
    Unload Me
    
    End Sub 10. again Insert k menu m sa Module select karain aur ye code paste kar dain
     
    
    Code:
    Sub ChooseValue()
    UserForm1.Show
    End Sub 11. Close VBA editor window
     12. Developer k tab m sa Macro Select Karain. aap ko "Choose value" ki macro nazar aae gi. is ko select karain aur option m jain.
     13. option m shortcut key m ctrl+"l" (L) assign kar dain.
     
    ab jab bhe aap ko kahain paris list m sa name type karna ho tu "CTRL+L" press karain ge tu aap ki list aa jae ge aur ap pehle 2 ya 1 lafz type karain ge tu aap ko suggestion mil jae gi jesa aap chahte hain.AAp ko validation list ki zaroorat nahee rahe gi.
     
    " Mujh sa screen shot nahee bante is leye sorry." agar phir bhe masla ho tu apni file upload kar dain m kar daita hon. Is ka elawa bhee aik aur method ha jo ka is sa bhee pecheda ha. I hope this will help you.
     
    regards
     syar

    jazakallah syar bhai
    bohot umda tareeqay se ap ne samjhaya hai or jo tareeqa ap ne bataya wo bohot usefull hai meray liye. umeed hai k ap apnay students ki isi tarah rahnumai kartay rahingay.

  12. #468
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote uzair2020 said: View Post

    jazakallah syar bhai
    bohot umda tareeqay se ap ne samjhaya hai or jo tareeqa ap ne bataya wo bohot usefull hai meray liye. umeed hai k ap apnay students ki isi tarah rahnumai kartay rahingay.
    wasalam,
    Thanks for feed back. Ya aap sab logon ki help he sa mumkin hota he. aur m teacher nahee hon, just a friend.

    Lekan students ko bhe kabhe kabhe fees dene k bare m bhe sochna chaheye.

Page 39 of 91 FirstFirst ... 29363738394041424989 ... LastLast

Similar Threads

  1. Replies: 12
    Last Post: 2nd March 2011, 09:56 PM
  2. Excel & Word Guide Line
    By Mubashir Aziz in forum General Discussion
    Replies: 10
    Last Post: 30th March 2009, 01:15 PM
  3. Replies: 1
    Last Post: 24th January 2009, 07:32 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •