went further in the code and now im at the point where, I wanna be able to keep a summary of what I did like this
Building number unit number number area
1 101 bedroom
2 201 bathroom
10 308 living room
and so on then be able to transfer to excel, I guess have a button after I am...
excel 11.0 library ????? [RESOLVED]
when I reference this library and start my code as such:
dim eApp as Excel.application----its not reconizing excel in the interop libary why???
Already included them when it debugs and get to the
dim excelBook as excel.workbook = excelapp.workbooks.add---I think this is the problem
In the example you sent I backspace and I can reselect, but in my program it says gettype, but I have referenced the excel 11.0 and the VBIDE, office...
I want to take information from drop downs that I have selected
Example"
dropdownmenu1----building number----my selection-----1
dropdownmenu2-----unit number------my selection-------101
dropdownmenu3-----unit area-------my selection--------kitchen
I want to be able to take thses...
could I have a button labled done and when I click it the button it tranfers to a form, and when I am done lets say I need to go through the selection process 10 times to staore all the data in that done form, and then click transfer to excel button and have the information from the done form...
I am creating a program using a series of drop downs, I am looking to get the information after I have made all my selections, to transfer into excel for sorting and report printing. Any possible help and please I tried a few ways and no luck.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.