User Profile

Collapse

Profile Sidebar

Collapse
ellipsism
ellipsism
Last Activity: Apr 9 '10, 09:26 AM
Joined: Jan 24 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ellipsism
    started a topic Populating unique data from sheet to form
    in Visual Basic

    Populating unique data from sheet to form

    Hello, I'm wondering if there is an easy way of populating the unique records in an excel column to a listbox or combobox. I am thinking of doing something like
    Code:
        For r = 2 To 128
            With CB_List
                For n = 0 To .ListCount
                    If .List(n, 0) = Sheets("Testsheet").Cells(r, "U") Then
                        Exit For
                    End
    ...
    See more | Go to post
    • ellipsism
      replied to Cell selection box in Excel
      in Visual Basic
      Thanks alot. That is exactly what I wanted!

      best regards,
      Johan
      See more | Go to post

        Leave a comment:

      • ellipsism
        started a topic Cell selection box in Excel
        in Visual Basic

        Cell selection box in Excel

        I'm using an excel sheet to keep track of a number of variable links (a few thousand) in a very large compiled matlab model. I have a python method that checks a variable link to see if it actually exists in the model. I have also been able to loop through all variable links with VBA to verify their validity by calling the python script. However, this takes very long time.

        If I add a new variable link (a string in a cell), I want...
        See more | Go to post
        • ellipsism
          replied to WScript.Shell, with hidden window
          in Visual Basic
          Well, after poking around and trying different solutions, it seems that the way to go is to use objShell.Run, and use a temporary file for storing the output. I did find a good discussion at another forum here, with a useful function fShellRun, that does the trick. Credits to the original poster.
          See more | Go to post

            Leave a comment:

          • ellipsism
            started a topic WScript.Shell, with hidden window
            in Visual Basic

            WScript.Shell, with hidden window

            Hello,
            I'm using VBA from Excel to call a python script with some arguments. The python script returns only true or false, which is the information I want to take back into Excel.

            I'm wondering, is there a way to "hide" the command prompt which pops up in this case? The python script takes 0.5-1 second to execute, and I'm doing a lot of checks with this, meaning I get alot of windows open. Can I use the objShell.Run...
            See more | Go to post
            No activity results to display
            Show More
            Working...