View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
munchkin munchkin is offline
external usenet poster
 
Posts: 57
Default Run Macro button after info is entered in a cell

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