brax | Massively parallel rigidbody physics simulation

I am trying to move a picture and then make the code sleep for a while. The problem is, the position of the picture does not update before "sleeping". Here is the code:

I want to query a Database from Excel Vba (using ADODB) and fill a Combobox with the retrieved List of Values. Unfortunately only the last value of the returned List is displayed in the Dropdown field. I assume that the recordset is a complete String of all returned rows, and so only the last one is visible.

I searched about the topic but only can find info regarding Access, which doesn't seems to help.

This should be the important part of the code, I can provide more if needed:

Okay, I know that this is a super weird question and there probably is not an answer other than simply rewriting the entire application. However, I recently took on a project for a client that has a MASSIVE project written inside of Access 2007 with Visual Basic for Applications and some VB6. In order to help them my first plan was to just modernize everything they have. The application runs on XP and I was hoping that I could at least move the project files and forms (automatically) to any type of .net project inside of Visual Studio. I've never used any of the Microsoft developer tools and after a couple days of digging around on the internet, most converters don't actually seem to work. There doesn't seem to be any sort of "best practice" way to bring an old VB project to a more modern developer environment. If rewriting everything is really the only option that's fine I was just hoping that one of you very smart people knew of a way that I could at least get most of the code/forms into a newer environment. If I can just open the project in an older version of Visual Basic that works too (their system has access to every major version since 2008) Thanks in advance!

I am also totally open to porting the project into any other language if there is a better tool that works for say Python, Java, C (any iteration of C), etc.

EDIT: "Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – Scott Craner, Steve, Erik von Asmuth, Kostas K., braX

So in response to this, I have attempted to rebuild the project inside of visual studio 2008 and then using the built-in converter bring the code from VBA to VB6 which (for the most part) worked. From there I could save the project and open it in visual studio 2010 once again using the built-in converter to take the code from VB6 to VB.Net. However, this is where the "success" stops. Essentially the project cannot be opened in any newer version of visual studio (attempted with 2012, 2015, and 2017) I was simply hoping that ANYONE would have any ideas on how else I could go about moving this project into Visual Studio or rebuilding it in another language. I understand that the question is not super relevant considering the software I am talking about updating is over 10 years old and some of it even older. Thanks for your responses as I think that it is probably time to evaluate the cost/time involved in a complete rewrite.

I have scripted out a module that reads data I paste in from a SQL dump, and converts it into a data insert script to SQL. It is working great, only problem is for cells that contain items like:

11-20

instead of filling my value as '11-20', it is converting it to '20-Nov'.

I have adjusted how i read the cell from text to value to value2, Text comes the closest to right (rest do a math calc that tosses my overall sheet off even worse, namely dates). I have also tried such things as a Range("X:X").clear and clearformat as well. This also does not do the trick.

How do I force my string read of this cell to be the literal CSV content, and ignore the formula/calculations that excel is tossing at me?

EDIT: Thanks to BraX for the solution!

I was unable to accomplish this by copying from one tab to the next within Excel, but i did get it to work by pausing my operation with a message box prompting the user to simply navigate to SQL and put the contents of the data in to the clip board. This works perfectly now!

I've seen similar cases before of this on this forum, but I've not seen an appropriate solution to my exact problem so here it goes...

Basically I have a userform with a listbox that manages data from a data table. There are multiple entires which are tied to each "entry ID" (in column A). When I search up the "entry ID" in searchbox I would like to see all the associated entries, with columns A to J for each entry, in a listbox (thus the code needs to loop through and find multiple rows, and "copy" multiple columns for each row into the listbox, which I think is where I'm struggling).

I have adopted a piece of code I've found for a similar case here on the forum, but can't seem to copy multiple columns: