Keyboard button 'event'

[CalvinGraham]

I gather there isn't a way to have an event triggered by the keyboard?

I have a system set up with graphs/tables and a search box so you could enter a value and the filters change. Of course, you could use the fitlers themselves manually but I've set up with sheet for people who don't have a clue about Excel. They should just be able to enter an office/product etc and select the chosen option from a set of cells/results.

Currently this works great except you have to hit Enter. I was really wanting an event like "Keypress" so that it could update after every letter, a bit like Google search. I could use a form but I'd rather keep it streamlined and on the worksheet

 

[RoryA]

You can use controls on sheets as well as on forms. or you could just have a little floating form used as a control. Or use menu items.

 

[JamesW]

Hi there,

Can you not use the Selection Change event?

e.g. Office/Product value is in cell A1, option Choice is in B1:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, Range("A1:B1")) Is Nothing Then
        doStuff
    End If
End Sub

 

[CalvinGraham]

At the moment I've been using the selection change but that means you have to hit enter to leave the cell and invoke the event.

Interesting the thing with controls. I've always used the Forms toolset and frankly not really understood the difference between forms and controls. I found controls better because, say, if you had listbox you can right click, Format Control and there's a Control tab to assign it quickly to the worksheet. Doing a bit of reading based on here suggests that controls are more vb than excel? There's also a Mac compatibility issue I think, not much of an issue normally but my system at home could kick up a fuss if I was working from home

 

[JamesW]

Ahh, sorry Calvin - I misread the OP and thought you wanted an enter event rather than an auto update after every letter...

 

[RoseG]

Hey

I don't know if I've fully understood what you're asking for but could you set a combobox to appear when the title bar is selected? Typing in this would move you through the attached list as you typed, until a unique match is found.

The filter could be triggered by this unique match, with reference to the selected value.

Does that sound like the sort of thing you're looking for?

Rose