Why am I getting an answer of 1 everytime?  The function seems to be skipping
the Case programming.  What do I need to do to fix this?
Function TabeGECol(Level, Form) As Integer
 Dim ColNum As Integer

I've never seen this so don't know if it's even possible -- can one do
something in Excel that approaches a database form?
In other words, can .an ordinary spreadsheet be enhanced with a user
input box that pops up with places where user types in pertinent data.

Can i sell my vb program that was created by me but with help from other
users as well?? If not can i use my program in a company with out selling it?

On Sheet1 I have 5 cols A to E. At any stage when I activate a cell (any row)
in Col A, by pressing a macro key or other button, I would like the program
to switch to Sheet2 to give me an option the select say, the name in Col A
and the age in Col E. I would like to obtain this ...

How would I go about saving a file as the concatenation of B1,C1, and E1 in a
macro

Hi fellows
I got a Userform with 6 Checkbox'es
and 1 Commandbutton
What i wont is check out som of the 6's checboxes

My Macro does not DELETE the ROWS from the specified Worksheet whene SAVESTR
is NOT Found.
If SAVESTR is found it deletes the other ROWS.  However I need to be left
with a blank sheet if SAVESTR is not found in the specifed column.

In order to keep an object in memory with a know reference point, I
typically store it in an element of a public array.  Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through

How does on go about changing the image for items added to various ribbons
in 2007

I have a spreadsheet that has multiple rows (>10000) with several
compound If statements throughout one sheet of my workbook. An example
of such a statement is:
IF(C2<>"",IF(C2<=$M$14,0,IF(C2>=$M$15,$M$17,C2-$M$14)),"")

I'm looking for a mean to add a watermark text to a picture(bmp) in
VBA/VB6 (not to a sheet).
I've found some ActiveX, but do not succeed to use them
Do you know of some procedure/ActiveX that could do the job. I need

Currently, I have a userform with two input fields.  I am unable to advance
from the frist field to the second field via pressing the ENTER button.  I
have to use the TAB key.  How can I change this?
Thanks,

I have a subroutine that creates a Pivot Table which has 10 row fields.
It then goes through and turns off all of the subtotaling for the 10 row
fields.
Each time a row field's subtotal is turned off, it recalcs the Pivot Table

Is there a result code for the SaveAs method that I could use to
conditionally direct the execution of this code around the block of code that
starts "If Err.Number..." if the user elects not to save the file?
Here is the code:

Hello !!
I'm doing a lot of presentations using my Excel workbook as base.
So, I've written a code to copy each of my sheets, convert them in pictures
and paste in Powerpoint.