VB Forum / General / January 2008

I have built a macro in VB for a particular spreadsheet, opening VB from
within Excel.
The macro is in the Forms folder and double clicking the button (that starts
the macro) on the form opens the code window.

Probably some component under Projects - Components?
But which?
[and how?]

i need help with a combo box and this same code works on my first tab with a
combo box. The error or problem i have is this code causes an index out of
range error when i run it on my second combo box:  
(errored code) Select Case ComboBox2.text

I understand that the following would be how you might start a loop
which is supposed to iterate on the current computer system through
each file located in the Selected Path of FolderBrowserDialog1:
For Each sFile As String In

I have a form designed like "input box". I am using a class method to
show that form.
I am using that class method in VBScript. How do i get the text
entered in the text box, to my vbscript variable, once the user hits

Karl,
I think you misunderstood me or I'm doing something wrong:
I do not only want to share modules between 2 projects, which is easy,
but usercontrols.

I have a .NET web Service which expose a web method say
GetConfigurationItem(). This web methord returns an object of custom
class. Here is the definition of class
class ConfigValue

Why a function couldn't return more than one value, eg something like this:
Public Function GetMinMax(MyArray() As Long) as Long, Long
   dim min as long, max as long
   'calc min/max

In some cases MousePointer doesn't change. For instance in this menu_click:
Private Sub mnuQuickBooks_Click()
   On Error GoTo ErrorHandler
   MousePointer = vbHourglass

MZ Tools 3.0 will no longer throw up a button on the menu bar for me,
although the tools *are* being loaded.  I thought I'd check here to see
if anyone has any suggestions:
Yesterday during my last session, when I fired up VB6 I got an error

Ok, I've been asked a question...
(VB6 apps only.)
How many applications fail to function correctly (that is it works on
some computers, but not all computers)? I'm thinking in percentages,

I have 12 command buttons evenly spread on the form.
Resizing the form causes proportionate change in buttons height and spacing.
That was easy part to do.
Now, user has the option to select caption's font and font size (it will be

         I am not sure what I am miising.
To demonstrate it I have just created a new project, just a single form with
a listview control having 3 columns.
There is not code at all except the code below:

I am building an Excel-based application that opens a Web Browser control in
a Userform and guides the user to create a data table in Tab-delimited text
format. The data table is opened within the browser window. From this point
on I would like Excel to automatically copy the ...

Any easy VB6 way to trap a Windows shutdown? I tried the unload
functions for the form, but they don't reflect (or my test didn't show
it) that it was a Windows shutdown and not an application derived
shutdown. (I got the same shutdown reason whether the application