Code:
--------------------
 Option Explicit
 Private Sub Worksheet_Change(ByVal Target As Range)

In the "Save as" box, the name of a workbook is pre-highlighted for you to
change it.  How do I do the same in a user form ?
I have a form with a text box... say txtbox1, I also have set a default
value of "0" in the txtbox1.

How do you set the current worksheet as the activesheet so that when a
routine ends you are back to the worksheet you started in.

Line 1: Cells(1,1)=ticker  
enters the value of ticker in cell A1.
If ticker = "1" AND format of A1 is General
line 1 results in A1=1 as a number NOT as text, even though ticker is a string

I have defined various name ranges and I use them in a  macro to create
a chart it works fine for sheet 1. But i want to use the same dynamic
range for all sheets in the workbook.
So basically what i want is a macro to run through my workbook and

I have a worksheet with 5 scrollbars on it.  The following code doesn't
work.  It gives me:
runtime error 424: Object required  (When trying to reset the value of
scrollbar 1).

I have a column of numbers, the first being a date and the second a value,
etc..
I want to take every other value (the even numbered rows) and move them to a
second column next to the date. Of course I'll end up with a blank every

This is not an Excel VBA question. Because I have learned a lot from
you guys, I want to get some ideas from you (simply yes or no answer is
good enough)
Is it possible that whenever I logout, my compute automatically clean

I have written the macro as below
Function FindOldNominal(NomCode, Range)
FindOldNominal = WorksheetFunction.VLookup(NomCode, Range,5,false)
End Function

I have a "Visual_Protect_Indicator" add-in which I think is greatly slowing
down the code I am currently working on. This add-in works on the Protection
Menu Bar - It gives me a visual indication when my sheets and/or workbook is
in Protection Mode.

Hi All,
I would like to set up a piece of VBA code so that when a user adds an
entry in a cell in the speadsheet, a function is automatically run that
adds a new value to the adjacent cell. I guess the code would follow the

The code below calls a userform any time a cell is selected within that
range and it works fine, but, the routine which is triggered by a button on
the userform also selects a cell within that range causing the userform to
reappear. Is there any way to suspend that code while the ...

In the following function below I am trying to modify Ron de Bruin
function for merge cells from all or some worksheets and am running
into problems with the entry: For Each sh In Sheets(Array("Sheet1",
Sheet2" etc.).  I have 24 tabs that can be used for data entry and 2

I guess I don't know if this is a problem or not, but while I was working in
the VBE I noticed that each time I closed and re-opened my workbook, the
VBAProject did not close.  If I create a new shet and close it, the
VBAProject goes away.  Is this normal behavior?  Will this ...

I need help in excel to find a way to look up values in a Microsoft Excel
Spreadsheet based on a
chosen product code in another sheet in the same excel-file (to be used in
calculating price for different product qualities).