How to make a floating message.. (EXCEL 2000)

Topic

New Reply

Hello again guys…long time no see..I got a problem..
I don’t know how to revealed it correctly..but if don’y understand.plz refer to attachment..

I need to put X when my student got a wrong answer in my report..so I will put X..my problem is..I need to know their marks while I put X..because sometimes I accidentally put X unintentionally..so..can you guys figure a way..like when I in..let say…cell c4:i4..some thing like message of comment will appear and show me the student marks (K4) while I put X on them..is it possible..i know I can use freeze panes.but it take a lot of work to scroll left and right..you know what I mean..sometimes its involving 100 questions and you can imagine how difficult it is..thanks..

Reply | Quote

Replies

Have you tried Split screen? Click on K and hit Window-Split screen

Reply | Quote

NiuB

Sometimes you want to think out side the box. If you don’t like to freeze panes, how about putting the Marks and Total Mistakes columns next to the Item or name Columns?

You could do some VBA coding to update the Stausbar when the Number of Mistakes is changed, but that is way too much work vs splitting the screen…

If you need any help let us know.

BTW why do you have the formula =SUM(J4*2) instead of =J4*2 ?

Wassim

Reply | Quote

Thanks for you guys kind answer..I’m hoping something like
“X” indicator while I put the X through the range..I don’t know
Wassim suggestion using the status bar.so I can see the marks
progress..sounds interesting..why don’t you demonstrates to me
Wassim…and Wassim..one more thing..FYI..i use =sum..in my formula instead of =..because i use the menu button..thats all..its still the same right..thanks and any help will be appriciated..and looking forward to see that..regards

Reply | Quote

NiuB

No using the =SUM(J4*2) is not the same, because you are adding a cell. I am not sure if Excel will disregard the sum operation if there are no arguments for it.

Here is the code that you need to work with and adjust to make the StausBar update.

I have given you a lot of examples here, so you should be able to study the code and adjust it to how you want it to work. I also have attached the workbook you sent earlier.

Good Luck, and if you need any help, ask…

Wassim

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
‘/Test is you have a single cell selected.
‘/Count how many Rows you have selected.
If Target.Rows.Count = 1 Then
‘/Count How many Columns you have selected.
If Target.Columns.Count = 1 Then
‘/Test if the cell changing is in the Target Range.
If Target.Column 2 Then
‘/Test if the cell changing is in the Target Range.
If Target.Row > 3 And ActiveCell.Row < 9 Then
'/Ah you have selected a single Cell in the appropriate range.
'/Update the Status Bar.
Application.StatusBar = "The Marks for: " & _
Range("B" & ActiveCell.Row).Value & _
" is " & Range("K" & ActiveCell.Row).Value
Else
'/The cell being changed is not in Rows 4 to 8
End If
Else
'/The cell being changed is not in columns C to I
End If
Else
'/You selected more than one Column.
End If
Else
'/You selected more than one Row.
End If
End Sub

Reply | Quote

Sorry

Forgot to add the file attachment…

Wassim

Reply | Quote

Hehe..thanks a zillion Wassim..it works like charm..thanks for
make it possible..regards.

Reply | Quote