Consulting

Results 1 to 3 of 3

Thread: Solved: someCell.activate and then showing up on screen

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jan 2006
    Posts
    11
    Location

    Solved: someCell.activate and then showing up on screen

    Hi,
    i'm building a tool thatl loops through each cell in the workbook, but i want a cell that is actually activated to also show up on the screen, so the user sees what cell has just been activated.

    i thought that just activating the cell would be enough
    [vba]
    for each theCell in activeSheet.usedrange.cells
    if theCell.value="something" then
    theCell.activate
    end if
    next
    [/vba]
    but if i do something like this, the cell IS activated, but the user doesnt see anything happening on screen If that cell is not currently visible on the screen.
    this means that the user has to scroll down and stuff, instead of the activated cell being brought up for him to see.

    is that supposed to happen?
    or is there something like
    theCell.GetFocus

    or have i screwed something up with application.screenupdate=false or something like that



    thanx in advance!
    Last edited by Koesper; 02-06-2006 at 07:04 AM. Reason: added some info

Posting Permissions

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