toby1keobe
Mar 27th, 2006, 03:27 PM
Hi, First time here and a newbie to Excel VBA and VB6 so please forgive my basic understanding. (Apologies if this is not in the right forum?)
I have created an app through VBA in excel which does everything I want it to do, however I now need to create it as an exe.
I have managed to go through and export the Userforms from Excel and import them in to my VB6 project. I have added all references and relevant modules etc. I run the code and all seems ok however............
When the Userforms load in the VB6 project the controls on the userforms are not binding to the spreadsheet that I have created by code in VB6, they are all empty? Basically the userform appears but none of the list boxes comboboxes etc contain the data available in the spreadsheet that I have created via code in the background.
How do I bind the Controls in the userform to the underlying spreadsheet that has been created, for example Spreadsheet1 has Yes in Range("A1") and No in Range("A2"), when this is run in the project combobox1 for example (even with correct location set in Rowsource) does not show this information?
Too many late nights....... :cry:
I have created an app through VBA in excel which does everything I want it to do, however I now need to create it as an exe.
I have managed to go through and export the Userforms from Excel and import them in to my VB6 project. I have added all references and relevant modules etc. I run the code and all seems ok however............
When the Userforms load in the VB6 project the controls on the userforms are not binding to the spreadsheet that I have created by code in VB6, they are all empty? Basically the userform appears but none of the list boxes comboboxes etc contain the data available in the spreadsheet that I have created via code in the background.
How do I bind the Controls in the userform to the underlying spreadsheet that has been created, for example Spreadsheet1 has Yes in Range("A1") and No in Range("A2"), when this is run in the project combobox1 for example (even with correct location set in Rowsource) does not show this information?
Too many late nights....... :cry: