Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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..
    Attached Files Attached Files

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

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

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

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

    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 <font color=red> =J4*2 </font color=red> ? <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    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

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

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

    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 < 10 And ActiveCell.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
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  6. #6
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

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

    Sorry

    Forgot to add the file attachment...

    Wassim
    Attached Files Attached Files
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  7. #7
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    Hehe..thanks a zillion Wassim..it works like charm..thanks for
    make it possible..regards. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •