• 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, 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...
  2. 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...
  3. 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.
  4. 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...
  5. 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...
  6. sumitbansal

    Scrolling a validation list via mouse Scroll Button.

    Hi, Is there a method or procedure through we can scroll a validation list via a mouse Scroll button. The scenario is as follows: "I am making a project for a store inventory in which there are about 4895 items. The user has to select one of the items from the list(at a time) and then as soon...
  7. sumitbansal

    how to run a subroutine automatically depending upon the value in a cell

    i am in a process of making a school project and i am stuck in a situation where I am suppose to run a subroutine depending upon the value in the cell of a spreadsheet. For more details... Say i have an empty cell then no subroutine should run if the cell has value say "teacher" then the...
Back
Top