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?

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Munchkin" wrote:

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

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!

"Luke M" wrote:

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?

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Munchkin" wrote:

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

Really confuse them and set the Enter key to not move selection after being
hit.


Gord Dibben MS Excel MVP

On Mon, 30 Nov 2009 08:38:03 -0800, Munchkin
wrote:

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!

"Luke M" wrote:

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?

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Munchkin" wrote:

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