Page 1 of 2 12 LastLast
Results 1 to 12 of 13

Thread: excel v.b help

  1. #1
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default excel v.b help

    aoa

    koi mujhe bata sakta hai k mein excel mein kisi cell mein pakistan likhta hoon to us ka result dosray kisi cell mein *pakistan* automatic show ho jayay v.b k zariyay.concatenate se to yeh ho raha hai magar mujhe resul jis cell mein show ho wahan par formul nahi chahiyay hai

  2. #2
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    wao,

    Kissi cell say kia murad hay ??? suppose you write pakistan in cell A2 aur aab chahtay ho kah C5 main Pakistan likah jay ???? agar A2 main Pakistan likh kar enter kia to C5 update ho jay ya phir macro button kay thru run ho ...... zara details ho jay to kuch samjh main baat aay .....

  3. #3
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    you can use below macro ....

    Sub appear()

    If Range("B2").Value = "PAKISTAN" Then
    Range("K5").Value = "*PAKISTAN*"
    Else
    Range("K5").Value = ""
    End If

    End Sub
    Yah macro check karay gi kah agar B2=PAKISTAN kay to K5main *PAKISTAN* likh day warna "" blank ......

    If you want automation then put this code here in worksheet module, iss kay zariye jaisay he aap B2 main kuch likh kar enter karain gay to yah check karay ga agar pakistan hay to above steps repeat kar day ga

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Range("B2").Value = "PAKISTAN" Then
    Range("K5").Value = "*Pakistan*"
    Else
    Range("K5").Value = ""
    End If
    End Sub

  4. #4
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default pls help me in Excel

    hello frend of IT Dunya kia ap meri help kare ga me ne ek balance sheet bnani ha MS Excel me mujh ko ye btaye k Debter, Credit ka kon sa aisa formula lgay ga k debit or credit sath likha aye plz ager ap jante ho to mujh ko btao me ne Company ki balance sheet bnani ha Excel me
    rply me on my ID: shahleo_pak**********
    pls ye b btana k excel me debt, credit ka formula kaisay bnayen ge pls lazmi btana
    i m waiting................
    ur welwisher
    Shah

  5. #5
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    hello frend of IT Dunya kia ap meri help kare ga me ne ek balance sheet bnani ha MS Excel me mujh ko ye btaye k Debter, Credit ka kon sa aisa formula lgay ga k debit or credit sath likha aye plz ager ap jante ho to mujh ko btao me ne Company ki balance sheet bnani ha Excel me
    rply me on my ID: shahleo_pak**********
    pls ye b btana k excel me debt, credit ka formula kaisay bnayen ge pls lazmi btana
    i m waiting................
    ur welwisher
    Shah

  6. #6
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Welcome to ITD,

    Mairay dost aap apna thread alag say shuru karain kissi aur kay thread main aap apni problem naheen likh saktay hain ....
    pap please smaple file bhi attach kar dain main aap ko formula's laga kar bhaij doon ga .....

  7. #7
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    yeh code button par apply karoon ya phir..kisi aur object par?
    thora sa detail mein samjha dein please

    mein chahta hoon k mein b2 mein pakistan/india ya kuch bhi likhon to cell b3 ke andar *pakistan* is tarha se show ho jayay.

  8. #8
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    aap ko excel main modules kay insert karnay ka pata hay ka naheen ????
    Doosra aap B2 main jo text chahtay hain wohi B3 main appear ho ya phir hamaisha *pakistan* likha howa aay ???

    Aap module ko kissi button par bhi apply kar kay run kar saktay hain ya phir worksheet kay default modules main likh kar bhi ..... aap thor say mujhay batain kah aap kiss level par macro par kaam kar rhay hain ... actually i'm not very expert in macro because i always try to work with worksheet functions which are easy to understand for others ....

  9. #9
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    Sub appear()

    If Range("B2").Value <> "" Then
    Range("K5").Value = "*" + Range("B2").Value + "*"
    Else
    Range("K5").Value = ""
    End If

    End Sub


    THANKS BHAI MERA MASLA IS KO KARNAY SE SOLVE HO GAYA HAI.

  10. #10
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    Agar Yehi Auto Kaam Karay To Aap Kuch Help Kar Dein

  11. #11
    Mubashir Aziz's Avatar
    Mubashir Aziz is offline Senior Member+
    Last Online
    6th May 2011 @ 06:39 PM
    Join Date
    17 Mar 2009
    Posts
    588
    Threads
    27
    Credits
    0
    Thanked
    6

    Default

    Aap Alt+F11 ko press kar kay vb mode main jain gay to aap ko left side par sheet1
    sheet2
    likha aai ga
    aab aap jiss sheet par issay lagana chahtay hain tou uss sheet ko click karain
    phir left side par jahan General likh aa raha hay ussay clickkar kay Worksheet select karain
    iss kay baa uss say agaly dropdown say change ko select karain
    aap kay pass yah code likha aa jay ga

    Private Sub Worksheet_Change(ByVal Target As Range)

    End Sub

    aap iss kay darmiya main apna code enter karain dain ...aab har change par yah module B2 ka check karay ga ....

  12. #12
    sajidbagi is offline Senior Member+
    Last Online
    1st February 2023 @ 06:54 PM
    Join Date
    04 Jan 2009
    Posts
    225
    Threads
    20
    Credits
    1,200
    Thanked
    5

    Default

    Private Sub Worksheet_Change(ByVal Target As Range)

    If Range("B2").Value <> "" Then
    Range("K5").Value = "*" + Range("B2").Value + "*"
    Else
    Range("K5").Value = ""
    End If
    End Sub



    DONE...THANK YOU SO MUCH MUBASHIR BHAI JAZAKALLAH

Page 1 of 2 12 LastLast

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  3. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04:28 PM
  4. Need Help in excel
    By nsm1870 in forum Solved Problems (IT)
    Replies: 4
    Last Post: 16th March 2010, 11:02 AM

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
  •