Search results for query: *

Hi Skip, Opps, selecting the event from the right hand drop menu was the bit I missed out. It now works perfectly - thank you, as always.

Hi Skip I thought about your suggestion before I posted but only mouse propertys listed in the Properties - CommandButton VBA box is MouseIcon and MousePointer. I am using MS Excel 2003. Any further suggestions

Is it possible to have or set a up or down property to an excel command button like you can to an access one. I want to be able to change the BackColour when the the button is clicked down and then back again to it's original colour when its up? Any suggestions would be great

Skip, Just wanted to thank you for your original code suggestion. Although my current knowledge of Excel / VBA would not allow me to use it correctly, PHV was kind enough to help me. Thank you again so much and I have no doubt that as I try to learn more, I will have more questions and then...

Hi PHV, Thank you so much. Your changes to Skips code work perfectly. I would never have been able to work it out myself - its just too complicated for me with my current level of Excel/VBA knowledge. I contineue to try to learn from the posts in this forum and with the help from people such...

Hi PHV, sorry I was trying to keep my questions short but I will explain further. I have incorporated Skips code as best I could without further direction but I just know I have got it wrong. I no longer get a compile error but Excel is still not displaying the data from the data returned...

Hi Skip, Thank you very much for both your time and reply. Where exactly do I place your code? Forgive my ignorance but I am trying to learn my way around. I have tried placing it within my own code but it produces a comple error? Thanks again

Hi - I have manage by trial and many many errors managed to kind of get this to work but now excel is displaying the result wrong. Excel is showing it like this: Results CD-C 0001 A B Wham Wake Me Up Before You Go Go Album Mix The Greatest Hits From The 80'S and i need it to be...

Hi Skip, Thank you so much for the reply - I really appreciate it but I have run into further problems. VBA is now highlighting in yellow the row I have enclosed in ** (obviously the ** is not actually part of my code). I have tried as many solutions as I can before posting for help again but...

Hi pinkgecko First let me say thank you for your reply - I really appreciate it. I thought I'd try the first part of your suggestion to start with and straight away I hit an error with the first line of code. I know I must be doing something wrong. I added the spreadsheet reference as you...

Hi guys, I have a workbook that I use as a database and different spreadsheets within the workbook contain different data. I wish to use one sheet as a search form and use code or a macro to search either specific sheets or/and all sheets depending on the user requirements. So for the purpose...