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

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi Sajan it took me some time, however, I just finished the steps that "to me" is interpolation. It was the basis of the macro that I wanted to make. I will be as basic as possible. Please bear with me. Step 1 Open up a new Microsoft Excel 2010 spreadsheet. Step 2 Click on cell "A1" and enter...
  2. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi Debraj, These links you provided gave me a better outlook and widened my horizon... Thanks for that. Sumit.
  3. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi SirJB7, This code is fantastic... It saved me from a lot of trouble. This base64 method is exactly what I was trying to achieve in the first place and I was totally ignorant of this. You enlightened me. Now, I don't have to go in the hassles of interpolation/extrapolation (which i still...
  4. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi SirJB7, I know inter/extra-polating non numeric values is something not present in Excel as we know. that is the main reason, I wanted to create a macro to do it, using some logic which i was not able to develop. However, the Base64 method you described seems interesting... will Google it and...
  5. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi Debraj, Thanks for the links... I never thought there would be links for this. Going through these now... will get back after going through them... Regards, Sumit.
  6. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi Sajan, I am trying to make a detailed step-by-step procedure. will be back with it soon. Thanks, Sumit.
  7. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi, The Starting Key and the Last Key would be something without logic like just a conglomerate of numbers (Eg. 3 and 15). Now, If I have to create 29 more keys using these two number then the interpolation variable would be 0.4. Now, if we use these 29+2 = 31 keys then these are interpolated...
  8. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    example may be something like this: First Key: J61GQ-S49SX-1CGUU-WCFZQ Last Key: AYQ7T-PF6T8-X4JY8-TNH1H Now, I want to create another 100 different keys using these two values (Interpolate). The concept of first and the last key is that I want to keep track of the licenses sold in a...
  9. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi NarayanK991, All I want is to be able to generate keys for my software using excel. The keys would be 20 characters in length and alpha-numeric with 4 sets of 5 characters (or simply 20 characters long). Now, I may pre-define the starting key and the ending key and interpolate the remaining...
  10. sumitbansal

    How to Interpolate and/or Extrapolate alpha-numeric values.

    Hi, Recently I finished one of my vb projects and wanted to sell it. For that I have to generate keys for activation. Interpolation and Extrapolation is a good method of generating version specific keys. uptill now, I was using only numeric keys. However, now i want to make them more robust by...
  11. sumitbansal

    How to get dynamic Unique Values in combobox while creating Estimate Sheet.

    Thanks for the reply... Yes, it is difficult to understand the requirement if the question is incomplete. I apologize for that. I will complete it now. Let's start from start... 1. When we open the file, it opens the splash screen where it asks the user to choose an option. We choose option...
  12. sumitbansal

    How to get dynamic Unique Values in combobox while creating Estimate Sheet.

    Its been a week and no one has replied... does this mean that what I am trying to achieve is un-achievable??
  13. sumitbansal

    How to get dynamic Unique Values in combobox while creating Estimate Sheet.

    Just found the way to upload files... Here is the link to the file. I hope it will provide better understanding... https://docs.google.com/file/d/0B_wsT6a6FzOnRVRjZWFnUll1UTQ/edit?usp=sharing
  14. sumitbansal

    How to get dynamic Unique Values in combobox while creating Estimate Sheet.

    Hi, I have a worksheet where user creates an estimate for the amount of building material required for construction purpose as per the customer requirements. For each estimate entry, has to get the quantity of material required, calculated as per dimensions of work and amount of work [which...
  15. sumitbansal

    MS Flex Grid in VBA Form Control Toolbox

    Hi, Will try this out and let you know the results. Thanks, Sumit.
  16. sumitbansal

    MS Flex Grid in VBA Form Control Toolbox

    Hi, After registering it successfully, when I tried to use it, it gave me an error message "the subject is not trusted for the specified action" and it would not add the grid in the form. Please help me with this. Thanks, Sumit.
  17. sumitbansal

    MS Flex Grid in VBA Form Control Toolbox

    Thanks for the post, it was really helpful... One question though, can we package this msflxgrid.ocx along with ms excel project so that whenever a new user opens the project file, this file gets automatically registered on his computer, iff it already is not present there?? Thanks, Sumit
  18. sumitbansal

    MS Flex Grid in VBA Form Control Toolbox

    Hi, Is there a way to get the famous MS Flex Grid in VBA Form as we do it in VB.Net? I was unable to find it in Add Control on the Control Toolbox. Thanks, Sumit.
  19. sumitbansal

    Using Same Subroutine for the numerous command buttons in a sheet

    Hui, Thank you very much... I was so engrossed in looking for/writing the code myself that I just forgot that microsoft has done it already as "before double click" even.... Thanks for reminding it to me again. The code I thus wrote as like this: Private Sub Worksheet_BeforeDoubleClick(ByVal...
  20. sumitbansal

    Using Same Subroutine for the numerous command buttons in a sheet

    I have a program of inventory management where the user has to calculate the quantities of the item as an option. The Default item is one ( if the quantity is known); however, if the quantity is unknown, then the subroutine kicks in. But for that to happen the user wants that either he is given...
  21. sumitbansal

    Automating MS Word via MS Excel.

    Hi Narayank991, Thanks for the reply, I will check the link and see if it helps. Sumit.
  22. sumitbansal

    Automating MS Word via MS Excel.

    Hi, I am here again with a new problem.. I don't know Word VBA and recently was asked to make a macro in word. To be more precise, there is a book typed in MS Word and the owner wants that he should be able to mark certain lines/paragraphs/pages with any given identifier throughout the book...
  23. sumitbansal

    Scrolling a validation list via mouse Scroll Button.

    Hi SirJB7, Now, this is something new to me. Thank for the worksheet. Now, the user does not even has to manually scroll the list. The user would be happy to see and use it. Let me try it on my project and lets see what the user has to say about it... Thanks, Sumit Bansal.
  24. sumitbansal

    Scrolling a validation list via mouse Scroll Button.

    Hi Narayan, Thanks for the insight, will try to work around for all the four points you suggested. However, just for the knowledge sake, can validation list be made to search the keywords just like in google crome where you just type few letters and the remaining word gets auto-complete? if...
Back
Top