Qalabka caadiga ah ee Microsoft Excel, waxaa jira siyaabo badan oo kala duwan oo lagu muujiyo nuqullada midabka leh. Habka ugu fudud uguna dhaqsiyaha badan waa qaabaynta shuruudaysan. Si tan loo sameeyo, kaliya dooro unugyo kala duwan oo dooro tab Guriga - Qaabka Shuruuda ah - Xeerarka Xulashada Unugyada - Qiimaha Kooban (Guriga - Qaabaynta Shuruudaha ah - Xeerarka Unugyada Iftiimin - Qiimaha Kooban):
Si kastaba ha ahaatee, kiiskan, midabka buuxinta dhammaan unugyada ayaa isku mid noqon doona, tusaale ahaan waxay si fudud u tilmaamaysaa in curiyaha uu leeyahay nuqul ka mid ah meel kale oo kala duwan, laakiin waxba ma caawinayo helitaankooda. Waxaad xaalada ku hagaajin kartaa makro yar oo buuxin doona lamaane kasta (ama ka badan) nuqulo soo noqnoqda oo midabkeeda leh:
Si aad u cad, sax? Dabcan, tiro badan oo unugyo ah oo soo noqnoqda, way adkaan doontaa in la kala saaro hadhka, laakiin tiro yar oo nuqul ah, habkani wuxuu u shaqeyn doonaa si fiican.
Si aad marookan u isticmaasho, taabo furaha kiiboodhka Alt + F11 ama badhan Visual Basic tab Developer, geli module cusub oo madhan iyada oo loo marayo menu-ka Geli - Module oo koobi ka samee koodka makro-kan:
Duplicates Sub DuplicatesColoring() Dim Dupes()' Ku dhawaaq array si aad u kaydiso nuqulada Dib-u-Dim Dupes(1 Si loo Xulo Xulashada If WorksheetFunction.CountIf(Selection, cell.Value) > 1 Ka dibna loogu talagalay k = LBound (Dupes) UBound(Dupes) 'haddii unuggu uu horay ugu jiray soo diyaarinta nuqullada, buuxi Haddii Dupes(k, 2) = unug Ka dibna unug.Gudaha. ColorIndex = Dupes(k, 4142) Marka xigta k 'haddii unuggu ka kooban yahay nuqul, laakiin aan weli ku jirin shaxanka, ku dar array oo buuxi Haddii unugga.Interior.ColorIndex = -3 Ka dibna cell.Interior.ColorIndex = i Dupes(i, 1 ) = unug
Hadda waxaad dooran kartaa kala duwanaansho kasta oo xogta ku jirta xaashida oo aad ku socodsiiso makro-kayaga adoo isticmaalaya furaha kiiboodhka Alt + F8 ama badhanka la mariyo Macro (Macros) tab sameeysa (horumariye).
- Ku muuji nuqullada midabka leh
- Waa maxay macros, halka laga geliyo macro code gudaha Visual Basic, sida loo socodsiiyo
- Sida loo tiriyo tirada qiyamka gaarka ah ee unugyo kala duwan oo la siiyay