+ Reply to Thread
Results 1 to 6 of 6

Instant results

  1. #1
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189

    Instant results

    Hi, i'm trying to make (in my own vba code) something like this, that i attached.
    I want to make a grid like that, so that any value that i modify in the textboxes, the program instantly changes the result values. This function that i pretend is similar to excel mode: at any change in a cell, the final result instantly changes.
    Other thing that i'm searching is a Control do add to my VBA toolbox to make this kind of grid. I found VSflexgrid, but i don't know the code to make it function the way i want: giving instant results.

    So, can anyone help me on this, please?
    Attached Images Attached Images

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    There is a Spreadsheet Control available from VBA ToolsBox if you right click & select Additional Controls & scroll down. It's not easy to use!

    The image looks like it is made up of Cmmandbuttons & TextBoxes.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-08-2007
    Posts
    1

    How to use if condition please help

    Hi Iam a new member of this group i need ur help ya

    i want to know how to use if conditions please send me details

  4. #4
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189
    Thank you for your attention.

    I've found that kind of grid that you mentioned, but i don't know how to put it funtioning that way: giving instant results as i change values.

    Can you help me more in this?

  5. #5
    Forum Contributor
    Join Date
    12-26-2006
    Posts
    189
    Sandigital, i think you're in the wrong post. I think you have to create a new topic regarding your question.

    But before i advise you to make a search int this forum about that question. You may find many information about that.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Quote Originally Posted by mqdias
    Thank you for your attention.

    I've found that kind of grid that you mentioned, but i don't know how to put it funtioning that way: giving instant results as i change values.

    Can you help me more in this?
    It works like a mini spreadsheet.

    Read this

    http://www.excelkb.com/article.aspx?...6&cNode=1U5J4S

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1