|
Cuentas anuales en excel
2008-09-30 01:04:00 Archivo en Winrar, que se compone de una tabla Excel con la que se pueden preparar las cuentas anuales adaptadas al nuevo plan de contabilidad que entró en vigor este año.En ContaFiscaDescargaMás informaciónSalas-Segales
Ranking in Excel
2008-09-16 13:49:00 How can I provide a running total of first, second and third place in Excel, given people and numbers, like this: Mike 100 Jane 200 John 26 Peter 75 In first place is Jane with 200 (etc) such that the cell with Jane in it automatically changes the name if the number
Excel Invoice Template
2008-09-11 09:59:00 Need Excel invoice template? , you can download it now for free. This template provides a Fill In The Blank invoice form and is capable of creating and calculating invoices. The template shows quantity, description, unit price, taxable status, and amount per line. Sub-total, tax and total amount are computed from the line items automatically. With ...SHARETHIS.addEntry({ title: "Excel Invoice Template", url: "http://dailyfreeware.net/2008/-09/11/excel-invoice-template/"- });
By: daily freeware
Excel Invoice Template 1.2
2008-08-18 06:49:00 Download this Excel Invoice Template , you can very easy create invoice using its true what-you-see-is-what-you-get form. The template shows quantity, description, price, taxable status, and amount per line. Sub-total, tax and total amount are computed from the line items automatically. SHARETHIS.addEntry({ title: "Excel Invoice Template 1.2", url: "http://dailyfreeware.net/2008/-08/18/excel-invoice-template-12-/" });
By: daily freeware
vba excel user defined
2008-07-25 09:26:00 How to create excel user defined function and to delete.?
iPhone 2.0 Firmware: Microsoft Office support, Word, Excel, and PowerPoint
2008-06-10 10:07:00 The new Apple iPhone 2.0 Firmware not only includes Microsoft Office support, Word, Excel, and PowerPoint but also has the best email on a mobile phone, up to the minute calendar, more powerful contacts, desktop class web browsing, enterprise applications, smarter phone features and more for business. We will show you below what each one ...
By: Phones Review
Beautiful Weanling Appaloosa. Will excel at everything
2008-06-08 17:17:00 BEAUTIFUL black-bay blanket filly. Has the ability and disposition to take you as far as you want to go. She is going to be a world champion someday. Beautiful filly, get her while she is cheap! (imprinted at birth) Located in Morrison, TN. Email for pedigree. Dam is PL Secret Cinna and her Sire is Plaudits Top Success. She is reg. I just don't have her number. (guessed on weight and height. She is HUGE for her age though!) Price obo
By: Equine Now
Amazing Article Marketing - 5 Authentic Ways to Excel at Article Marketing
2008-06-08 00:00:00 There is no doubt that article marketing is currently the best free marketing and product promotional tool in the internet today. It can easily drive quality traffic to your website, pull up your search engine ranking, position yourself as an expert on your chosen niche, build trust and customer loyalty among your potential clients, and ...
MS EXCEL 97-2007 BINARY FILE FORMAT SPECIFICATION
2008-06-07 00:43:00 MS Excel 97-2007 Binary File Format Specification | 349 Pages | 3.06 MB
Excel tipp: szÃ?¶veg Ã?©rtÃ?©kre alakÃ?ÂtÃ?¡s
2008-06-05 22:55:00 http://www.hatekonysag.hu/blog/- tippjei: Ha az excel valami�©rt nem sz�¡mol, a vide�³n l�¡that�³ l�©p�©seket hajtsuk v�©gre. Full Article
Microsoft Office 2003 problema con SKU011.CAB
2008-06-05 13:45:00 Este es uno de esos post para no olvidar las cosas que vamos aprendiendo por el camino. Desconozco el motivo/causa de los errores de Microsoft Office 2003, entre ellos, hay algunos cuya solución es sencilla y sin embargo puede traernos verdaderos dolores de cabeza. Por ejemplo, el siguiente error con el fichero SKU011.CAB: Síntomas: No podemos abrir ...
By: Xperimentos
Microsoft® Excel 2000 Simplified® (Paperback)
2008-06-03 06:06:00 Microsoft® Excel 2000 Simplified® (Paperback)By Ruth Maran 16 utilised and new from $1.80 Customer Rating: First tagged “excel” by C. D. Cohron “chetdc” Customer tags: excel Technorati Tags: excel
Do Hard Things: A Teenage Rebellion Against Low Expectations (Hardcover)
2008-06-03 06:06:00 Do Hard Things: A Teenage Rebellion Against Low Expectations (Hardcover)By Alex Harris Buy new: $16.99$10.19 Customer Rating: First tagged “excel” by J. Peterson Customer tags: christian(25), teen(24), teenagers(22), nonfiction(17), young grown nonfiction(16), ...
Microsoft® Excel 2000 Simplified® (Paperback)
2008-06-03 06:06:00 Microsoft® Excel 2000 Simplified® (Paperback)By Ruth Maran 16 utilised and new from $1.80 Customer Rating: First tagged “excel” by C. D. Cohron “chetdc” Customer tags: excel Technorati Tags: excel
The Eb Real Book, Sixth Edition (Plastic Comb)
2008-06-02 05:06:00 The Eb Real Book, Sixth Edition (Plastic Comb)By Hal author Corp. Buy new: $25.00$25.0024 utilised and new from $18.51 Customer Rating: First tagged “saxophone” by A. solon “FRSA” Customer tags: 5th edition ...
EXCEL Worksheet from VB Program
2008-06-01 05:57:00 Hi Any software expert who can tell me how to create and load data into excel file from VB and VC programs? Where to find details on excel worksheet data format/s?
An Excel Tutorial for Combining the TEXT and the NOW Functions.
2008-05-29 11:48:00 I hope you enjoyed yesterday’s Outlook Tutorial but for now you can forget about it because where picking up where we left off with our Microsoft Excel Tutorial week. I explained in the Excel Tutorial for using the TEXT and the TODAY functions that Microsoft Excel saves the dates in his software as a sequential number. ...
An Excel Tutorial for Using the TEXT and the TODAY Functions.
2008-05-27 11:29:00 It’s the second day of the Excel Tutorial week. Yesterday was Monday and Monday is of course the day that we need to take it a bit slow and we did so with an Excel Tutorial with the formula for checking future dates. Today we are taking it a bit further. It is still kind ...
Excel VBA - 1004 -- The file could not be accessed
2008-05-26 02:32:00 Solution for 1004 -- The file could not be accessed while saving the File1004 Microsoft Office Excel cannot access the file 'C: emp'. There are several possible reasons:• The file name or path does not exist.• The file is being used by another program.• The workbook you are trying to save has the same name as a currently open workbook.1004 -- The file could not be accessed. Try one of the following:• Make sure the specified folder exists.• Make sure the folder that contains the file is not read-only.• Make sure the file name does not contain any of the following characters: ? [ ] : | or *• Make sure the file/path name doesn't contain more than 218 characters.This error occurs because of unwanted characters in the File. The following function would help in removing those characters:Function ClearCharacters(ByVal sDirtyString As String) As StringDim arUnWantedCharacter(1 To 6) As StringDim IsClear As BooleanDim i As IntegerDim strCleanString As StringDim j As...
Menganalisis Invoice dan Hasil Penjualan :: EXCEL
2008-05-25 20:53:00 Anda dapat menggunakan fungsi IF untuk membuat formula kondisional yang menganalisis data dan memberikan nilai berdasarkan hasil analisis. Sebagai contoh, di sini kita akan menganalisis data finansial dari invoice pelanggan dan hasil penjualan. 1. Buka Data Invoice dan Penjualan Buat contoh worksheet seperti yang tampak pada gambar. Pada contoh ini kita akan membuat worksheet supaya menampilkan pesan ...
By: warna warni
Membandingkan Data pada Dua Daftar :: EXCEL
2008-05-25 20:51:00 Sebagai arsip data finansial, Anda sering kali harus membandingkan dua daftar untuk mencari data yang ada pada yang satu tetapi tidak ada pada yang lain. Klien mana yang perlu ditambahkan ke database utama? Tanda terima kartu kredit mana yang tidak muncul pada laporan bulanan dan sebaliknya? Cek mana yang belum diuangkan? Excel dapat membantu Anda ...
By: warna warni
Microsoft Excel 5.0 for Macintosh: QuickTorial (Spiral-bound)
2008-05-24 05:05:00 Microsoft Excel 5.0 for Macintosh: QuickTorial (Spiral-bound)By Patricia Murphy 2 utilised and new from $82.44 First tagged “excel” by Eleanor K. Noguchi Customer tags: excel Technorati Tags: excel
Microsoft Office System Inside Out ? 2003 Edition (Inside Out) (Paperback)
2008-05-23 07:05:00 Microsoft Office System Inside Out — 2003 Edition (Inside Out) (Paperback)By Michael J. Young Buy new: $49.99$34.9984 utilised and new from $1.96 Customer Rating: First tagged “excel” by RockNRandy “IT student/home recorder” ...
Print Your Excel Comments.
2008-05-23 05:00:00 The last Tip and Trick for this week is an Excel Tip and Trick. Today I want to show you something cool/useful that has to do with the comments in excel. We already know that using comments in MS Excel can be really helpful. Normally you only make the comments in your spreadsheet and you don’t ...
Excel for Teachers (Excel for Professionals series)
2008-05-21 18:19:00 # Publisher: Holy Macro! Books (January 1, 2006)# Language: English# ISBN-10: 1932802118# ISBN-13: 978-1932802115Addressing a classroom teacher's need to simultaneously manage a classroom full of students, meet state-mandated assessment standards for students, and track students' performance against a rubric, this overview of Excel shows how to put its features to use immediately in a classroom. Tracking attendance, grades, and books in the school library, creating reports to share with parents at parent?teacher conference time, and teaching basic charting concepts in a mathematics class are among the possible uses of Excel covered in this guide.Only registered users can download this file. Please Register or LoginPassword:ganelon
Microsoft Office Excel 2007 Version Upgrade (CD-ROM)
2008-05-21 06:05:00 Microsoft Office Excel 2007 Version Upgrade (CD-ROM)By Microsoft Buy new: $109.95$94.4931 utilised and new from $92.50 Customer Rating: First tagged “powerpoint” by K. Sebastien Customer tags: spreadsheets(2), excel(2), powerpoint, defectivebydesign, excel 2007 ...
Create pictures on Microsoft Excel from bitmap images
2008-05-20 11:55:00 Blogger Jalaj has produced a wonderful kind of art. He has written a program in Visual Basic that takes a BMP image and recreates the picture in a spreadsheet by filling every square cell with color. Excel Art can only create this from BMP images, as Jalaj explains: Since GIF and JPG have complex file formats due to the Compression algorithms used, I though an Uncompressed 24 Bit BMP file would be the best choice. This idea of using Microsoft Excel to create pictures isn't new. Similar... ...
By: Instant Fundas
Microsoft Office Student and Teacher Edition 2003 [OLD VERSION] (CD-ROM)
2008-05-19 05:05:00 Microsoft Office Student and Teacher Edition 2003 [OLD VERSION] (CD-ROM)By Microsoft Software 11 utilised and new from $199.00 Customer Rating: First tagged “excel” by JC Angelcraft Customer tags: defectivebydesign(12), software(11), computer software(6), ...
Budget Compiler QuickBooks Excel
2008-05-17 02:03:00 Format QuickBooks Profit and Loss data for review and automated budget creation.
Video Tutorial: come velocizzare sensibilmente l?apertura dei file di Word
2008-05-16 12:00:00 Guarda il video a schermo intero Bisogna ammetterlo: nonostante rispetto al rivale gratuito ed open source OpenOffice risulti ancora una scheggia, l’apertura dei file con Microsoft Office 2007 non brilla molto per la sua velocità. Basta infatti provare ad aprire un qualsiasi file di Word o Excel per rendersi conto che, la prima volta che quest’operazione viene ...
By: Geekissimo Blog
Gambhir and Dhawan excel
2008-05-16 07:16:00 Dhawan scored 68 nout and Gambhir 79 in a glorious century partnership. And Deccans could not score tha 195 needed.Earlier Sehwag was taken; his favourite shot to third man and he was caught ! A trap well arranged by Gilchrist.Mishra took a hatrick and took 5/16. Well, IPL is a great opportunity for youngsters and Dhawan and Mishra are the new heroes. The world knows about the Gambhirs and the Sehwags. About the Mishras, the Dhawans, the Kulkarnis, the Gonys, the world knows not.IPL and ICL are great opportunities for Indians and other upcoming youngsters from other countries -Shaun Marsch, Cameroon White - to showcase their skills. The organisers are also improving their skills and within 3 years, we will have state of the art international stadiums as well. All will upgrade their skills - players, commentators, the bosses of teams, broadcasters - and India will become a world power in the globalising scenario !Gambhir leads with 427 runs, followed by Dhoni 332 and R Sharma 331. Sr...
Scraping Information from Websites and creating XML/Excel File by anthonyef
2008-05-16 00:50:00 I need to scrape the following every 180 seconds; * Event name / Date / Start Time / Game Number / Team(s) / Team Number / Bet Type / Odds / From the following websites (some of them have xml feeds... (Budget: $30-250, Jobs: Data Processing, Excel, XML)
Excel Programming: Your visual blueprint for creating interactive spreadshe
2008-05-15 06:05:00 Excel Programming: Your seeable plan for creating mutual spreadsheets (Visual Blueprint) (Paperback)By Jinjer Simon Buy new: $17.8139 utilised and new from $8.07 Customer Rating: First tagged “excel” by V. K. Noll “denalinoll” ...
Tutorial Microsoft Excel Online
2008-05-14 09:40:00 Berkembangnya dunia kerja, banyak yang menuntut kita untuk dapat mengunakan microsoft excel, yah gak perlu jago-jago amat sih tapi bisa. Namun gak sedikit juga perusahaan memaksakan kita untuk lebih dalam lagi mengunakan microsoft excel, biasanya microsoft excel ini digunakan hanya bagian-bagian tertentu saja di perusahaan, tapi jangan salah, bagian-bagian lain kadang-kadang berurusan juga dengan microsoft ...
By: Byadha.com
Manual de Excel 2003, Basico
2008-05-14 09:17:00 Datos TécnicosManual de Excel 2003, BasicoSpanish | Doc | 131 Páginas | 2.73 MB | Full Color | Básico | Autor: AnonimoDescripciónExcel 2003 es una hoja de cálculo integrada en Microsoft Office. Esto quiere decir que si ya conoces otro programa de Office, como Word, Access, Outlook, PowerPoint, ... te resultará familiar utilizar Excel, puesto que muchos iconos y comandos funcionan de forma similar en todos los programas de Office.Probablemente no te sirva de mucho saber que Excel es una hoja de cálculo, no te preocupes, ahora te lo explicamos. Una hoja de cálculo es un programa que es capaz de trabajar con números de forma sencilla e intuitiva. Para ello se utiliza una cuadrícula donde en cada celda de la cuadrícula se pueden introducir números, letras y gráficos.Por ejemplo, para sumar una serie de números sólo tienes que introducirlos uno debajo de otro, como harías en un papel, colocarte en la celda donde irá el resultado y decirle a Excel que quieres hacer la suma de lo que tiene...
Curso de Excel 2000 (Basico-Avanzado)
2008-05-14 09:02:00 Datos TécnicosCurso de Excel 2000 (Basico-Avanzado) Spanish | Doc | José Maria Quintanilla Rivera, Daniel Santos Hernández | 74 Páginas | 5.34 MBDescripciónExcel es un programa del tipo Hoja de Cálculo que permite realizar operaciones con números organizados en una cuadrícula. Es útil para realizar desde simples sumas hasta cálculos de préstamos hipotecarios. Si no has trabajado nunca con Excel aquí puedes ver con más detalle qué es y para qué sirve una hoja de cálculo.Objetivos- Explicar la terminología básica utilizada en Microsoft Excel 2000.- Explicar el uso adecuado de las fórmulas, funciones, gráficas en el programa Microsoft Excel 2000.- Definir los pasos necesarios para la manipulación de fuente, bordes, sombreados, y demás aplicaciones de Microsoft Excel 2000- Brindar diversas opciones, y trucos para la realización de aplicaciones en el manejo de Microsoft Excel 2000.ÍndiceIntroducciónObjetivo-sUnidad 1. Elementos de ExcelUnidad 2. Empezando a trabajar con Excel.Unidad 3...
Manual de Microsoft Excel 2000 Professional (Basico-Avanzado)
2008-05-14 08:49:00 Datos TécnicosManual de Microsoft Excel 2000 Professional (Basico-Avanzado)Spanish | PDF | 215 Páginas | 2.71 MB | Full Color | Autor: DesconocidoDescripciónUna hoja de cálculo es una aplicación que permite la introducción de datos y la obtención de resultados a partir de su análisis, de forma que nos ayuden a la hora de tomar decisiones en la empresa.La posibilidad de incorporar fórmulas complejas, de representar gráficamente los datos introducidos y de realizar el análisis de qué sucedería si variamos algún parámetro de nuestro modelo, hacen de una hoja de cálculo una herramienta indispensable en entornos económicos o administrativos.Excel es una hoja de cálculo potente y sencilla. Su principal cualidad es la de incorporar elementos que permiten un análisis de los datos desde casi cualquier punto de vista sin que ello implique dificultad en su manejo.Tareas como la creación de presupuestos, cálculos de facturas, impuestos y otras más complejas, como el análisis de inventarios, aná...
Excel, Tecnicas Avanzadas
2008-05-14 08:36:00 Datos TécnicosExcel, Tecnicas AvanzadasPDF | 8.84 MB | Spanish | Editor: unam | 114 Páginas | Horntensia Cano Granados | No ISBN | 2001DescripciónLas hojas de cálculo poseen herramientas sumamente útiles que le permiten realizar tareas que van desde sumas y promedios, hasta el manejo de información como una base de datos. Esta herramienta puede ser utilizada en ámbitos tan variados como el hogar, la escuela y la oficina.El objetivo de este manual es el de cubrir temas avanzados relacionados con este programa (bases de datos), algunos de éstos son edición de gráficos, consolidación de datos, grabación de macros, hipervínculos, importación y exportación de información, además del manejo de dibujos, mapas e imágenes. Para un adecuado entendimiento, en este material se incluirán también diversos ejemplos que facilitarán la comprensión de los temas analizados.Se asume que el estudiante que consulte este material, debe poseer los conocimientos básicos respecto al manejo tanto del sistema ...
Analyzing Business Data with Excel
2008-05-12 20:26:00 Learn how to apply Excel’s advanced data analysis features to solve real-world business problems. This hands-on reference targets specific business situations, then demonstrates how to create spreadsheets for these problem areas. Topics include statistics, pivot tables, workload forecasting, modeling, queuing, data importing, and more. Perfect for professional Excel users working in an office environment. As one ...
By: The Blue Library
Resumen avanzado con datos de diferentes hojas Excel
2008-05-12 12:43:00 Muchas veces utilizamos Microsoft Excel para tener informes/datos/sumas de diferentes empresas/sedes/productos que ponemos en hojas diferentes de Excel, para finalmente necesitamos acabamos creando una hoja resumen donde poder ver la visión global de todo. Para crear un resumen utilizaremos varias funciones que ya hemos explicado anteriormente en Xperimentos: SUMAPRODUCTO, INDIRECTO y DESREF. Con estas funciones y ...
By: Xperimentos
Excel 2007 Formulas
2008-05-11 20:54:00 This book is a single reference that?s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won?t find anywhere else Bookmark to: Hide Sites
By: The Blue Library
British winners excel at Paralympic World Cup - Telegraph.co.uk
2008-05-11 14:58:00 British winners excel at Paralympic World CupTelegraph.co.uk, United- Kingdom - 3 hours agoBy Gareth A Davies Britain's swimmers showed exactly why they have been considered the dominant force in world swimming for the last decade at the ...Swimming: One last record to break for the reverend who walks on water Independentall 2 news articles
Using Excel as Database
2008-05-10 14:22:00 VBA ADO Code for using Excel as DatabaseThough many database systems have come , still there is a need to use Excel as Backend database. The reasons might be many -- you get Excel sheets as a Report and do not want to import that into Access or SQL ServerHere is a simple code that will allow you to do exactly thatSub Excel_ADO()Dim cN As ADODB.Connection '* Connection StringDim RS As ADODB.Recordset '* Record SetDim sQuery As String '* Query StringDim i1 As LongDim lMaxRow As Long '* Last Row in the SheetDim iRevCol As Integer '*Dim i3 As IntegerOn Error GoTo ADO_ERRORSet cN = New ADODB.ConnectioncN.ConnectionSt-ring = "Provider=Microsoft.Jet.OLEDB.4-.0;Data Source=D:Orginal.xls;Extended Properties=Excel 8.0;Persist Security Info=False"cN.ConnectionTimeout- = 40cN.OpenSet RS = New ADODB.RecordsetlMaxRow = ActiveSheet.Cells.SpecialCells(-xlCellTypeLastCell).RowiRevCol- = 2For i1 = 2 To lMaxRow Application.StatusBar = i1 sQuery = "Selec...
CBT Nuggets Microsoft Office Excel 2007 MCAS series
2008-05-09 16:10:00 Excel is a powerful spreadsheet tool. With the release of Excel 2007, it’s become even more powerful — with lots of new features and a dramatically changed interface. CBT Nugget?s detailed video series carefully explains this new interface and how to make the most out of Excel 2007’s updated features. Trainer Emily Berry fast-forwards you ...
By: The Blue Library
Excel Formula for Calculating eBay Listing and Final Value Fees
2008-05-06 21:03:00 Excel is very much the battle axe of the information age. White shirted warriors slog it out across the battle field of cells and pivot tables. Anyway I am getting overexcited. Here is formulas for calculating eBay final value and listing fees Listing fee =IF(D3<0.99, 0.1, IF(D3<4.99,0.15,IF(D3<1-4.99,0.25,IF(D3<29.99,0.5,- IF(D3<99.99,1.30)))))/E3 Where D3 is the eBay starting or fixed ...
Excel Invoice Template
2008-05-06 18:17:00 Click to enlarge Excel Invoice Template 1.1 Excel Invoice Template, a billing software & invoice software based on Excel, provides a Fill In The Blank invoice form and is capable of creating and calculating invoices. The template shows quantity, description, unit price, taxable status, and amount per line. Sub-total, tax and total amount ...
Excel Protect & Unprotect Multiple Sheet
2008-05-06 18:16:00 Excel Protect & Unprotect Multiple Sheet 7.0 Protect or unprotect one or many files in MS Excel files. Excel 2000 or higher required. Protect or unprotect one or many files in MS Excel files. Author Company: Sobolsoft Price: $19.82 File Size: Requirements:- Excel 2000 or higher Update Time: 2008-05-06 Rel-ease Date: 2008-05-06 OS: Windows 2003, 2000, 98, Me License: ...
Create Additional Pivot Table using Excel VBA (from Existing PivotCache)
2008-05-06 11:26:00 Macro to Create a Pivot Table from Existing Pivot Cache Many times you will have a Pivot Table created from a pivot cache and you have a requirment to create another pivot table from the same data. In such cases, instead of creating a new cache, you can use the existing pivot cache to create another pivot table. This will save a good amount of memory too. Sub Create_Pivot_Table_From_Existin-g_Cache() Dim oPC As PivotCache Dim oPT As PivotTable Dim oWS As Worksheet oWS = ActiveSheet If oWS.PivotTables.Count Then Exit Sub oPC = oWS.PivotTables(1).PivotCache oPT = oPC.CreatePivotTable(oWS.[J1],- "Pivot From Existing Cache", True) oPT.AddFields(oPT.PivotFields("-Item").Name) oPT.AddDataField(oPT.PivotField-s("Customer"), "Quantity", xlCount) End Sub Here we are checking if any Pivot Table exist in that particular sheet; if it exists we ...
Create Pivot Table using Excel VBA
2008-05-06 11:13:00 Macro to Create a Pivot Table from New Pivot Cache Sub Create_Pivot_Table_From_Cache()- Dim oPC As PivotCache Dim oPT As PivotTable Dim oWS As Worksheet oWS = ActiveSheet oPC = ActiveWorkbook.PivotCaches.Crea-te(xlDatabase, oWS.UsedRange) oPT = oPC.CreatePivotTable(oWS.[D20],- "Pivot From Cache", True) oPT.AddFields(oPT.PivotFields("-Item").Name, oPT.PivotFields("Customer").Nam-e) oPT.AddDataField(oPT.PivotField-s("Qty"), "Quantity", xlSum) End Sub PivotCache represents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object. The above example creates a pivotcache from existing data and then using the cache a pivot table is created
Creating a Command Button on Sheet using Excel VBA
2008-05-06 11:09:00 Adding an OLE Object (Command Button) to a Worksheet using Excel VBA Sub Create_Command_Button_2007() ' ' Creates a Command button and Positions it ' Written by Shasur for http://vbadud.blogspot.com Dim oOLE As OLEObject ' Add a Command Button oOLE = ActiveSheet.OLEObjects.Add(Clas-sType:="Forms.CommandButton.1",- Left:=220, Top:=40, Height:=30, Width:=120) oOLE.Interior.Color = vbRed ' Move and Size with cells oOLE.Placement = XlPlacement.xlMoveAndSize oOLE.Object.Caption = "Click Me..." End Sub Each OLEObject object represents an ActiveX control or a linked or embedded OLE object. An ActiveX control on a sheet has two names: the name of the shape that contains the control, which you can see in the Name box when you view the sheet, and the code name for the control, which you can see in the cell to the right of (Name) in the Properties window. When you first add a control to a sheet, the shape... |
|
 |
|
 |
