Recent content by msl1

Hi, Currently I am having an issue with vb to vba conversion, since there are no itemdata properties or anything like that. I need to have underlying values for my combobox to insert into a database, but also be able to call application.calculatefull after the insertion for various UDFs on the...

I figured it out myself, all I needed to do was convert to vba and add in application.calculatefull. thanks tho.

how would application.volatile help? I will redo it in vba if that works. And I was thinking about using a second parameter, such as price action of the commodity, but I think that would call the formulas so often , it would bog it down beyond belief.

I am working on a project that involves an access DB, a DLL and Excel. The excel spreadsheet calls functions from the dll which queries the db, I could've just done it in vba, but I started the project in VB. It is an order book for a commodity trading firm, and they want to know positions by...

I am writing financial market software to look at spreads, and since the charting software vendor I am using does not support their DDE interface, I have to concatinate the formula into the spreadsheet and then take values from that. Application.wait just makes excel wait, and since i do not...