Programming
in [Excel]
|
How to copy ActiveX Controls which are locked on a sheet I have a couple buttons and a CheckBox on a row; all are ActiveX Controls. I'm trying to insert a row (lots of other things going on below) and then copy/paste the row above into the current (ActiveCell) row. I want to bring in the RadioButtons and the CheckBoxes down one row. It seems to work when I am in d... 7 May 2010 16:45
Photo in a sheet I recorded a macro while going through the steps of insert\picture\from file, but nothing happens when I run it. I've written several other macros that work just fine, but this one does butkus. The photo is on a shared network drive, if that makes any difference. "NickHK" wrote: Record a macro whilst yo... 6 May 2010 16:32
Checking Cell Value for a Date Is there a way I can check to see if a cell value has a date value... in any format? ... 6 May 2010 17:39
Running Excel 12.0 Application on Office 2003 After literally 30 hours of internet search I am asking for help.... I have developed an application in VS2005 + Excel 12.0 (Office 2007). Now, I learn that some of the client machines will have Excel 11.0 (Office 2003) and my application will not work. I have read all about PIAs (2003 and 2007). It seems t... 6 May 2010 18:45
Help with function VBA existing code. Hello, I have 2 pivot tables on the same worksheet. The WCtr field is a user select field so when a WCtr in pivottable1 choice is selected, I want to automate the same selection in other pivotable2. I got the following code, but it didn't update pivot2 when pivot1 is filtered. Please help with the code. Than... 6 May 2010 16:32
Lost X-axis after resizing charts using VB - not sure why... Hi, I used this code to resize a bunch of charts: Set cellsToCover = Sheet1.Range(cell1 & ":" & cell2) Set chartShape = ActiveChart.Parent chartShape.Height = cellsToCover.Height chartShape.Width = cellsToCover.Width chartShape.Top = cellsToCover.Top chartShape.Left = cellsToCover.Le... 6 May 2010 11:57
To determine the font of a cell and change it if required I need to have a sub The sub checks range A1 to A10 and determine the font of the cell IF the font is not Times new roman it makes the font to times new roman and the font size to 10 also, if the font is not installed in the system it should give a message. ANy tips will be appreciated Thanks in advance. ... 6 May 2010 13:06
Any way to show / hide sheets I need a way, when i open a workbook, to hide all sheets till the user enter the correct password. When the user enter the password i want be able to show all sheets. Please, someone can help me? Thanks ... 6 May 2010 13:06
Macro that delets rows if keyword is found In A column i have many cells with text . Sometimes cells with text , sometimes empty cells . From time to time consecutive cells ( like A5 and A6 or A5 , A6 , A7) have the same keyword . I want the macro , in this case, to delete the rows , keeping only the first one in a series of consecutive cells . I give an exam... 10 May 2010 09:53
Display Math Symbols in UserForm Is there any way of displaying mathematics symbols or equations (in the format that you would normally find in school textbooks) in a VBA userform ? I'm trying to avoid having to laboriously create GIF files for each symbol or equation just so I can display them in userforms. Thanks. ... 6 May 2010 10:48 |