Search results for query: *

In one section of my spreadsheet I want to calculate the elapsed time. So I have a formula like =Now() - $B$12 where $B$12 has the start date I do not know if Now() would be the correct function in this instance or not. Because the way that it is working it will calculate whenever the cell...

Thanks for the help. I used Dale's method and it did exactly what I wanted. Thanks

The length of this post is kind of ridiculous, but I have reached the extent of my programming know-how and could use some expert advice. I have one workbook that is pulling data from 12 other workbooks. On the workbook that pulls data from other workbook I have a shap that is assigned the...

Nevermind, I understand what I was doing wrong.

Okay, I haven't gotten to far on this. I want the chart name to be a value from on of the other worksheets. With the code below I get an error : Method 'Location' of object '_Chart' failed. What am I doing wrong? Dim Chart_Name, Goal_Values, Actual_Values Chart_Name =...

Also, I do not know how I would change the sections individually. Pretty much I don't know how to do this at all.

For some reason I could not search for any topics like this so I have to post it as a question. I am trying to make a pie chart in excel. There are going to be five values for this pie chart. I need the pie chart to be able to compare each of these five values with another set value and then...

Thanks for the help. The code worked great. I had to change the line case is "C","D","E" to case 3 to 5 to get it to work. I don't know why. I'm just throwing that out there for anyone who tries to use this in the future and has problems. Thanks

I am trying to create a macro that will record the changes that are being made to any cells within columns c,d,and e. From looking at previous posts I see that the worksheet_change event will be used to recognize the change in the sheet. But I have not been able to find any posts that help in...

I am trying to make a macro that will lock the values in a certain cell when a check box is checked. How would this be done?

This is a little trickier than the title may lead you to beleive. I need to insert a file into an excel document. It needs to be part of the excel file, it can not be linked to an outside file. Excel allows you to insert an object as an icon which is close to what I want to do. The only...

In an excel spreadsheet there are shapes and I need to be able to change the color of the shape when I click on the shape. Like if I click the shape it automatically changes to blue. Then when I click it again it changes to red. These colors will be predetermined. How can this be done?

If I search a database how can I display the results of the search in an order where the most recent item added to the database is shown first?

I need to be able to upload files onto the server that I am using. This website is hosted by another company.

I got this application from a book and when I try and run it I get an error. Below is the source for the placead.asp. This is the one I get the error on. The link for the website is: http://www24.brinkster.com/campbemr/placead.asp <% Option Explicit %> <!-- #include...

How would I use asp to send an email to every person who signs up for a mailing list that I have posted on my website.

This is the code I use everything is defined: Function CountAds(CategoryID) count = &quot;SELECT COUNT(*) as Total FROM Items WHERE TopicID=CategoryID&quot; Set rs = connect.Execute(count) CountAds = rs.Fields(&quot;Total&quot;) rs.Close Set rs = Nothing End Function I receive the error...

I include the adovbs.inc file in one of my applications and because of this I am getting a compilation error.Microsoft VBScript compilation error '800a0411' Name redefined /campbemr/adovbs.inc, line 14 Const adOpenForwardOnly = 0 ------^ Why is this happening?

After I set my database query into an object&quot; set object =&quot;Select * from Items&quot; How would I make it so that I could display the first ten results on one page then the next ten results on the next page and so on.