Replies

Thanks for the input. I couldn’t find anything.
Finally did a test on the corporate WAN. We managed to get 10 folks connected to the host PC using v3.01. I think we could have gone higher. So we still are not sure what the limit is.

One solution is to set both the data validation and the form to get data from the same named range.
For the validation choose list and =RangeName. Works even if the range is on a different sheet.

Thanks.
That is what I was looking for. I was try to avoid making multiple x, x^2,… columns. Didn’t think to use the XRange^{1,2,3}. Also wanted a 0 intercept which is false on the 3rd parameter. I just love double negatives.

An alternate way is to use different series for the different colors. Have the base data in the first column. The second column has just the blue data points. The third has red and so one. Make a bar chart from the 2nd column on. Each series gets a different color. Adjust the bar widths and overlaps so that the bars plot on top of each other. This won’t be a problem since at each data point you have only one column with data in so only one bar will plot.

What is the error. I tried to duplicate, but i didn’t get an error.

If you use Excels built in date/time formats, the values must be positive. A negative value formated to time is displayed as #######. One workaround is to convert from time to decimals or either minutes, hours, days (whatever works for you particular case. In Excel dates 1 = 24 hours. (Since you are dealing with relative time, we can hopefuly ignore base dates) 11:30am = 0.4792 (days) If you want decimal hours just multiply by 24 and you get 11.5 hours. If you need hh:mm:ss then try something along the lines of
=SIGN(A1)*INT(ABS(A1))&”:”&(ABS(A1)-INT(ABS(A1)))*60

I would replace your IF THEN ELSEIF with a SELECT CASE statement and eliminate the FOR i = to to 250.

If ncell.Value “” Then ‘ If cell is blank then it gets skipped
Select Case ncell.Value
Case 1
ncell.Interior.ColorIndex = 3
Case 2
ncell.Interior.ColorIndex = 4
Case 3
ncell.Interior.ColorIndex = 6
Case 4
ncell.Interior.ColorIndex = 7
Case Else
End Select
End If

This lets you do other things with non-numeric cell values if you want.

I think the problem is that Excel is running inside IE. With Excel 97, VBA gets confused as to which application the code is refering to. It wants to run in IE instead of Excel, which is not what you intended. I guess they have fixed it in O2000.
I can’t find the exact Q but I remember reading it, because we had a similar problem. I haven’t tired it with 2000 yet.
We have added a note saying that the spreadsheet may not work inside the browser, so right-click and save Target as.
Not overly helpful though.

Thanks for the reference. It didn’t solve the problem but gave me some better keywords to search by. I am always a bit surprised to see crash as a keyword….

Seems my touble was MDAC.

Thanks

Thanks for looking. Not really what I was looking for though. Using that link as a base. I need the form to be able to have mulitple ‘Title’ or ‘Title’ …. ‘Titile’ . The SQL isn’t a real problem it is more the DHTML need to create the user input from.

The last parameter of Vlookup is Range_Lookup. If it is set to false then you need an exact match to return a result. Something like
=vlookup(testname,matchlist,1,false)
If you name is there then you get at match else you get an error.

Lets not forget the the alt-Print Screen. Copies the active window into the clipboard. Paste into photo editor and crop. Fast, simple, and you already have all the parts. Works for any application

Try the text to columns. Pick the Year/month/day format for your input column

Photo Editor error. “Cannot find or open File.”
Found the error in MS knowledgebase but their solution did not work for me. Q260151

I have the same problem. Opening a JPG is no longer a choice in PE, nor can I save as. I am guessing a dll but I have no idea. which one