October 19, 2013
Has anyone noticed this anomaly?
Put the following into the sheet1 code window:
Private Sub Worksheet_Activate()
Now enter something into Sheet1 cell A1.
Select A1. Note that the contents appears in the formula bar, as expected.
With A1 still selected on sheet1, select another sheet, then go back to sheet1
Cell A1 is cleared, but the contents is left in the formula bar.
As soon as a different cell is selected, the formula bar is cleared.
It doesn't seem to create any issues, but a bit disconcerting when returning to a sheet that should have a clear cell.
Interestingly, if I use Sheets("Sheet1").Range("A1") = "" in the event macro, this doesn't occur.
October 5, 2010
I had not seen this before but I can reproduce it. Also, if you leave A1 selected, click in the formula bar, then hit Enter, the data is entered back into A1.
So it looks like the formula bar contents are not being cleared, which I would consider a bug.
We'll raise this with Microsoft.
Most Users Ever Online: 57
Currently Online: Mynda Treacy
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas