Search:

If I understand you correctly. The object was defined within a form and a class module needs to reference some property within the object.
If that is correct regardless if you are in Office VBA or...

Comments are stored in the worksheets(x).Comments collection. This collection has a Parent property which has a ROW and COLUMN property. You would have to use this to determine if the cell you are...

Write a VBA macro that will open the .DAT file as a file and read through it.
You can use a do ... until EOF(?) where ? is the file number when you open the file.
There are abundant examples on...

There are several good books available that teach Excel in a hands-on approach with practice sessions accompanying each section. If your friend is good at learning this way then that is perhaps the...

1. You are correct. The formula bar will show the formula while the cell will show the result of the calculation of that formula.


But then my question remains. Why has the formula changed in a...

A cell can hold a formula or a value but not both. If you copy a cell containing a formula and paste it in another cell you will get a formula in the new cell. If you copy a cell containing a...

If the macro is ran only once you are correct. But a couple of points here and I'm out.
Does the value of width, length, height ever change in workbook2? If it does then wouldn't you
want to have...

westconn1 is correct except that instead of the beforesave or aftersave event I would use the beforeclose event. That way your macro can save the workbook as an XLS workbook, then close excel. One...

A macro is not needed. What you do is sort workbook2/worksheet2 in ascending order on PROTOCOL then save it.
In workbook1/worksheet1 put a formula in the cells you want in worksheet1.
The formula...

You probably don't need a macro. Just put formulas in WB3 that reference WB1. Everytime you open WB3 it will ask you if you want to update the links. If you say no, the values in WB3 remain the...

Can you post a copy of a few rows of Workbook "B"?

Thanks guys. Someone from another team was able to help.

SQL Server 2008 R2

You could add a new case statement to your first case statement in the worksheet change event.
[HIGHLIGHT=vb]......
Case 2 'B
If isdate(range(target).value) then
...

Or try this so you don't waste time switching sheets.

Range(myrange).Copy Sheets("Sheet2").Range(myrange).offset(rowOffset, colOffset)

Well those are good and will certainly work but this might be a quicker way.

1. Select the cells that you want to potentially replace data in. Or the entire column for that matter.
2. Then...

I have a SQL select statement that calculates the value of one of the elements being returned by the select. Following is that SQL.
, AVGManual =
(select count(*)
from...

I assume that since you are looking a subsets of an array the you determine the first and probably last values that you want in a range in the array.
Would it not be faster and more flexible to...

fit your code at the top of the first set of code.
You should embed that code in a select statement to make sure the column is the right one and the row is correct.

Select Case Target.Column...

Nope, when you set oXLSheet to another worksheet you have effectively released the sheet
that it referenced before.

You can use conditional formatting on the cells you need to affect.

I think what you want for those colors is to use conditional formatting on the cells.

When you do this:
Set oXLSheet = oXLBook.Worksheets(ws_cnt)

Then any references to oXLSheet will suffice.
As in this:
oXLSheet.Cells(27 + f, 1) = filename
oXLSheet.Cells(27 +...

You may be making this harder than is necessary. First use the TAG property to identify all of the
command buttons to be updated. Maybe put "what ever" as it's value.

dim vbcontrol as object...

From the code snippet it is not clear what the value of ws-cnt is. This could cause a problem.
Also, where you oXLSheet(ws_cnt).activate this is not necessary because oXLSheet is a
worksheet...

I don't think it is possible using a formula but I have created a macro that will do everything you've
indicated you want. I've not fully tested it so do your due dilligence and test it.
This...

Which version of Excel are you using?

Yes, but users being what they are will "play" with the contents or change their minds and flip-flop back and forth. 35 years experience speaks.
So do you need to prevent that from happening?

A couple of questions here:
Can any other values be entered in column K?
If "XYZ" is entered in Column K and then "With Engineer for review" a second time should column P be changed to the new date?

Is your PC connected to a network?
We have the same problem with our PCs while using any application. It appears that some network action is causing our PCs to lock for a second or two on up to 2 -...

It sounds like you want to copy the whole sheet so why not do just that. You can create a test workbook and in the developer ribbon click on record macro then right click on the sheet name and...

This code snippet should resolve your problem.

For intFno = 1 To UBound(fList)
On Error GoTo Skip
Set wbOpened = Workbooks.Open(fPath & fList(intFno))
...

If you select the variable name where it is declared then do a find. If the variable is used then the place it is used will be shown. Otherwise the variable will be highlighted.

Use Target.cells.countlarge which I believe is new to Excel 2010. The Target.Cells.Count is a long value so when you select the entire worksheet the .Count is too small to hold the result.