I have a search form that I have put together in Excel. It uses 3 cells D6, D8 and D10. I then have a button that pulls the values from those cells and uses them to generate a list of results. The problem I am having is that if I am entering a value into a cell, I cannot click the button without first clicking else where on the page to close the edit. Does anyone have any suggestions for avoiding this? I have tried [D9].Selected in the code for the button, but the click event doesn't even appear to be firing.

Thanks in advance

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

Are the cells on this sheet (D6 D8 D10) the only cells to be entered?

If so can I suggest you the following functionality, (it will open a User Form when a user makes the current worksheet the active worksheet)...

1 create a user form blank template in the VBeditor
2 place 3 blank text boxes in the form
3 place a button in the form
4 edit the code by double clicking the button you just created
5 the syntax for the SUB commandbutton1_click() will be be generated automatically
6 write the following code
7 Sheets("sheetname").Range("d6").value = textbox1.value
  Sheets("sheetname").Range("d8").value = textbox2.value
  Sheets("sheetname").Range("d10").value = textbox3.value
  userform1.hide

The user can then tab from textbox to text box and close the form when completed.

If you are more resctricted by your dev requirements please say how.

Cheers

Matthew

Thanks!! I was looking for something like that a few weeks ago, but obviously didn't ask it right! I think that will work, let me try it and get back to you.

Thanks again

Mike

Mike
EchoVue.com