Search results for query: *

I have a form with many multiselect listboxes on it. I want to loop through each list box and get the selected items to copy to excel. I am getting a casting error "must be less than infinity" For Each box As Object In Me.Controls '****INFINITY ERROR***** If TypeOf...

I'm having multiple problems with this. Everytime I think I'm making progress I take 7 steps back. I'm running in circles. ANY help is greatly appreciated. Here's the whole thing with comments on the problems. Imports Microsoft.Office.Interop Public Class ScopeSheetBuilder Dim excel As...

What am I doing wrong here? When I put in manual text after the line return it fill in but as is it doesn't pick up all the checkboxes under HEADINGS. It does create all the sheets under SHEETS. 'SHEETS For Each ctrl As Control In Me.Controls If (TypeOf ctrl Is CheckBox AndAlso...

I have a windows app with check boxes & a button. I want a copy of the existing sheet in the excel workbook to be made and named for every check box that is checked. I am getting an error that I need a new instance but i'm not sure where to put it. Please help Dim excel As...

I have a windows app with check boxes & a button. I want a copy of the existing sheet in the excel workbook to be made and named for every check box that is checked. I am getting an error that I need a new instance but i'm not sure where to put it. Please help Dim excel As...

I am trying to convert a perfectly good VBA code to Visual Basic using Visual Studio 2008 Express and I am getting an Invalid Cast Exception. Any help is extraordinarily appreciated. I'm about worn out with this project. Here's my code: excel = New...

I have created a user form with multiple arrays of check boxes and text boxes. I have a code that works great but I have to add a LOT more check boxes and text boxes, 2080 of each, and I am at the end of the apparent limit of height for the form and it is starting to crash excel. Should I not...