Textbox1 to show results not working

[flyinghigher2011]

i have text or number in B:F with dates in col A, i got this code and i cant seem to find why its not working. this is done on a userform. when i put a date in the first text box i want all rows relating to that date displayed in textbox2. so if i put in 13 July 2013 it will show me all records relating to that date in textbox2

Please Login or Register  to view this content.

[abousetta]

Sorry to tell you it's not that simple...

Please Login or Register  to view this content.

You have to convert the two dimensional array (the range) to a 1D array then join the elements of the array to make a string.

abousetta

[flyinghigher2011]

well it sort of worked lol

Attachment 250024

not quite. would it not be simple just be able to the work sheet into textbox2 and get rid of textbox one and the button?

[abousetta]

It works because text boxes display text. What you are seeing is the text equivalent of the time and information in the remainder of the cells. It may not be what you imagined, but it is working correctly.

From the description you provided, I don't understand how you want it formatted.

What does this mean exactly?

would it not be simple just be able to the work sheet into textbox2 and get rid of textbox one and the button?

[flyinghigher2011]

It works because text boxes display text. What you are seeing is the text equivalent of the time and information in the remainder of the cells. It may not be what you imagined, but it is working correctly.

From the description you provided, I don't understand how you want it formatted.

What does this mean exactly?

Attachment 250025

please see imega

sheet 1 would represent my "progress schedule" sheet

[abousetta]

Did you photoshop that yourself? I've heard there was a worksheet object embedded in a userform in earlier versions of Excel but that has been discontinued.

You can get a similar approach using a listbox here. It was written by MVP JKP but I haven't had a chance to review the coding so won't be much help adapting it to your needs.

abousetta

[flyinghigher2011]

its microsoft office spreadsheet control 11.0 omg how the heck do i change that to do what i need but i like it

here is my file

Attachment 250032

[Norie]

Use a listbox.

[flyinghigher2011]

Use a listbox.

please look at my last post and you will see what im trying to do please.

[abousetta]

It was part of Office 2003. I downloaded it from the office website but it's not appearing my one of the additional controls. I think they disabled in 2007 or 2010 (which I'm currently using). Could you upload a workbook with it embbed? I want to see what errors I get when I open the file.

@Norie, you know more about this than me, do you if we can install the Office 2003 Add-in (Office Web Components) in Office 2010 (64-bit)?

Thanks.

abousetta

[flyinghigher2011]

Did you photoshop that yourself? I've heard there was a worksheet object embedded in a userform in earlier versions of Excel but that has been discontinued.

You can get a similar approach using a listbox here. It was written by MVP JKP but I haven't had a chance to review the coding so won't be much help adapting it to your needs.

abousetta

i just got his file

could you please take a look at it and tell me where with in the files that i need to change code as the button will be on a different sheet to where the info is kept.

ive had a look but perhaps im missing something

[flyinghigher2011]

i have got my form with the new code in but how do i point it to my information please

[Norie]

Which form is the one you want to display data on?