statusbar

seacrest

Active Member
Joined
Aug 15, 2002
Messages
293
How can i return the contents of a cell in a statusbar.I also need to have some fixed comments prior to the cell contents

There is Cell Contents
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Like this:

Code:
Sub Test()
    Application.StatusBar = "Updating " & Range("A1").Text
End Sub

Put back to normal like this:

Code:
Sub Reset()
    Application.StatusBar = False
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,032
Messages
5,569,767
Members
412,291
Latest member
marypolitan
Top