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

  1. N

    data validation

    Hi Narayan, I can't upload the file its too big. Anyhow for inputting a data im using a userform. Thanks, Nano
  2. N

    data validation

    Hi, I attached a snapshot of one of my sheet. What i want is to restrict user from inputting same dates the same SAPID. Hope anyone can help me. Thanks, nano
  3. N

    data validation

    Hi Hui, But if i'll do that once the first column has been satisfied it will stop from executing the next condition. Nano
  4. N

    data validation

    Hi Narayank, it will call the dup function before saving to the worksheet. nano
  5. N

    data validation

    Hi Hui, I did put it before but the problem is it won't let me input anything even its not duplicate. Thanks, Nano
  6. 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...
  7. N

    excel macro worksheet to exe

    Hi Narayan, So sorry yes its workbook my bad. Nano
  8. N

    excel macro worksheet to exe

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

    merge data from input box and selected cell

    Hi Narayank991, You're a genius thanks a lot. Cheers!!!! nano
  10. N

    merge data from input box and selected cell

    Hi Debraj, Thanks for the reply. Anyways. I was able to append the date with the time using the below code. But in order for me to have the same output i have to format the cell to text, the thing is after doing that i cannot compute the difference of the time since its in text format. If i...
  11. 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
  12. 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,
  13. N

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

    Hi SirJB7, Now i know what was wrong i made the worksheet "changecontrolregister" hidden upon opening the workbook. Its working now, thank you so much for your time :) have a great day,
  14. N

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

    Hi SirJB7 and smallman, After logging in the worksheet "changecontrolregister" will appear then i have to click the add new button to load the userform. It works for me but the thing is, when i click the add new button from the worksheet the number that generates from the change.no textbox is...
  15. N

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

    Hi SirJB7, Sorry, password is crpt123 for both. Thanks,
See more
Back
Top