Register
Log In
Unanswered
Home
New Member
October 19, 2013
Offline
Has anyone noticed this anomaly?
Put the following into the sheet1 code window:
Private Sub Worksheet_Activate()
Sheets("Sheet1").Range("A1").ClearContents
End Sub
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.
See Answer
October 5, 2010
Offline
Hi Dave,
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.
Thanks
Phil
Answers Post
Most Users Ever Online: 57
Currently Online: Mynda Treacy
13 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Md. Rahman
Lilian Vo
Jane Kumwenda
David Miller
Efe Onwochei
LynAnn Williams
Brandy Kriger
purna chandar
E K
velissa barr
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
