Updating active cells in vba

09-Jul-2016 15:33

After running a search, a recorded macro copies, pastes and formats a set of Index Match formulas from another sheet to present the results.

In this case, a list of employee's where training complete is 'No'. The sendkey on it's own succeeds in moving to the source cell and selecting it.

Enable Events = False 'Turn off events to prevent endless loop! Intersect(Range("My Entries"), Target) If isect Is Nothing Then ' Msg Box "Ranges do not intersect" Else ' Msg Box "Changed", vb OKOnly vb Information, "Cell Changed" If Target. These would probably be better off on another sheet out of the way!

Hi RG That is a nice formula for effectively 'sub-counting' visible cells!

It seems to me that perhaps the best way would be to use a combination of data validation and conditional formatting to achieve a reasonable compromise. With apologies to Tennyson: "Mine is not to reason why merely to code and recode ...! Not to nit pick, Ok so I'm nit picking, it doesn't blank the cell like the OP asked.

Actually, that's one of the problems I've always had with DV it can get "USERS" locked in a loop and they can't figure how to get out.

It seems that using sendkeys would not be a good solution (it usually isn't) so if we know your entire problem, we may be able to help provide you with a better overall solution.

You will need a macro to change a cell without a formula, but you need to provide more explicit requirements for someone to create that code.

However, as detailed in my now edited question, I cannot reference a specific cell as it is reliant on what the source cell is of the cell the user has selected.

I have an excel work sheet where certain condition is tested when an input is performed on an active cell. Then have formulas refer to this formula instead of the cell directly entered. Here is the real scenario: There is a column range on my spreadsheet, say C2: C15.

The reason I feel this is relevant to mention is because the most obvious solution to my current problem is 'just use Access' which I may end up having to do if it turns out I am out of my depth here.

One of the tools I am working on at the moment is a skills matrix/succession plan.

You will need a macro to change a cell without a formula, but you need to provide more explicit requirements for someone to create that code.

However, as detailed in my now edited question, I cannot reference a specific cell as it is reliant on what the source cell is of the cell the user has selected.

I have an excel work sheet where certain condition is tested when an input is performed on an active cell. Then have formulas refer to this formula instead of the cell directly entered. Here is the real scenario: There is a column range on my spreadsheet, say C2: C15.

The reason I feel this is relevant to mention is because the most obvious solution to my current problem is 'just use Access' which I may end up having to do if it turns out I am out of my depth here.

One of the tools I am working on at the moment is a skills matrix/succession plan.

$Benchmark$ A - 2 B - 3 C - 5 D - 3 E - 1 When a letter, say 'C', is typed severally, on each occasion 'D3' shows the number of times the letter 'C' appears within the C2: C15 range.