Remember it should be a singleton, this shouln't appear" If iSingleton > 1 Then Err.Raise 1000, mainForm, "This userform is a singleton!"ĭebug.Print "Termination of the userForm. Keep in mind that VBA spells a colour as BGR (inverse order).")Įnd the form listing values for month and year, and marking the boxes as unempty") In this case, like this (variable names have been deliberately changed to hide the privacy of the actual report I'm making here): Public Type FourTrackersĪ userform with fields will collect strings with the fullpath to the workbooks, and perhaps some dropdown lists with possible months and years for Option Explicit So I often declare a Type whose elements are all the workbooks I'm going to need, which will be the parameter I'll be passing around the processes. Most often for example, I need him to give me some workbooks and maybe a date. I have this very recurrent pattern at my VBA macros, where I have to ask the user to give me certain information that will be necessary for the processes to come.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |