vbyesno msgbox
Thu, 28 Aug 2008 08:19:00 -0700
Dear Forum members,
When opening a workbook I would like to use a vbYesNo MsgBox to prompt the
user to answer yes or no to a given question. Depending on whether they
answer yes/no I want another MsgBox to confirm their input. I have tried
using the following but to no avail, can anyone please help? Thanks ...
|
Re: Comparing Object References
Thu, 28 Aug 2008 08:17:00 -0700
Thank you very much, Jim! This is also exactly what I was looking for. I
hope it works with other objects as well. I shall do more testing...
Thanks,
Matthew Pfluger
"Jim Cone" wrote:
> Bob,
>
> Change...
> If WBArray(1) = ActiveWorkbook Then
> To...
> If WBArray(1) is ActiveWorkbook Th ...
|
Sub parameter passing
Thu, 28 Aug 2008 08:02:00 -0700
Is this the proper way to pass a varible parameter to and back from
subroutines?
My code seems a little sloppy, I would think that I'm missing some
delclaration
The subroutine "Orig_WS_name" is call with the following statement:
Call Sub Orig_WS_name("orig_name")
Private Sub Orig_WS_name(WSIn As String ...
|
vlookup multiple docs & add results together
Thu, 28 Aug 2008 07:59:01 -0700
Is it possible to do a Vlookup on all excel docs in a folder, checking the
same sheetname and column for a value and add all the returned figures
together?
I'm trying to calculate a cumulative total from monthly payment applications
on a summary workbook.
I want create a look up on the project number on ...
|
VBA code optimization - why using long instead of integer?
Thu, 28 Aug 2008 07:35:02 -0700
Can anyone explain to me that why VBA converts all integer values to long to
make the program run faster? Mean that Integer is meaningless?
"VBA converts all integer values to type Long, even if they are declared as
type Integer. In fact, Long variables might be slightly faster because VBA
does not have to ...
|
Addin to open and hide a workbook
Thu, 28 Aug 2008 06:38:00 -0700
Hello all
I am trying to make an Addin to be distributed between several users. The
Addin will open and hide a workbook with macros. in the same way as Personal
Macro Workbook. My problem is that althought the addin works, the code I
wrote hides all of the windows, not just the workbook I want to hide, a ...
|
Macro for Comment box
Thu, 28 Aug 2008 05:26:55 -0700 (PDT)
I am encoding 10 digit code on a comment box for most of my
worksheets. Question: how can I create a macro or any formula that
will identify comment boxes which has less than or more that 10 digit
codes? Hope you can help me. I badly need it to achieve accuracy of my
worsheet.
I can also be reached at YM, eyed_ ...
|
|
|
Export contents of Immediate Window?
Thu, 28 Aug 2008 14:21:10 +0200
It is possible to export the contents of the Immediate window to a .TXT-file
by some VBA-code?
Can anyone help me with such a code?
TIA,
...
|
GetValue() Does Not Work
Thu, 28 Aug 2008 05:16:01 -0700
I use Visual C++ MFC 4.2.
I need to get the value of some cells like in my code below:
LPDISPATCH lpDisp = sheet.GetRange( COleVariant( "A8" ), COleVariant(
"A10" ) );
VARIANT varRet = range.GetValue();
CString sVar( varRet.bstrVal );
if( sVar.IsEmpty() ){
}
The bug is: eve ...
|
Test for >1 occurances meet same criteria. Display address in MsgB
Thu, 28 Aug 2008 05:07:00 -0700
In Sheet1 I want to test col. W for more than one occurances of the same text
value and at the same time both/all matches a constant text value in col. P
on the same row. The criteria/text in col P is: "Started". The values in col.
W are picked through validation from a named range called "Cell_No-Prod". The
...
|
