Search results for query: *

Using Excel 2010, I am attempting to create an XY scatter platter with multiple series. The series names are arranged as rows in my source table with corresponding X and Y values on each row. Sample data below. Working with this example, I'd like five series (00110, 00401, 00405, 00415...

Skip, I know that line of code should have nothing to do with any links, however, it is very clear that when that line is executed by stepping through the code, the link that was updated gets reset to the original value. BUT this is only happening in 2010. The links do not have formulas...they...

I have an excel workbook that is linked to a second workbook. I also have code written in the first workbook that opens a 3rd workbook, copies comments from a textbox, and then pastes them into the first workbook. Here is my problem. In 2007 this works perfect but in 2010 when the code is...

Got it. Thanks!!

Skip, OK, i finally got that to work. i didnt realize that i had to turn on the developer button on my ribbon to get to the active X controls. But here is my problem using that. It doesnt seem like i can hit the enter key in an active x text box and have it return to a new line like i can in a...

Skip, Have you actually tried this code in excel and does it work? I cant get any results no matter what i try.

Skip, How do i get to the properties of the text box to put this as an "on change" command. right clicking on it and selecting the 'Assign a macro' puts it as an "on click" command and then i get an error 438 - Object doesnt support this property or method. Sub TextBox1_Click()...

I cannot find any information on how to do this. The reason that i am starting with a text box is because it allows users to hit the enter key to go to a new line. This spreadsheet is used to have a group of users enter comments explaining why sales trends may be down and they like to enter...

I didnt realize such a function existed but that is exactly what i need. Thanks!!

i have a spreadsheet that has a column of names and another column of sales $. I am going to add a 3rd column with an identifier for certain rows that I want to exclude in a total at the bottom. how can i write a sum that looks at a different column to know if it should include/exclude the Sales...

Unhiding rows that were previously hidden the last time the report was saved, sorting on a given column, and then hiding rows that have a value under $x. I just didnt want to "hard-code" in a range of rows because the report may grow or shrink so i am doing a Find and then getting the value of...

This is probably easy but i just cant seem to write this correctly. I am trying to select a range of rows in Excel but i want to select it by using a variable. Standard way: Rows("2:12").EntireRow.Select What I want to do: Where IntStartRow = 2 & IntEndRow = 12 Rows( ? IntStartRow : IntEndRow...

Sorwen, Ok, I think that solved all my issues. Thank you so much for all your help! You def earned a Star!

I did not realize that I had to drag the DataSet onto the form. I thought it would populate the table and then I could open the table from the .xsd tab. However, this line of code: "Dim workTable As DataTable = Me.DataSet1.Tables("Table1")" does not produce an error at the bottom of the...

Dim workTable As DataTable = Me.DataSet1.Tables("Table1") I get an error that says "Dataset1 is not a member of the form name that I have the button on to execute the code. Do I have to link them somehow? And you are saying that if I close the form, that my data disappears with it leaving an...

Sorwen, Answering your second post... Table1 under the tab DataSet1.xsd is the table I created to put the data in to store it. I am going out to an internet page, using variables to hold several pieces of data from that site and I want to stick that data into Table1 at the end of the code...

Maybe I am missing something. In Access if I have a local table "Table1", I can refer to it in VBA and update records on it. Example: Dim D1 as Database Dim R1 as Recordset Set D1 = currentdb() Set R1 = D1.openrecordset("Table1") R1.Addnew R1("Cust_name") = "John" R1("DOS") = Date()...

Andy, Thanks for the tips. I was just using a made up example so someone could direct me on how to write what I am trying to do. Any help with how to do it?

Hi, I am new to VB. I am actually using Microsoft VB 2008 Express Edition so I hope I am posting in the right place. I have used VBA for many years but I am trying to learn VB and I am having trouble with probably the easiest code to most of you. I have searched and read for hours on msdn for...

Has anyone ever used VBA code to not only open a Remote Desktop Server but to then control that screen? For example, be able to input to the username and password, and use other controls on the screen without any type of send keys commands (I hate those). Thanks