LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Updating VB for info entered in a sheet Darin Kramer Excel Programming 4 August 14th 07 06:26 PM
Get Button Info/Location in when its clicked and pass to macro [email protected] Excel Programming 2 July 24th 07 11:19 PM
Get Button Info/Location in when its clicked and pass to macro [email protected] Excel Programming 0 July 24th 07 10:23 PM
Run a macro if a certain value is entered in a cell nickystan Excel Worksheet Functions 2 February 8th 06 06:47 PM
Make more info appear when mouse moves over a macro command button Jeff at Bosch Corp. Excel Programming 1 May 25th 05 09:44 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"