Search results

DOH! That makes perfect sense actually and I don't know why I didn't spot that myself! ("can't see the wood for the trees" springs to mind). I will try this tomorrow as I am back home again at the moment. Thanks for your help. Sorry for being a thicko!

Thanks Luke, I think we are getting there now - the code works a little better now in that when I search for something, the ValidationBox has it's values restricted as normal and the top value is displayed automatically AND now when I select another value from the "search restricted"...

Ah I see what you've done there, but would this not mean that the "search restricted" values would reset themselves in my "ValidationBox" (making all values available to user) and also because therefore the "SearchBox" is being cleared AND "ValidationBox" is NOT equal to...

Hi again Luke, I did try your code above;- Private Sub Worksheet_Change(ByVal Target As Range) ' If Range("SearchBox").Value = "" Then 'I think there was a typo here...your posted macro 'would have caused the sub to always exit Exit Sub End If If...

Sorry Prasad, I didn't mean to sound so rude! I am very grateful for your help and your efforts, it's just that on this occasion I could not get your code to work for me (maybe it's just me being stupid though?). Here is my code;- If Not Intersect(Target, Range("Searchbox")) Is...

Sorry, only just spotted Prasad's reply above (I must have posted my message just after Prasad and not bothered to check if anyone had replied whilst I was writing my message!). Thanks for your effort Prasad, unfortunately your code does not work at all for me, in that neither when the search...

Ah thanks very much Luke, that's solved one problem and it definitely works better..., but... ...if nothing is entered in the search box (if the search box is cleared with a "Clear Search" button), it will correctly reset the ValidationBox to the ValidationBoxFirstValue AND then correctly...

Hi there I have a SearchBox (actually just a cell with a named range of "SearchBox") in my spreadsheet which allows the user to type a search term (obviously) which then restricts the results within my DataValidation drop-down cell to those items that meet the search criteria. Now what I want...

WOOHOO! That worked! Asa, Luke and Prasad and everyone else who has helped on my other post, you are all truly "Awesome in Excel". I owe you all a debt of gratitude! As I stated earlier, I have a little knowledge of VBA (a little knowledge is dangerous, I know) and although sometimes I know...

Thanks asa for the tip on the post problem, your advice worked a treat. Yes I have been having problems posting recently too!

Hi Luke, sorry for the rambling above, only I was trying several times to post the code and it was refusing, hence the posts declining into rambling as I was trying to sort out the reason - but yes if you could clean up the post that would be kind of you! My code should have looked like this;-...

Hi again Luke, I have just tried to post my code again, only for the same thing to happen, can you use your "Ninja Powers" to "un-spam" it for me please? Sorry and thanks

Hi Luke, sorry for the rambling above, only I was trying several times to post the code and it was refusing, hence the posts declining into rambling as I was trying to sort out the reason - but yes if you could clean up the post that would be kind of you! My code should have looked like this;-...

Sorry for the multiple posts, only this forum is refusing to allow me to post my code AAAARRRRGGGGGHHHH!!!!! Even though I've placed the code between characters is just simply refuses - I've tried reducing the number of characters thinking there was some kind of character limit or something...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim n1 As Integer Dim n2 As Integer Dim d As Integer If Target.Count > 1 Then Exit Sub n1 = Target.Row - 23 n2 = Target.Row - 25 d = 34 If (n1 - d * Int(n1 / d) <> 0 And n2 - d * Int(n2 / d) <> 0) Or...

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Dim n1 As Integer Dim n2 As Integer Dim d As Integer If Target.Count > 1 Then Exit Sub n1 = Target.Row - 23 n2 = Target.Row - 25 d = 34 If (n1 - d * Int(n1 / d) <> 0 And n2 - d * Int(n2 / d) <> 0) Or...

I have a slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code no longer function when accordingly, my code so far is thus;-

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code listed now no longer function accordingly, my code so far is thus;- Private Sub...

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code listed now no longer function accordingly, my code so far is thus;- Private Sub...

Slightly off on a tangent, what are the maximum number of characters allowed in a post? I seem to be having trouble pasting in my code...

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code listed now no longer function accordingly, my code so far is thus;- Private Sub...

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code listed now no longer function accordingly, my code so far is thus;- Private Sub...

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) - the problem I now face is that my original "Print" code and my "Edit" code listed now no longer function accordingly, my code so far is thus;- Private Sub...

Ahh... A slight problem... Linked to this post and my earlier post (selecting a range via a hyperlink and then printing selection) (http://chandoo.org/forums/topic/select-a-range-via-hyperlink-then-print-selection-automatically) - the problem I now face is that my original "Print" code and my...

Or maybe 3...? Let's just say I'll post this next bit in a few parts...sorry!