Cell changing to ##### after enter?

[SVTF]

Hello there,

I have a worksheet that has the following code:

Please Login or Register  to view this content.

So here is what is happening on the work sheet.

In A3 etc. a number is entered.
It will then populate the current date in C3
A date is then manually entered in B3 etc.

This only works for row 3 & 4

Once we get to row 5 own ward

In A5 a number is entered
The current date populates in C5
But once you enter in the manual date on C2

A5 changes to ####### - and when you expand the cell it is time stamping cell for current date and time?

Any suggestions on how to fix?

Need more info? Is it something to do with the code above?

[blane245]

Have you declared ColumnAChanging as a global variable? If not, then the statement

Please Login or Register  to view this content.

may not be doing what you think it is.

[SVTF]

^^ I went back and looked ... You actual helped with the intial code here:

http://www.excelforum.com/excel-prog...fill-date.html

Can you let me know what I need to do to fix the error?

[SVTF]

Have you declared ColumnAChanging as a global variable? If not, then the statement

Please Login or Register  to view this content.

may not be doing what you think it is.

How do I declare this? So that it does not happen?

[blane245]

Can you attach the workbook as it now stands. I don't have enough information to work with.

[blane245]

It should be declared in front of Worksheet_Change.

[SVTF]

Can you attach the workbook as it now stands. I don't have enough information to work with.

Here is an test one

[blane245]

I can't seem to get this to fail in the way that you describe. Please describe the failure again. I see that you have a reference to cell C2 when you probably meant C5.

[SVTF]

Row 3 and 4 work fine - every other row does as per the example above.


Enter a number in A4 the date will prefille in C4

Now manually enter a date in B4

This will work fine.

Do the same starting at

A5 enter a number the date will prefill C5

Now enter a manual date in B5 and A5 will then change to all numbers signs and when expand it timestamps that cell for todays date and time?

[blane245]

OK, got it now. Seems like that is what you wanted the original problem to do. What do you want to do when something changes in column B. Right now it is writing the current date in column A if it is nonempty.

[SVTF]

OK, got it now. Seems like that is what you wanted the original problem to do. What do you want to do when something changes in column B. Right now it is writing the current date in column A if it is nonempty.

I basically want it to work exactly like row 3 & 4

The date should only prefill in column C based on an entry in column A

Any data entered in column B should change nothing on the sheet.

[blane245]

That simplifies things a bit. Try this:

Please Login or Register  to view this content.

[SVTF]

Seems to have worked - Thanks for cleaning it up ... Very much appreciated.