• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    shortcut for increase and decrease font size in excel

    how to increase and decrease font size in excel with shortcut i use office 2003,
  2. K

    highlight word list

    my data in two column column A column B jiagar vipul viral bantu pintu mahesh manish jiagar aku vrajesh mahesh hemang bantu rashesh vipul axesh hitesh gaurang now i want to higlight same name in column A list compare with Column B how
  3. K

    scrabbel game

    i want to create scrabble game (spelling game) how to make in excel i use excel 2003 any vba code
  4. K

    convert digit

    suppose i write 10,000,000 in cell B10 so automatically result shown in cell B10 is 100 lacks another exmple is suppose i write 20,00,000 so result shown as 200 thousand in cell B10 how it possible
  5. K

    worksheet password

    i forgot worksheet1 password so i need vba code to reset password for worksheet1 how to i use office 2003
  6. K

    exit excel

    how to exit excel when i click a button the excel was close any macro
  7. K

    check box

    in sheet1 i will create button to print out data in sheet 1 but my probelm some time i need 2 copy of print so need to make checkbox when i check checkbox print 2 copy othrwise print 1 copy. how it possible
  8. K

    print copy

    i want to print 2 copy of worksheet 1 page 1 Only for macro pls give me a macro
  9. K

    hide column

    if worksheet 1 in " A1 " cell enter any value than cursor move other cell otherwise massage box shown " enter any value " give me vba macro for this problem how it possible
  10. K

    listbox item select

    i create listbox in "A1" cell name is "Mode" listbox contain 5 item is Mode,Sale, Purchase, Payment, Receipt now, problem is when i select item "sale" in list box the column "C", "D" was hide when i select item purchase Column "E", " F" was hide when i select "Mode" all column is shown...
  11. K

    round off

    i want roundoff function use in cell A10 only how
  12. K

    round off

    cell A10 contian formula sumof a1:a9 & sum is 945.67 now my probelm is Roundoff in cell A10 result is shwon 946.00 how
  13. K

    multiple sheet pivot table

    sheet1 name sales sheet2 name purchase sheet sales data below Date Billno Party Paritcular Qty Rate Amount 1-2-12 12021 vipul r mango 25 100 2500 3-2-12 24560 mahesh vanila 20 50 1000 10-2-12 65696 hitesh sitafal 40 40 1600 sheet2 purchase data below Date Billno Party Paritcular...
  14. K

    list box item

    sheet1 in A column create l list name is item contain a2:a5000 look like below ball bat hocky ball bat carrom vollyball football hocky carrrom...... and B1 cell cotain validatiion list item now my problem is B1 cell show double item like bat 2 time carrom 2 time how
  15. K

    lock cell

    my problem is when i enter any value in cell "A1" then cursor move other cell otherwise message shown pl enter any value again i enter any value in cell "E5" then cursor move other cell otherwise message box shown
  16. K

    column hide

    like to hide all column except column "A,B,C,D" in worksheet 1 is active this only for macro how
  17. K

    scroll window

    it means scrollbar shwon only to "H" Column
  18. K

    scrollbar hide

    i create a macro to hide scrollbar vetical & horizontal when sheet1 is active but problem is all other sheets scrollbar is hide why
  19. K

    freezpane set macro

    how to set freezpane in sheet1 for column m2 with macro only
  20. K

    scroll window

    any idea for scroll window only "H" column. so left column do not shown & scroll only "H" column. how
  21. K

    scroll area

    l would like to lock scroll area in sheet1 in range A1:H10 when sheet 1 i activate the code is given under Sub LockArea() Worksheets(1).ScrollArea = "A1:F10" End Sub Private Sub Worksheet_Activate() Call LockArea End Sub but problem is when file is close & again open this file...
  22. K

    zoom macro

    nice answer thanks for help
  23. K

    zoom macro

    ANY Macro for zoom for worksheet1 is 150% zoom
  24. K

    hide menubar

    but what sheet name is write & workbook macro error for sheetname
  25. K

    condtion for run macro

    thank u very much code work nicely
Back
Top