I fixed the problem. Not sure how or why it worked.
All I did was delete the exixting frame from my userform. I then saved, reopened the project and put a new frame with all of the same properties onto the userform and the code started working.
I have attached a sample that shows a small sample of a VBA control array. Copy the code into the locations noted.
A userform named UserForm1:
Private colCalendar_Show As New Collection
Private ctlCalendar As Calendar_Classmodule
Public iButton
Private Sub UserForm_Initialize()
Dim iTop...
Hello,
My question is, has anyone found or compiled a list of controls for vba that support arrays with events?
Im having trouble generating a control array for Text box's and combo box's added at run time. Ive created arrays for command, toggle and spin buttons that support all events...
Application: Excel
Im having trouble placing a frame control within an existing frame at run time. If I modify the code to add the frame to the userform the code runs fine. If I run the same code but try to place the frame on an existing frame, excell simply crashes.
Any thoughts would be...
The new document is being built from input from a user. there are several sections and the length if each can very greatly. More over. If a portion of the section starts on one page and rolls into another the prtion on the preceding page needs to be move so that it all stays together.
The text...
I have tried several iterations of the suggested code and get "method or data member not found" on the ".Pages" .
Does this code execute for you?
I'm using word2000 and MVB 6.3. Are you using the same versions?
Thanks for the replies. Unfortunatly "Pages" does not seem to be a valid method in this case. I have searched quite a bit for a reference to "Page" and only seem to find it in th two rroutines I've already tried.
Both wdDialogFileSummaryInfo.Pages and wdDialogDocumentStatistics.pages fail to update as the document is being updated with new pages. If I run in debug mode and apply a break after each line is added they update ok and reflect the number of pages. This would be great if it only upated fast...
Im looking for a way to tell if a page has been added to a document being created by a macro, based on input from a user. I have tried the wbstatus.pages call but it stalls during macro execution and only updates randomly.
I need this functionality to add specific text to the top of the new...
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.