Using the Enter key (from a specific cell) to run a macro

**evertjvr** · 02-12-2012, 01:09 PM

I want to initiate a search macro by pressing the enter key after having entered the value to search

I don't want to use buttons or forms.

Is this possible??

Thanks

**Mordred** · 02-12-2012, 01:11 PM

So you want to run a search every time the enter button is pressed?

**evertjvr** · 02-12-2012, 01:14 PM

No just when moving from the single variable cell. the rest of the sheet must operate as normal

**Mordred** · 02-12-2012, 01:18 PM

So which cell or range of cells would you want this to apply to?

**evertjvr** · 02-12-2012, 01:19 PM

Two separate macro's one initiate from cell D3 and the other from G3

**Mordred** · 02-12-2012, 01:28 PM

Those would be the only 2 cells where you would want a procedure to run after the user presses enter?

**evertjvr** · 02-12-2012, 01:30 PM

Yes. the rest of the sheet is only for the results.

**Mordred** · 02-12-2012, 01:34 PM

Place the following code in the worksheet module that you want this to occur

Please Login or Register  to view this content.

**evertjvr** · 02-12-2012, 01:45 PM

The code is doing something good I just need to adjust the macros to work. will post the solution once I have it.

Thanks

**Mordred** · 02-12-2012, 01:48 PM

Please keep us informed.

**evertjvr** · 02-12-2012, 02:00 PM

Here is the working solution

Private Sub Worksheet_Change(ByVal Target As Range)
Dim FoundRng1 As Range

Application.EnableEvents = False
If Target.Address = "$D$3" Or Target.Address = "$G$3" Then
' Second macro is named Message1
Message1
End If
Application.EnableEvents = True
End Sub

and this is place on the VB sheet and not the module.

Within my macro I use an "IF" to rout between two.

Thanks

**Mordred** · 02-12-2012, 02:02 PM

Hi evertjvr,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

**evertjvr** · 02-12-2012, 02:10 PM

Here is the working solution

Please Login or Register  to view this content.

and this is place on the VB sheet and not the module.

Within my macro I use an "IF" to rout between two.

Thanks

Using the Enter key (from a specific cell) to run a macro

LinkBack

Thread Tools

Rate This Thread

Display

Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Solved: Using the Enter key (from a specific cell) to run a macro

Re: Using the Enter key (from a specific cell) to run a macro

Solved: Using the Enter key (from a specific cell) to run a macro

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions