Threads Replies Last Post 1912 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   UserForm mechanics Have constructed a UserForm - frmDetail - with command buttons relevant to worksheet Detail. It activates at the worksheet level for the Detail sheet [ie frmDetail.show]. 1. I only want it visible on the Detail sheet. Have tried Unload Me in that sheet's DeActivate procedure, but it doesn't work. 2. When the form is activated, it's focus is on the form itself, so worksheet ops are ... 5 12/23/2008 3:15:02 PM Unique Dropdown menus Hello all, I have challenge. I need to have a few dropdown menus in Excel 2000 (I’m working in Excel 2007). My data is in columns A-G. Columns A-C have the duplication information: A=Deposit Date, B=Check# and C=Check Amount. E-G do not have duplication information: E=Ref#, F=Amount, and G=Text or message field. I need to have one dropdown menu list the Deposit dates, but only one dat... 2 12/23/2008 2:26:01 PM How do i find the text box number? I'm working on some vba for a friend and between saving, resaving, and changing, my code busts in the fact that it's looking for Text Box # and can't find it. My code is looking for TextBox 1 and can't find it. I know which box it is and I wanted to check to see if the box number has changed. How do I find that out? Does this make sense? I tried recording a new macro where I move the bo... 3 12/23/2008 2:09:49 PM Hide unhide non-contiguous columns I use the following code to hide/unhide a range of cells using a tick box With Columns("O:W") .Hidden = Not .Hidden End With I want to do exactly the same for columns G,J,P,R ie if they are hidden then unhide them, if they are not hidden then hide them Any help appreciated... 7 12/23/2008 1:54:01 PM Excel crash When I open a workbook and then click save, a sheet tab apears that says module2. If I click on the tab, excel locks up. What can I do to make this go away? Excel 97... 2 12/23/2008 1:28:06 PM Delay when writing cell information to Excel from VBA Macro When I loop through in VBA setting a value for a variable the loop goes fast. When I use cell(i,j).value to put the value in a cell there is about a 1 second delay between each cell. For 250 cells it is a long wait. Is there any way to control this wait?... 4 12/23/2008 12:54:55 PM Writing to the Registry Hi All, I'm developing an application which will be used on a company network. I am saving and retrieving settings to the registry, now by default the SaveSettings saves the settings to the CurrentUser section of the registry, does that mean that every computer on the network will save and retrieve different settings? In this application I need that at least some of the vsettings shou... 5 12/23/2008 11:46:02 AM Conditional Format Excel 2007 Hi All This will be an easy one for you experts I need help with a macro to solve the following Range N3:N200 if any cell in the range has a value of either 40 or 80 then in the Range O3:O200 the cells will have a value of 0(zero) formatted as 0.00 - Do not need any cell or text colours. I would put a command button on the sheet and assign the macro -- Many Thanks Sue... 3 12/23/2008 10:01:01 AM direct your sum in the right box? when i create a formula and my sum will go directly to designated cell. How could I create a formula on this? Thanks in advance. CABED... 2 12/23/2008 9:23:16 AM Invalid product key-code Good morning, Starting from an application “VB6” our software has generated an excel file through the creation of the object “Excel Application”(Code: CreateObject “Excel.Application”). Since today we never had any kind of problem about that, but some days ago the software has begun to give a message error “Good morning, Starting from an application “VB6” our software ha... 1 12/23/2008 9:04:02 AM help with a piece of code Im getting the error Method 'Cells' of object '_Global' failed on the following function My understanding is this is because im havent explicitly defined the sheet im working in. I have placed **ERROR ON THE LINE BELOW*** to indicate where the error is little help please. If i add another call to the sheet calc inside the loop then i get overflow errors. The weird thing is t... 6 12/23/2008 5:05:38 AM Export GridView to Excel (xlsx, Excel 2007 Format) Hi I have my application running in Windows 2000 and uses Office 2000. Below is the code wrriten to export excel file Response.ContentType = "application/vnd.ms-excel" If i try to run the same code in VISTA or XP Machine which uses Office 2007. I am getting below error. "The format not supported ... " what it could be the cause and how to resolve this. Irrespective of Windows 2000 (Off... 1 12/23/2008 4:45:01 AM If Statments I have a code the based on the user input of tr and rn will determine the value of bn. I tried to structure it as you see below but it does not pass bn on to when it needs to be used. Any help would be appreciated. tr, bn and rn are declard as long tr = InputBox("TOTAL BOXES IN THIS ORDERB.") rn = InputBox("THIS IS BOX NUMBER?") If tr = 4 Then ElseIf rn = 4 Then bn =... 6 12/23/2008 3:35:52 AM Copy cells from one sheet to another based on criteria Hi, I have accounting information on a sheet. One column is the account, the next one is the date of the movement, the next one is the amount, the last one is the comment. I would like to copy to another sheet the cells with the amount and the comment for one specified acount and dates included in one month. Do you have some code for this? I need help. thanks Nathalie... 2 12/23/2008 1:48:02 AM Large discrepancies between Yield() and its equation in online help I'm trying to create custom functions to do what Yield() and Price() do except to also allow 12 as the fequency argument (Excel's built-in Yield() and Price() accept only 1, 2, or 4 as the frequency argument; for all other values they return an error). The online help for Excel's Yield() and Price() functions show the equations used to generate them. I set up a worksheet to do randomized... 2 12/23/2008 1:15:04 AM LATE FEE RECONCILIATION - HELP!! Hi everyone, I have a basic account tracking sheet created one per account in a folder called TEST FOLDER. The tracking sheet mainly contain the total charge, amount paid, method of payment, the Month in which the payment is for, date of payment, and balance. Most accounts charge is calculated by Fixed Days X Daily Fee, but some are variable, which is calculated by Variable days X Da... 1 12/23/2008 12:52:10 AM Show Window Message with percent of work Does anybody knows how to create a windows message with the percent of work. Basically, I have a macro that is taking a lot time to run it because it is connected with three different softwares and I want to see the status while is working. What I am looking for is a windows message showing with the following status information: 1.- In what software is working. 2.- What percent of work... 3 12/23/2008 12:27:01 AM I can not insert a Image in the Form I have a form where I want to insert a image (GIF, BMP). However, when I click insert I got the following message: "THE IMAGE WAS NOT LOADED BECAUSE IT IS TOO LARGE" I have reduced the size, compressed it , etc. and it still no working. Could you please tell me what is the limit size I have to use in order to fit it?.. Thanks in advance. Maperalia ... 5 12/23/2008 12:26:00 AM Subtotal row formula Need the following formula to hit the 10th column over [column N at present, ie offset(0,10) ] for each subtotal row in d2.d500 - of which presently three rows come up, but there could be more or less rows depending on the content .... ActiveCell.Formula = ActiveCell.Formula & "/2" *** The tricky part [for me anyway!] is that it cannot apply to the Grand Total row, whose text also c... 4 12/22/2008 11:25:00 PM Avoiding Compile Error for Unsupported Methods I have written some VBA code in an Excel 2003 workbook that also needs to be accessible in Excel 2007, so the file format is 2003 (xls). Whenever I open it in Compatibility Mode in 2007 and then try to save it the Compatibility Checker pops up with warnings that I know will not cause problems for me. So, I added the following line of code to suppress the Compatibility Checker: ThisWorkb... 3 12/22/2008 10:23:51 PM Select Activecell and 65 Rows to the Right I want to go to the last used cell in Column A, move over 5 to the right, and then select the range from Column F to Column BR. I'm trying to run the code below, keeps failing on this line: ActiveCell.Resize(0, 65).Select Code: Cells(Rows.Count, "A").End(xlUp).Select ActiveCell.Offset(0, 5).Select ActiveCell.Resize(0, 65).Select Selection.Copy Sheet... 6 12/22/2008 9:45:01 PM Ctrl+F Find by value 1. When finding a text in Excel i want to look in Values instead of formulae. Is there a way to do this without actually changing the options in the Find and replace dialaog manually. Can this be done automatically through code? 2. Also, When i do Ctrl+F and find something, Excel finds the value in the hidden columns also. I dont want to highlight the hidden columns when searching. Any wo... 3 12/22/2008 9:33:01 PM converting active x buttons to Excel 2007 I am helping a client switch from Office 97 to 2007. They have some Active X buttons in Excel worksheets that have vba code behind them. When we convert the files to xlsm files, the code stays but the Active X buttons are renamed to command button 1, command button 2, etc. Is there a way to have them retain the names of the active x buttons so the code will run? Otherwise, we have to cha... 1 12/22/2008 9:12:10 PM Need VBA to capture who and when I have looked at http://www.mcgimpsey.com/excel/timestamp.html and it gave me some ideas and parts to use, but it isn't all that I need. I would like to on a worksheet change event: 1) on the same row as the cell where the change was made, insert the timestamp in column X 2) on the same row as the cell where the change was made, insert the userid of the person who made the change in... 10 12/23/2008 3:15:55 PM Create new directory Hello. How to you create a directory named the same as a date stored in a cell. say sheet MainPage has a date 25/10/2005 in cell C22. How do you take this and make a Direcotry 22-10-2005 in C:/Datefile folder. Thanks in advance. Francis.... 9 12/23/2008 3:21:00 PM 1912 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>