Userforms on multiple sheets?

[McCondichie]

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 the sheet which is currently selected? If so, how would I go about it???

Many Thanks

T

 

[HughLerwill]

This is the VB5/6 forum you should post this in forum707

 

[strongm]

But before you go there you might just want to check up on the idea of "row limitaions being 256". Excel supports 65535 rows. It is columns that are limited to 256.

As a matter of interest, Excel 2007 ups both of these limits significantly

 

[McCondichie]

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