• 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.

Recent content by kalpeshpatel

  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
Back
Top