Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

use validation. see help
"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

Could you explain just what you mean by "accepted/confirmed"?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit
basic but I cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered
into the active cell is accepted/confirmed and if not
accept/confirm it.

Cheers in advance.

Ollie

When you type data into a cell it is not fully accepted until you hit enter
select another cell or click the tick by the formular bar.

"Chip Pearson" wrote in message
...
Could you explain just what you mean by "accepted/confirmed"?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

Hi Oliver,

In VBA, there is no requirement for an equivalent to to use of the Enter key
in Excel to confirm an entry: a simple assignment suffices, e.g:

Range("A1").Value = 100

---
Regards,
Norman



"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

By doing that you are assuming you know what data the user has entered.

Until you hit enter or select another cell etc. The value property is empty.

"Norman Jones" wrote in message
...
Hi Oliver,

In VBA, there is no requirement for an equivalent to to use of the Enter
key in Excel to confirm an entry: a simple assignment suffices, e.g:

Range("A1").Value = 100

---
Regards,
Norman



"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

Hi Oliver,

I think that you will need to explain your requirements in more detail to
render them intelligible.

However a macro cannot run while Excel is in edit mode and Excel does not
leave edit mode until an entry has been confirmed or cancelled

---
Regards,
Norman



"Oliver Flint" wrote in message
...
By doing that you are assuming you know what data the user has entered.

Until you hit enter or select another cell etc. The value property is
empty.

"Norman Jones" wrote in message
...
Hi Oliver,

In VBA, there is no requirement for an equivalent to to use of the Enter
key in Excel to confirm an entry: a simple assignment suffices, e.g:

Range("A1").Value = 100

---
Regards,
Norman



"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie

Ah, So you can't run macros while excel is in edit mode. Is there any way to
detect if excel is in edit mode?

More detail...
My excel addin creates a toolbar button that when pressed saves a copy of
the file and imports it into our document mangement system.
The problem I have is a get a run time error if excel is in edit mode (this
has now been cleared up). So, I now need to detect when excel goes into edit
mode a disable the button.

Cheers for all you help

Ollie

"Norman Jones" wrote in message
...
Hi Oliver,

I think that you will need to explain your requirements in more detail to
render them intelligible.

However a macro cannot run while Excel is in edit mode and Excel does not
leave edit mode until an entry has been confirmed or cancelled

---
Regards,
Norman



"Oliver Flint" wrote in message
...
By doing that you are assuming you know what data the user has entered.

Until you hit enter or select another cell etc. The value property is
empty.

"Norman Jones" wrote in message
...
Hi Oliver,

In VBA, there is no requirement for an equivalent to to use of the Enter
key in Excel to confirm an entry: a simple assignment suffices, e.g:

Range("A1").Value = 100

---
Regards,
Norman



"Oliver Flint" wrote in message
...
Hi,

I not too farmilar with Excel VBA so sorry if this is a bit basic but I
cannot find a resolution anywhere on the net.

Basically, All I want to do is make sure that any data entered into the
active cell is accepted/confirmed and if not accept/confirm it.

Cheers in advance.

Ollie