Default cell in cell after re-written and deleting

[thedude1222]

So basically here is what i want to do in my simplistic language

If cell A9 is blank then add text 'Enter'.
- so i want ppl to see the word 'Enter' they enter their text. When they delete the text 'Enter' reappears.

However if they save the file with their other data - when opening up the file i want something like
If cell A9 does not = 'Enter' then add text 'Enter'

Please help me!
and i do not know VBA so please explain to me like i am a child.

[jaslake]

Hi thedude1222

You can use a Workbook Open Event to populate Cell A9 with the word "Enter".

Please Login or Register  to view this content.

You can use a Worksheet Change Event for this

If cell A9 is blank then add text 'Enter'.
- so i want ppl to see the word 'Enter' they enter their text. When they delete the text 'Enter' reappears.

Please Login or Register  to view this content.

To insert the Code:
Go to VBA ===> Alt + F11
In the Left Panel double click on Workbook
Copy/Paste the Workbook Open Event Code into the Right Panel
Now, Double Click on the appropriate Worksheet that you've defined in the Workbook Open Code
Copy/Paste the Worksheet Change Event Code into the Right Panel
Go back to Excel ===> Alt + F11
Save the Workbook as a Macro Enabled Workbook.

[thedude1222]

it's not working.. how can i attach the file for you to review...

[thedude1222]

each time i open the file it lists (General) instead of workbook and (Declarations) instead of change.
also when i try and run macro it doesnt even show it existing.

[Fotis1991]

To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[thedude1222]

Project aaa.xlsm

Thanks for your help,

Id also like to have a time stamp for anytime a new Contract # (A21) is added to show up in L21.

[jaslake]

Hi thedude1222

When I open your newly posted Workbook, "Enter Contract #" is in Cell A9. When manually I enter a Contract # in Cell A9 and Tab out of Cell A9, the Contract details are displayed. When I Clear Cell A9, "Enter Contract #" is in Cell A9 and all Contract details disappear. Does this NOT happen for you?

Regarding this

when i try and run macro it doesn't even show it existing

These are Event macros...you won't see them. They are triggered when an Event happens...you don't "Run" them...the "Event" runs them.