Results 1 to 3 of 3

Thread: can not use undo (vba excel)

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2005
    Posts
    13

    can not use undo (vba excel)

    Hello.

    I made an vba excel application.
    (when i do an entry in a specific cell, the cell is validated by an vba function and some network communication is made).

    However, when i do an entry in such a cell and the vba functions are performed, i see that i can not use the "UNDO" button anymore.
    (when i do an entry in other cells that don't call the functions, the undo button doesn't has that behavior)

    very strange.
    how does it come and what can i do?

    thanks in advance

  2. #2
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: can not use undo (vba excel)

    Oooh ... something in the back of my foggy brain says that you can 'bump' the undo list in your VBA function ... I'll try to figure that one out. It is a line of code you put in your function.
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

  3. #3
    Frenzied Member
    Join Date
    May 2004
    Location
    Carlisle, PA
    Posts
    1,045

    Re: can not use undo (vba excel)

    I must have been thinking of some other language ... check this link in this forum:
    VBA Undo - Excel
    It says that you have to implement special code that 'remembers' what was done by your macro so that it can be undone by your code. Sorry.
    Blessings in abundance,
    All the Best,
    & ENJOY!

    Art . . . . Carlisle, PA . . USA

Posting Permissions

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



Click Here to Expand Forum to Full Width