Results 1 to 5 of 5

Thread: EXCEL HELP

  1. #1
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    24th February 2024 @ 03:53 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    752
    Threads
    19
    Credits
    357
    Thanked
    40

    Default EXCEL HELP


    Aziz saathion aik excel ka masla hay,
    mujhay yeh poochna tha ke excel mein ham agar aik entry maslan sr. no. 5 par clik krain to us ke sath wali entry automatically color fill hogaye.

  2. #2
    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

    (neechay diyay gaya code alt+f11 kar k us sheet mein paste kardo jis sheet par highlight karna hai to aapka kaam ho jayay gay InshaAllah)

    Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    'Update 20140318
    Static xRow
    Static xColumn
    If xColumn <> "" Then
    With Columns(xColumn).Interior
    .ColorIndex = xlNone
    End With
    With Rows(xRow).Interior
    .ColorIndex = xlNone
    End With
    End If
    pRow = Selection.Row
    pColumn = Selection.Column
    xRow = pRow
    xColumn = pColumn
    With Columns(pColumn).Interior
    .ColorIndex = 6
    .Pattern = xlSolid
    End With
    With Rows(pRow).Interior
    .ColorIndex = 6
    .Pattern = xlSolid
    End With
    End Sub

  3. #3
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    24th February 2024 @ 03:53 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    752
    Threads
    19
    Credits
    357
    Thanked
    40

    Default


    bohat bohat shukria sir,
    mein check karta hoo,
    lekin vb script ke ilawa koi aur tareeqa hoo to wo bhe share kardein

  4. #4
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    24th February 2024 @ 03:53 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    752
    Threads
    19
    Credits
    357
    Thanked
    40

    Default


    Bohat shukria bhai,
    Yeh code bilkul shi kam kar rha hay lekin agar koi or tareeqa bhi ho to wo bhi share kar dein

  5. #5
    sohail1966's Avatar
    sohail1966 is offline Advance Member
    Last Online
    24th February 2024 @ 03:53 PM
    Join Date
    29 Sep 2011
    Gender
    Male
    Posts
    752
    Threads
    19
    Credits
    357
    Thanked
    40

    Default


    Bohat bohat shukria is thread to closed kardia jia.

Similar Threads

  1. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  2. 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

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
  •