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...
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
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.