• 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

    List column details to be displayed in 3 text boxes

    Guys, I have got the answer for my self. Sorry for troubling. Pls ignore the post Rgds, KK
  2. K

    List column details to be displayed in 3 text boxes

    Hi Everyone! I prepared a userform through excel and stuck to action an option. I have an excelsheet, "List" with details from A1 to B10(row data keeps extends) and I have created a userform and linked the data source as per the list and now the list displays with all the information in 3...
  3. K

    Zip the current excel sheet and send email

    Hi there, I have written a macro and assigned to a button on the excel. Once I clik on the button, the current excelworkbook goes as an email. Now, the challenge is with the size of the file. As its a huge file, is there any way that once I click on the button it automatically zip the file...
  4. K

    Font color and underline for a single word in a checkbox

    Hi there, I have created a form on a excel spreadsheet and need your assistance in finishing it. I have inserted a checkbox with caption as Financial ledger balances for corporate. Now I want the ledger balance be displayed in blue and underline and the rest be in black in color. I tried...
  5. K

    Somebody breaks my macro's password .......HELP :(

    Hi Sreekhosh, I dont think you can protect the macros permanently as there are lot of softwares available in the market to crack the passwords. Regards, KK
  6. K

    cheat

    Hi there, I have done online VBA course with Chandoo.org and it was quite good. It would be great if you could mail to chandoo about your concern instead posting like this. Chandoo is a master for all of us and it doesn't feel good if someone tells like this. Regards, KK
  7. K

    Removing all hyperlinks

    Hi Debraj, Tat was fantastic trick. thanks everyone for your support! Regards, KK
  8. K

    Removing all hyperlinks

    Hi All, I just found that there is no direct option to clear all hyperlinks at once! The only option is macros. Thanks for all of your efforts in trying to get the answer. Regards, KK
  9. K

    username and password

    No worries. Pleasure to get to know various excel scenarious. Regards, KK
  10. K

    Removing all hyperlinks

    Nope, doesn't work. Only the link highlight color(blue) has gone and not the hyperlink. Any solution please!? Regards, KK
  11. K

    Removing all hyperlinks

    Hi Bobhc, I cant see remove hyper links option when I select all cells. It appears only when I right click on single cell. Appreciate for any answer to it! Regards, KK
  12. K

    username and password

    Hi Gopikrishna, Here is the macro to it. Suppose you have spreadsheets like Kiran, Rohith.... example: Login details for Kiran sheet is: Username : Kiran Password: kiran123 ''''Macro Sub User_Password() x = InputBox("Enter User Name") y = InputBox("Enter Password") If x =...
  13. K

    Allocate data from one sheet to the respective fields in another sheet

    Hi, Could you please elaborate it and it would be very useful if you upload a sample data sheet so that we can try to answer it easily. Regards, KK
  14. K

    Removing all hyperlinks

    Hi Folks, I appreciate you have a better answer only through excel and not through macros. I can select each cell and remove but that is very manual. Need to remove all the hyperlinks at once. Please note that the cells addresses keep changing for me. Regards, KK
  15. K

    Removing all hyperlinks

    hey! I got the answer. ha ha:-) Here it is!! Sub Hyperlink_remove() Sheets("Test1").Hyperlinks.Delete End Sub
  16. K

    Removing all hyperlinks

    Hi All, Is there any way I can remove all hyperlinks in my excel spreadsheet at once!? Regards, KK
  17. K

    I want to learn VBA...

    I suggest to join any online or live VBA training instead jst reading books. I have joined VBA in chandoo.org and it was quite useful for the beginners. Regards, KK
  18. K

    Automatic Emails

    Good ones!
  19. K

    Auto Save of a Form

    Hi there, Good Morning! I have an excel form where we usually fill the form and save as the file in our local share drive with a name as per B5 cell. Is there any way that once user enters a name on B5 cells the form should automatically save as onto the sharedrive with B5 cell data as the...
  20. K

    Sharepoint date(text) to date format

    Hi there, I know it is silly, but I actually stuck in getting the solution. I have a share point dowloaded data in A to H columns. My G and H columns shows me the dates like below: G Column: 08/21/2012 08:20:25 AM 08/20/2012 02:20:10 PM H Column 08/21/2012 08/20/2012 Now, I want G...
  21. K

    Locating Data ocurance in Mulltile Excel Files

    Hi Vijay, Happy to see you again! You can change the sheet names at any time, but ensure you do not have a sheet name with "Consolidated" & "OneTimeValue". As these two sheets will be used by the macros for you to get the output. If you wish, you can draft me a test mail to...
  22. K

    Concatenate data that is missing.

    Hi bobhc, Hope you have the first name in G column, middle name in H column and Last name in I Column and you do the concatenation in J column. With the help of 3 additional columns, I can get you the anwer. Suppose your data is like below: G1 = Test H1 = I1 = 2 J1 = Concatenate(G1...
  23. K

    Locating Data ocurance in Mulltile Excel Files

    Hi Vijay, Welcome to the forum. Here is the code to extract unique text from all the sheets ("A" Column) Change the column names as your requirement. You can do further followup for any queries. Am going for a movie now. Will come back and see the loop of queries and learn something...
  24. K

    VBA to copy a code and overwrite the existing code in multiple files

    Thanks Luke. Ya, I knw this is very tricky one. But, thought of asking if any solution will get from here. As usual, This forum rocks. Rgds, KK
  25. K

    VBA to copy a code and overwrite the existing code in multiple files

    Yep, am from AP. Pls reply if you have an answer to my query. Hope that will be helpful to everyone. Rgds, KK
Back
Top