Replies

Hi Mich,

I do not believe it is possible to change the limitations on worksheet size. You might consider breaking your data up into more than one worksheet. I believe there is no limit other than system resources on the size of a workbook.

Thanks Gary,

I will use a form instead of the msgbox, and I will use the underscore in the future…

Thanks,

Hi David,

I am trying what you suggest. It seems though, after looking at the available rules, that there are a number of options you could apply to messages. Thanks for your input.

Hi Mary,

Thanks for the info….I really wasn’t aware that this was happening only when in the hotmail folders. When I go to the local inbox, there is no “extra” pane. Not really a crisis or anything, guess I woke up one day and said “Wow, was this here yesterday?” Anyway, thanks a bunch.

Anyway you two could clue me in on using the “Hidden Name Space”? I searched both Excel and the Excel VBA help and came up with blanks. How do you access it and/or refer to it?

Thanks,

Andrew, I must disagree with you….you exhibit much wisdom by not only the code, but the logic behind the two different approaches. I must say, I was not aware that you could define a value instead of a range. Wow! In my workbooks and code that I have created, using this approach could be a much preferred solution to some of the tasks I have tackled.

Many thanks! That bit of info sorta gets me thinking on a 4th dimension!

Thanks for your responses, both are very helpful.

Mary could you expand on the UNC format since the network drive is the major area prone to user “destruction”! I will look in the help files for more information on this.

Leif, funny you should mention this because I had another friend suggest a similar approach just yesterday. I have not had a chance to try it, but I think this might have some advantages over my current method. By the way, I am transferring text files between two PCs, and parsing the files into Excel. The remote location sends me sales, inventory results, etc. and I send the remote location price updates for inventory, labor guidelines, etc.

Thank you both,

Nice gif there eggs…

Hi Michael,

Check out the MAXA worksheet function in Excel 2000. In a test sheet, this returned the latest date in a column of cells formatted as date.

In my opinion it would be more meaningful to supply the last date of payment as opposed to the week, however I am no expert on tax laws where you are located. If you should however, wish to calculate the week, you could use the WEEKNUM function on the result of the MAXA function to return the week number of the value returned by MAXA as eggs ‘n’ bacon proposed.

For ex:

=WEEKNUM(MAXA(A1:A6))

returns 23 upon the range A1 to A6 where the largest value is 6/09/01.

HTH,

That is pretty nifty Brooke!

Thanks,

Thanks Jim, that looks very interesting, I did not know how to torture a text box so much! Much obliged!

Hi all,

The custom format did not change the results in the textbox. I did, however, update the textbox contents in the form_activate event and used the textbox_change event to update the cell as Rory suggested.

Hi all,

Just another bit of information…

When I used the ControlSource property in the properties window for a new workbook, the code =Sheets1!C1 worked fine. However, when I tried to go back to my original workbook and use similar code, I received the same error code again.

So I deleted the original sheet that the ControlSource property referred to and copied the cell information to a new sheet. Thus far, it seems to have eliminated the problem. I can only figure that some of the data in the original sheet was corrupted somehow, because the ControlSource property seems to work fine with the new sheet.

FYI,

Thanks for the thoughts on this Hans. As you mentioned in an earlier post on forecasting, I think I have probably “tortured” my form and the various controls therein. Regardless of what caused it, I finally got the “design” time method of the control source to work. Many thanks for your input(s).

By the way, I do get the property listed after I press the “.” in the listbox containing the properties for the TextBox. Go figure…tortured control sources?

Blazes, must be time for some time off…this is the code I put in the properties panel for the control source which worked great…

=sheet3!c1