Recent content by McCondichie

Thanks for the advice xlbo. I've got a clearer understanding for what you mean now. I'll look more into standard databases in excel before I ask any more questions and also see if its an option to modify my code. I should have kept it in mind when creating the system but I wrote it on Excel 2007...

Sorry for my stupidness, kind of lost in translation I guess. I have stored all dates in a column of their own. the reason for this is because there is an itersection between a date selected through the userform and a value selected from a range in Column A. After they insect, the cell is...

I didn't actually realise that was possible: Is there a post which would detail how to do this or would you be able to explain more? Many thanks T

I don't understand what you mean? Can you put a database into an excel spreadsheet? And if you can, whats the process of doing it. Thanks for your help, T

Thanks for the input xlbo, I have it in a spreadhseet for a few reasons, but specifically because not all users in the company have access (such as my dept) but everyone has Excel. This was dues to our licencing agreement. It would be great to use a database. I'll try the code which you...

I have a userform which gathers inputs from the user and then tries to find them in a spreadsheet. Because Excel cannot display all the days in the year because of column limitaions being 256, i put each month on separate sheets within the workbook. Is it possible to have this code find the data...

thanks for letting me know where to repost, apologies, i was meaning columns. Put rows instead. Excel 2007 is not an option because it would require the company that I work for to roll it out to all there users. Thanks T

I have a userform which gathers inputs from the user and then tries to find them in a spreadsheet. Because Excel cannot display all the days in the year because of row limitaions being 256, i put each month on separate sheets within the workbook. Is it possible to have this code find the data in...

Ah my silly spelling - My biggest apologies Skip. The code was not executing because of a spelling mistake which I had made. After doing the watches you helped with and also executing the final code, it now works. Thanks for all your help on this it is much appreciated. I have accredited you in...

I tired was you suggested but to no avail. Could it be that I need to use the text or value property of the equipment item also but define it like you have defined "DateValue". Sorry to be a pain on this Thanks T

Ok cool, i think i get it. My last question is - I'm trying to pass in user entered data for all the parameters you helped me set. I have created a userform which will get the data but i don't seem to be able to pass it into the code successfully. I thought it would be the following code given...

That works perfectly - thank you for all your help. However, I have one more question, how do I change the format of the date so that it searches for the format dd/mm/yyyy? Much Apreciated T

Apologies for not answering the question - was slightly confused at first on how to set up watches but I have used other debuggers and figured it out - anyway; I created the watches and found that it finds rFrom, but does not find rThru. It does find rEqip. So this means that rThru has got to...

After stepping throught the code - it takes all code lines into action with the exception of this statement With Application.Intersect(Range(rFrom, rThru).EntireColumn, rEqip.EntireRow) 'mark you cell here .Value = "X" End With It seems to step over this action, i presume...

this is the code which I am using! I have chosen to hard code the dates in to begin with and then eventually work it up for user inputs. I think the problem may be the way which I am referencing the equpiment name. "Dell 1" is the value in the equpment column. Dim rFrom As Range, rThru As...