Run Macro button after info is entered in a cell

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

I want users to enter data in I3 then be able to click a "find" button which
will run the macro below, but the macro won't work because excel is waiting
for the user to click "enter" or "tab" after entering data in I3. How can I
make the macro work?

Range("J3").Select
Rows("4:5").Select
Selection.EntireRow.Hidden = False
Range("I3").Select
 
Until you finish inputting the command into I3, XL won't do any macros. Is
there some significant reason why the user can't hit "enter", "tab" or any of
the arrow key, or click anywhere else on spreadsheet before running macro?
 
I'm trying to create something user friendly for those that do not know
excel. I thought after they enter their data it would be nice if they could
just click a button. They get confused when they hit "enter" or "tab" and
they are moved to another cell. But you answered my question - I wasn't sure
if it was possible, now I know it isn't. I will just have to instruct them
to hit "enter" or "tab". Thanks!
 
Really confuse them and set the Enter key to not move selection after being
hit.


Gord Dibben MS Excel MVP
 
Back
Top