Search results for query: *

Hi, I would like to create an add in that would warn me if I am saving to a specific folder. When I receive an email, with an excel attachment, if I open an excel file and save it - It saves to the temp email file and when I close the excel file all my work does not save so I would like a...

Hi, I have a cell in column A1 for 100 Cell C1 formula should be =A1+B1 However I would like it to be the value in cell A1 + the formula in B1 So the formula would be =100 + B1 If A1 were 150 the formula would be =150 + B1 Unfortunately the amount in A1 varies Any help would be...

Hi, I would like to determine if the activecell in another workbook is blank and do a procedure if it is. I can do it if I know which cell I am referencing but I would like to determine the activecell as the number of rows may change. Below is what I can do if I want to find a specific cell...

Hi, I would like to do the following Column A has items like A1 = Yes A2 = No A3 = Maybe A4 = Probably A5 = Always with a number of other categories down the line I have items in column B which could vary B1 = Yes B2 = Maybe B3 = Probably I would like to identify all instances where the...

I know the function to determine the version of excel the user is using It is =Info("Release") in the excel cells as a function. How do I convert that into visual basic. When I record macro and put the function into the cell I get the following Sub Macro2() ActiveCell.FormulaR1C1 =...

Hi, I have a userform which has the Userform Name What_a_Grey_Textbox_Means In the coding I want to call up this userform - the coding shows up as What_a_Grey_TextBox_Means.Show The difference is that it converts the word Textbox into a capitalization of Box (presumably assuming...

I would like to use the properties of cut for a formula while still maintaining the original place where the formula resided. For instance if the formula is in cell A3 =Sum(A1:A2) I want to move it to cell B3 and have the formula in B3 be =Sum(A1:A2) and still have cell A3 have =Sum(A1:A2) I...

Hi, I have a userform (Form1) and I have another userform on top if a certain event happens. (Form4) On the second userform (Form4) I have a command button that says Completely Start Over. In that code for the Completely Start Over button I state the following Unload Me Unload Form1 Unload...

Hi, I have an excel macro in Excel 2003 and I have 4 labels. The four labels are Salaries, Land, Buildings, Other If they all have dollars then they all will be shown at .top of 10, 20, 30, 40 etc However if Land is 0 I want to be able to move buildings to .top of 20, Other to .top of 30...

I have an button on my userform that allows the user to open a file, however if they select a file that is already open, I get a message saying that the file is already open and reopening it will cause any changes you have made to be discarded. Do you still want to reopen the file. If you say...

Hi, I have a program that runs with Adobe Flash Player 9 and it seems that there are memory leaks with this program, in conjunction with a poker program known as Jungle Poker. My system resources seem to go to 1 or 2%. The text gets bigger and I have to quit out of the program. Once I do that...

Hi, I have a program that runs with Adobe Flash Player 9 and it seems that there are memory leaks with this program, in conjunction with a poker program known as Jungle Poker. My system resources seem to go to 1 or 2%. The text gets bigger and I have to quit out of the program. Once I do that...

Hi, I have Excel 2002, occasionally when I save the program to a memory stick or winzip - when it opens and I try to run the program it gives me an exception error and closes Excel. I have noticed that if I click on the one of the forms in the box "Project - VBAProject" and then run the...

Hi, I have an excel macro in which I have to have several worksheet tabs. If they are missing it causes problems. I also have SAP and when you want to move or copy the tabs the copy is clicked and then it is disabled so that you can only copy (you cannot unclick copy) I tried to look through...

Hi, I have a macro in which I have to have several worksheet tabs. If they are missing it causes problems. I also have SAP and when you want to move or copy the tabs the copy is clicked and then it is disabled so that you can only copy (you cannot unclick copy) I tried to look through the...

Hi, I have several forms with text of different years. Each year I have to upgrade the information to match the following year (ie if the text stated 2006 Actuals I have to change it to 2007 Actuals) Within the code portion I can use the find / replace to change all the code, however if I...

Is there any way to change the font of the Userform Caption title bar from the windows default. As well, can you change the size of the userform title bar. I would like to decrease it. Thanks, Jeff

Hi, I have a macro with userforms that were configured in the Windows Classic Style. In that style the information contained on those userforms can be seen, however in XP with the height of the title bar and the Start Bar some of the information is missing / hidden. Is there any way to...

I would like to do the following procedure in one line - I think it is more effieient, when I click on a Command Button TextBox1.Text = TextBox3.Text TextBox2.Text = TextBox3.Text I tried doing: TextBox1.Text , TextBox2.Text = TextBox3.Text but I got an error message Compile Error Invalue...

Hi, I have a userform that has textboxes (approx 200) that have to be updated occasionally Some sample textbox names are: Salaries_2006 Land_2006 I would like to change them to Salaries_2007 Land_2007 Is there any way of using some sort of find / replace for the names in textboxes. The...