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

    data validation

    Hi, A pleasant day! I need anyone's expertise. I'm using data validation to prevent duplicate entries. I'm using the below codes. I have a form where i input the data to a cell once i click save the below function will be called. I have multiple criteria range that needs to be satisfy...
  2. N

    excel macro worksheet to exe

    Hi, Can i convert excel macro worksheet to exe? Thanks and advance Nano
  3. N

    merge data from input box and selected cell

    Hi, I have a given data see below: Time 02:00:00 03:00:00 04:00:00 05:00:00 06:00:00 07:00:00 Is there any fastest way to input a date before each time? Thanks, nano
  4. N

    Cannot save excel file

    Hi, I need help i cannot save my xlms file everytime i try saving it, it keep on hanging and sending error report. What should i do? :(( Thanks in advance,
  5. N

    Generating serial number on a textbox in a userform [SOLVED]

    Hi, I am encountering a problem in generating a serial number. Everytime i open the form the serial number always starts with "1" and on the second time i open the same form the serial number is generating correctly. I couldnt figure out what was wrong :( I have this code on...
  6. N

    VBA project

    Hi i need help with my project. I am using excel vba(userform), I want to search data from an excel sheet. Example. I will type a serial number on a textbox and if matches data from the excelsheet it will display all the information on a specific text box. is there anyway to do that...
  7. N

    How to save data from a textbox to specific excel sheet

    Hi, A pleasant day, I need your help, i want to save the data from a textbox using macro. Please see below link of my excel sheet screenshot. https://rapidshare.com/files/1556720348/test.JPG Thanks in advance, ^_^
  8. N

    How to populate combobox in excel / vba [SOLVED]

    Hi, I'm using this code( see below) in populating combobox, is there any way where I can populate the combobox from a sheet and when I will add entry from the sheet it will automatically add to the combox box? Private Sub UserForm_Initialize() With Me.comshift .AddItem "Early"...
  9. N

    Calculating working hours [SOLVED]

    Hi, I have this data(see below details) how am i going to compute the total working hours. I used the formula =Columnb-ColumnA but the working hours doesnt show instead it only appear a long ####. I'm using the same formula with other time it works perfectly fine. Column A Column B Time...
Back
Top