View Full Version : Excel Programming
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 |
31 |
32 |
33 |
34 |
35 |
36 |
37 |
38 |
39 |
40 |
[
41]
42 |
43 |
44 |
45 |
46 |
47 |
48 |
49 |
50 |
51 |
52 |
53 |
54 |
55 |
56 |
57 |
58 |
59 |
60 |
61 |
62 |
63 |
64 |
65 |
66 |
67 |
68 |
69 |
70 |
71 |
72 |
73 |
74 |
75 |
76 |
77 |
78 |
79 |
80 |
81 |
82 |
83 |
84 |
85 |
86 |
87 |
88 |
89 |
90 |
91 |
92 |
93 |
94 |
95 |
96 |
97 |
98 |
99 |
100 |
101 |
102 |
103 |
104 |
105 |
106 |
107 |
108 |
109 |
110 |
111 |
112 |
113 |
114 |
115 |
116 |
117 |
118 |
119 |
120 |
121 |
122 |
123 |
124 |
125 |
126 |
127 |
128 |
129 |
130 |
131 |
132 |
133 |
134 |
135 |
136 |
137 |
138 |
139 |
140 |
141 |
142 |
143 |
144 |
145 |
146 |
147 |
148 |
149 |
150 |
151 |
152 |
153 |
154 |
155 |
156 |
157 |
158 |
159 |
160 |
161 |
162 |
163 |
164 |
165 |
166 |
167 |
168 |
169 |
170 |
171 |
172 |
173 |
174 |
175 |
- Named Constant
- assign Drop Down selections with values
- Multiple questions
- Error Trapping on Data Entry
- Worksheet_Change - initiate macro on another worksheet
- select cells with this/that colour with macro
- web query for driving directions
- if cell text repeats, move the adjacent column to the same row
- Macro to put records of same person on same row and delete duplica
- Passing reference to a checkbox to a subroutine.
- Delete rows based on an array
- Conditional formats
- Help wCombo Box Setup
- RTD issue with Excel 2007
- Referencing an Excel Name from a different Workbook in VBA
- Finding and copying from 1 worksheet to another.
- Error 800a01a8
- Shared Workbook - "1/0/1900" displays for some users
- .Refresh BackgroundQuery:=False
- dim problem when using cell() reference
- Column Combinatorics
- Help with external drop down lists
- Getting around Protected Worksheet (number format)
- Variable headers
- Re: Please help me edit this code..Thanks in advance :-)
- How to return mulitple values based on the contents of another cel
- Re: Please help me edit this code..Thanks in advance :-)
- Email Formatting
- Urgent Help
- Export range to XML?
- Excel email attachment from outlookexpress
- Conditional formatting - based on indentation
- Copy data to next empty row in a range
- How do I add the sum of a multiplication formula to another cell
- Excel queries
- Excel application logs
- Delete specific menu item from custom menu
- Can Excel pull live information from the Web???
- copying data in a sheet to a new Word document problem
- Your favorite Excel Add-ins
- Error handler question in Worksheet_Change event
- Excel registry key
- parameter
- Parse email text
- Disable Shortcuts
- Modeless Userform
- name the sheet the same as the file name
- Custome Format Alpha
- Quick Access Toolbar
- A better way to get Min and Max date
- Minimise/Restore
- Changing case in a cell
- weekly totals
- Refer to combox from activecontrol name
- formula that once it is true info stays in new cell?
- Counting Colored Cells
- how to save in the excel some additional invisible information
- SORTING MACRO TO CLEANUP MESSY SHEET
- macro/vba
- Disappearing Personalised settings
- Create New Sheets from Filtered List - help on macro
- Rich Text Box
- Searching a Word Document from Excel
- Startup
- Free Tutorial website And Ebooks programing tutorials
- how secure is projectProperty Protection?
- Colouring cells based on day of week?
- how to have checkBox in ToolBar (Icon) ?
- Variables & strings
- Can you write the contents of an Excel Named Range to Word?
- range and visibility
- How to paste a image into a VB UserFrame in Excel?
- Help with code please !!!
- multiply text and number
- Userform driving me insane
- Vertical Line in an XY Chart at Today's Date
- MenuBar/CommandBar(s) reappearing after being disabled??
- Macro to understand how wide or long the data range is
- If source cell is bolded then destination cell becomes bolded too.
- need macro to repeat two rows at top of each page
- nothing selected in listbox, but listindex <> -1
- macro to repeat non contiguous rows at top of ea page
- How do I make a copy of a macro?
- Hide Zero Rows - But Not Blank Rows
- Behavior - Option Buttons
- Code for Copying and Pasting data to a separate Workbook
- Lop to delete rows
- Batch file rename macro
- VBA How to
- Windows API Functions
- Boost up Your Business through Data Entry Outsourcing By saving timeand money
- random number generator for scientific simulation purposes
- Enable/Disable Macro
- Excel Chart
- Copy Values based on a Match Q
- Conditional Formatting based on multiple criteria
- why do hyperlinks on userforms in excel work but not word
- Recommend: object intermediate between Application and Project
- Excel 2003 - Writing a Macro - How Do I...?
- how to insert a row at regular intervals of row
- split in vba
- Help with Design
- Question about the Queue of Commands in Undo
- Need VBA/Macro help in Excel (I think)
- Creating new worksheets and appending data from multiple worksheets.
- Days360 Formula in VBA error
- Automated e-mail from Excel
- loop through matches
- TreeView Control V - 6.0 - Drag-Drop Nodes
- Formulas
- Macros?
- macro to add leading zeroes to number and loop
- Weird Happenings
- formuls
- If row 2
- Carts and Acticesheet.Range
- All for insert of picture on Protected Sheet
- COPY...........(need a little change in a macro)
- Freeze Panes- Windows Split
- User Defined not defind
- VBA code disables Undo command
- How to enter a constant sum formula using values from 2 different
- Outlook
- Plot grand totals on secondary axis in PivotCable
- how to find whether linked data exists
- Formatting based on a condition
- VB Scrpit to input search results in Excel work book
- Excel VBA - Graph/Chart on Userform
- VBA help. Select dynamic workbooks.
- Refedit problems after installing SP3 to Office 2003
- Excel Sorting In VB
- Create Worksheets based on column data
- Excel Sorting in VB
- Date Formatting
- Screen Updating
- Programmatically creating hyperlinks
- toolbars
- Find the next Cell with interior color using Do Until...Loop
- Macro That Tests
- Create folders from excel
- UserForm to delete unwated items off sheet?
- Storing result of function directly in a variable instead of cell.
- How to Query the Database
- Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
- Duplicating Changes from Column A and B of Master Workbook to ColumnA and B of Other Workbooks - - Please help me, I can save days if my problem
- Problem with second count routine from userform
- Autoclose excel file after x minutes of inactivity
- Need window handle for a userform
- Saving date as part of filename
- Dave - Trouble finding posts
- Number of files in a folder including sub-folders
- Lookup first/last column of record
- SheetChange for formulas
- SplitRange
- Opening Excel File from value in active cell
- How to disconnect the line for Internet?
- Menu item
- Private Sub Worksheet_Change doesn't work?
- Avoiding IF limits with VBA
- On Error Resume Next not stopping pop up message
- Question with Solver code using "Application.Run"
- Need a 'Refresh' button
- Dropdown Box Conversion
- Hide Autofilter Button but keep the filter on
- Open Workbook Read Only and hide select worksheets
- Combobox list appears on far left side of screen
- VBAProject Password message appears when exiting Excel
- Macro or VBA to Bold first 3 characters of a cell in the entirecolumn
- Indirect in VBA code
- VB Function exported in XLL file
- Developing a macro that will help with mass address cleansing
- Re: Worksheet name appears in formulas?
- Formulas mysteriously break
- Organizing list of contacts in .xlsx
- Run-time error 1004 with Range
- slow scrolling
- Printing help
- Add-in security
- converting date to a monday date
- Array formulas cannot return strings longer than 255
- Import multiply csv files
- How deactivate the keyboard and mouse
- Workbook Open Procedure in Custom Template File
- pick from list and automatically enter corresponding cell
- Inputing Data
- Useing IF to Paste a Range
- Simple seach and copy help needed
- Go to Last Active Window
- Protect several objects
- Check for worksheet in closed book - Help
- Slow Office Automation
- non-functioning keystrokes
- Custom toolbar color
- Calling a Webservice from Excel.
- ADDRESS MACRO
- Problems with saving an Excel document and Macros in Excel which aredisabled with no reason
- Mulit-column number formatting
- Multi-Dimensional Array Procedures
- Compare Problem
- Bookmarks in Excel???
- function double output
- Prevent saving in Excel 2007
- Close workbook without saving file
- Excel DB Query Parameter for all values
- How do I use MS products to set up a linked product order form?
- hide check box
- Add-In UDF returning #NAME error
- move item from one listbox to another listbox
- Function - array with 2 variants
- Protect a Worksheet
- Accessing ranges within sheets
- Change Upper Case to Proper Case
- IRR Calculation question
- check boxes
- Macro for expanding a range
- Combo boxes in userform auto drop down problem
- executions per second
- Colorindex 2 not formatting
- split the contents of a cell
- entering a validated value into a cell
- Name Sheet with Input Box and text
- Duplicating changes from master file from all sheets within a file.
- macro for appointment
- Check If Form Open or Not
- simple IF statement
- Issue with listbox not showing the last value in the range
- Microsoft Office Document Imaging - Automation
- Cell Address References won't update when Sorting
- VBA freezes after opening file
- Add-in is visible
- Embed VBA in worksheet
- Excel VB
- performance
- Sheet Selection
- Clearing a Cell Value
- Access from Excel
- WebData Substitute
- Template Wizard w/Data Tracking
- Extending a range
- Multipage Control in a Userform
- Multiple Count Condition
- SaveWorkbookAsToday()
- Using VBA to change Pivot Table data source
- Different approach? Re: Fill color based on RGB (PeterT?)
- Value of Cell changes in each step, i want to record the previous.
- Evalulate previous cell
- Are there any events for outlines functionalities?
- Bolding using VBA
- RE: Exported file not the same on different PCs
- Combo Box Row source problem
- Are the "page setup" layout settings overwritten by page preview adjustments ?
- How to delete all stuff outside marked cells ?
- Do Until?
- Research Analysis (3rd time)
- Extract embedded objects in worksheet to HD
- Conditional Formatting vb code
- Test for Decimal
- Displaying Members in Visual Basic
- .NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
- .Find cell within rng when font color=3
- For Each code
- Excel 2002 and 2000 crash with Combobox on worksheet
- Excel 2007 - Macro Shortcut Key Doesn't Work
- Delete temp file
- using BrowseForFolder shell application
- msoControlButtonDropdown
- Trouble populating ComboBox from a range
- Delete hyperlink from textbox
- User Provided Path - Compare 2 Books
- SQL Select string
- How to programmatically digitally sign code
- Sheets and Worksheets
- Determine whether the user has saved the file?
- How to get the correct active Cell position in Worksheet_Change
- Conditional Formating
- Copying tabs from one spreadsheet to an other
- Microsoft Calendar Control 11.0
- read and grab data from database
- conditional formatting on click
- RE: Reading office properties - dsofile.dll
- switching window stops running macros
- "run-time error '1004' - select method of range failed"
- COMException raised on opening excel file in thread
- address of activecell in another sheet
- Hide Command button - still use it
- Pop-Up Calendar
- WTC Towers: The Case For Controlled Demolition
- formula behind field on user form
- How do I create buttons to link worksheets within a workbook?
- Fill down formula if other column contains data
- populate output form programmatically
- If Sheet Exists Q
- linkedcell with togglebuttons problem
- Extracting text before ~ sign
- Compilation error in hidden module
- How can I set focus back or remained on Textbox?
- set variable while looping question
- Macro to build code
- Research analysis.
- Hockey Statistics
- Populate Sheet based on ComboBox selection
- Useing If to Delete a Range
- Suppress Mouse Hourglass
- Troube defining variable
- Referencing a Sheet based on the Month
- Do Until empty loop
- Error on Set Rng statement?
- Using Array's
- Combobox
- Macro for Pivot Table
- Paste To Visible Cells Macro
- Select Case
- Find value in a 2nd workbook
- Importing CSV Finding Min/Max
- IF, Case, or something else
- Populate List or Combo box based on User ID
- Populate List or Combo box based on User ID
- rename a copied sheet
- Grab Open Outlook Username from Excel
- Tweak to code that checks colors of fonts and moves to proper shee
- VBA in Excel
- "Help Checking Out Macro"
- Need to find all 9-digit numbers
- Automate IE Web Query
- Array Formulas
- Need help with a randomization problem in Excel using PopTools
- Transfer Data from Input Form - Offset to different worksheet
- Fill color based on RGB
- excel sheet to outlook
- My buttons shrink!
- Custom Sort Order
- PLEASE HELP: Enable Automatic Refresh
- Select rows in a date range
- Copy links from one spreadsheet to the other
- What does the WebPubli****em ID Value Represent in a Sheet's XML F
- Submenus on Shortcut Menus
- Macro to check for file update
- Email downloads into a single Excel cell - data separation reqd.
- Compile error in hidden module: "Module Name"
- Conditional Selection VBA code
- Macro Hidden - Cannot "Edit" to see code
- Populating a userform with a Word document (read only)
- combobox
- Copy Named Range from one sheet to another with formatting
- coding for macro
- Sort cell values of different columns
- 2003 -> 2000 incompatability
- extracting data from sharepoint
- adding date from user form with calendar to next row
- Advice for generating excel spreadsheet through asp.net preferablywith excel 2007
- RE: Input Custom Header on Print
- Input box with a loop
- Renaming sheets
- Evaluate a Name in Non-active WB
- list of used shortcut keys
- Listbox problem
- Buttons appear to stay "pressed"
- interaction with excel and ms SQL (retrieval of records from sql intoa sheet)
- handle error in cell values
- Code exected at "Workbook Open" slowing/stopping file from opening
- Returning Cell Reference/link
- sumproduct
- Unexplained read-only from a batch file
- Change Row Color using VBA
- Numbers stored as text
- Loop macro error
- Can a custom Search function return a cell reference?
- Looping through list of workbooks to open & sheets to move
- Outlook and excel
- Comparing cells, coloring differences
- runtime error 13 - type mismatch error in Excel 97 on Citrix
- How to grab a reference into VB
- Worksheet Labels as Combo Box Selections
- chart from pivot data, and sheet data?
- Time Difference in VBA Macro
- Search column for string and write to cell
- .NET Win Forms Application to Excel 2002, Excel 2003, and Excel 20
- Why my procedure will re execute at a certain point in the procedu
- VLookup & SUMIf
- Use AutoFilter
- Return Max Value of given Variables
- Setting up capitalization after hyphens
- Predefined Print area based on variable
- Word doc in listbox
- Dropdown list
- saving a worksheet as a .txt file with filename of specified cell
- Need to lock data based on '=today()' value
- Return Filename
- Timestamping
- VBA or Validation?
- Error: Exception from HRESULT: 0x800A03EC
- I want Excel to determine the correct directory.
- Indirect Lists and Dynamic Ranges
- Automating "paste Link" fuction using VBA
- Analysis Toolpak VBA module documentation?
- Read directory code which needs to include file size
- Creating a custom function to interpret another custom engine func
- keep cell reference
- Copying the first row of wbooks with ADO
- Re: How to read workbook (not worksheet) properties with OLEDB
- Accessing New Menu code
- Download Automation
- Making a Macro that will run a script at the end
- Conflicting VBA's
- A good use for an Object Stack?
- Writing cells using Range() slows down with successive writes
- Quotes around text in Msgbox
- Macros
- How to sort a column based on two other columns which are differentplaces?
- If statement / Command Button / Message Box
- SUMIF in VBA
- Last Save Time, Function not updating in cell
- copy data input to archive
- Does custom document property exist
- Sheets.Select
- Inserting Control Toolbox text field in Print function
- .Delete speed
- Looping through columns
- .NET in Excel 2003
- Using Conditional Formatting with Drop Down Menus
- I need some calculations done in a message text string ...
- Pivot table Field Setting Number Format
- Formatting cells from a value in a Listbox
- Macro hangs when run from a command button
- changing math operations for math operations with = sign
- Why doesnt this work
- Slow Program
- RE: help needed - named ranges and pivot tables
- RE: Hide Sheet
- Re : Excel Worksheet_Calculate() & Worksheet_Change()
- Running Sybase Queries directly from Excel (using Visual Basic)`
- Data Connection from Excel to Access
- 60 günlük deneme anahtarı
- How to load a list of web links into specific worksheets?
- Web query
- Pulling file names & path from folder and putting them in cells
- Strange problem with spreadsheet
- Can anyone help me with Scrollbars please?
- Cell color = Button face color. Possible?
- Macro to F2, F9, then cut and paste
- 2007 Macro's Painfully slow
- VBA crashes by itself
- Update sheets & cycle
- column loop
- Hyperlink - Data Validation
- Hyperlinks imported into Excel
- Keep Awake Nudge
- Look up file by date/time stamp.
- Files SAVE AS
- Macro for returning to the previously selected cell
- count function question
- Create URL from excel for use in IE, favorites folder
- oracle tables
- simple nested loop question
- CPearsons import text code
- 提取另一工作表整行内容
- IMAGE CONTOL AND PICTURE SIZE PROBLEM.
- Should be easy but!!!!!
- Userform Title Bar
- Freeze Pane Line
- Title Bar Hide
- Call UserForm procedures from another workbook
- Mouse Scroll in Textbox
- Link to file in subdirectory
- creating a command button
- How to program to insert / delete any worksheet?
- XL2007, Selection.Delete deletes more than the selection
- Printing Embedded Text Box
- Excel VBA vs Time fields
- Merge data from one sheet to another
- Excel 2003 code to use instead of ChartObjects
- Data Validation List Problem
- Delete multiple pictures on top of a range?
- Excel 2003 Macro to add text to front of data in cell
- Displaying word/RTF files on a Userform
- Array Formula - Offset Result Problem
- Cut - Insert without .Select
- Clipboard manipulation
- DAO on protected workbooks... come on guys
- Spliting Numbers from a Text string
- Pivot Table Shortcut
- Combo Box linking
- Determining number of Ranges
- Re: autosaving - message box
- Conditional formatting a range
- RE: Password required to select value
- Re: decimals and oracle
- worksheet_calculate
- Optimization challenge
- Re: save as .xls (97-03 format) with code
- Hide yesterday sheet.
- Data Validation and Formula
- Re: Scrolling Charts with scrollbar
- Re: Scrolling Charts with scrollbar
- PRINT THE HYPERLINKED FILE
- RE: Start Excel file on remote server
- Re: Highlighting part of a cell contents in Excel 2003
- Need your help on excel 2007
- How to copy a graph from excel to userform picture?
- RE: Placing data in specific rows.
- Recreating the DateSerial()/Date() function
- Application.Calculation = xlCalculationAutomatic
- ExecuteExel4 Macro parameters..
- InSTR Compare erorr
- Text to Columns Code
- activecell.offset question
- Re: Set XL range into Wrod bookmark as a table?
- RE: save as .xls (97-03 format) with code
- RE: Multiple Monitors Resolution & Userform
- RE: Tool:Options
- Closing a modeless dialog via "esc" key
- RE: Highlighting part of a cell contents in Excel 2003
- Re: runtime 9 error
- RE: pivot table showing text
- using DAO on a password protected workbook
- Counting Instances
- Background Batch Processing
- How to read workbook (not worksheet) properties with OLEDB
- Re: VBA to reference one cell in a range of one or more cells
- Problem with AppActivate ("Microsoft Excel")
- Number formatting with VBA - Problem when used in different Country.
- Delete rows if particular cell empty
- Looping A Variable Used Within An Object Name
- Cut data in 2nd row and paste in the end of 1st row
- Sorting a string array
- Convert code name
- Fill down for all the cells
- Menu Item
- return sheets code name
- menu bar and error 91
- Hide rows outside a known range of rows
- Weighted Average with multiple conditions
- Insert row macro
- selection for output
- How to loop through cells in a column?
- macro
- multi cells selected
- Calculate Angle and Length in Triangle
- Reading an external text file
- Where do the header columns come from in a form?
- Expand and Collapse groups
- Conditional formatting crashes macro
- Main page Recalculations
- Excel 2007 Add-in with VSTO
- VB.NET 2005: Open an Excel Spreadsheet, modify it and then save it
- Using Office Web Services Toolkit to access a WCF service
- Summing values on a Page change event?
- Clear Contents of multiple continuous ranges
- variance-covariance matrix (w/o data analysis kit)
- How to insert a picture's address as hyperlink to a cell?
- creating invoices
- Using Excel for Billing
- Userform confirmation page
- VBA Cell Selection via input box
- Sub Workbook_Open and BeforeClose not working
- macro to delete hidden or unused rows
- start an external application on workbook open
- Rick Rothstein
- Summary based on channel & date ranges
- Outlook reminder
- How to change the text of descriptions for excel open documents on atask bar
- Problems with Selection
- Text to columns
- Database import
- declare multiple variables
- Refresh Cells Based on Macros
- time selection
- Checking to see of a folder exists
- Show count down during operation
- Conditional Formatting Help!
- Macro program to delete rows if its 2nd colomn start with 'F'
- Replace existing custom toolbar with an updated version
- Perfect Macro Combinations
- selecting cells
- What is the advantage of creating this Class.
- Help needed with code
- drop downs in excel
- Searching/Retrieving Data from another Workbook
- png images files as a button image?
- Not so Random Numbers
- default mailbox and moving attachments
- 100ths of a second
- don’t see the Controls on the Forms generated at runtime
- Determine if item is in a range of items
- User Form Show
- Add a comment on cell content change with VBA
- How to call user defined function (UDF) from custom menu in Excel2003?
- Worksheet Protection
- RE: Mouse Scroll event in listbox kills Excel
- Setting DTPicker to a null value
- listview in multitab
- disable shape resizing or moving
- easiest way to convert a number to hours
- code of "send this sheet"
- 提取另一工作表行内容
- Import Picture from camera
- return formula in cell as string
- access the call stack?
- Inserting picture from Camera
- Need to prevent call Sub Worksheet_Activate() during macro.
- Error transporting excel 2007 macro to excel 2003.
- The directory property cannot be found in the cache 8000500d
- How to modify a range in a function?
- reading excel
- VBA IDE Extensions
- How do I copy and paste a powerpoint slide from excel using vba co
- insert rows based on a cell's value (macro)
- Copy worksheet to a file in another directory
- Cell J1 to reflect activecell Row a2:a500
- Finding your post.
- compare all matches
- How to find row with more than 255 characters in a cell
- Error 1004 help needed
- setting the gradientstops of a point in a macro
- Nulls vs. blanks?
- Auto Correcting and Auto Filling Cells
- want J1 to reflect the value of a:2:a500 as the cursor enters the
- Label Position - Above & Below
- highest sheet name
- want cell J1 to reflect the location of acitivecell.value
- Excel writing on explorer's window
- Prevent print setup changes
- Making a custom toolbar available to others
- Assigning a constant to a range name
- copy rows from one worksheet to another using macros
- Matching Colums & Rows in Different Spreadsheets
- Update Links
- for...next including if function and or function
- String separated with commas
- Extracting Nested PivotItems
- Find formatting in text in cell, insert tags around formatting.
- Macro Question
- Run macro until range ends
- reoganizing data that has been scanned into excel
- Conditional Formatting
- add sheet values
- Chinese Characters and VBA
- VBA to SUM a row of numbers
- Validation subroutine for textboxes
- sheet name
- enabling & disabling attached toolbar stops sheet selection
- Simplify long process
- Turning a large spreadsheet into a room by room list
- userform query
- Change Background Color on PivotTable subtotal row
- Range error
- finding error in range
- userform macro to recognise non-blank cell
- determining dynamic print area
- VB script modification (continued from yesterday)
- How do I clear Print Preview?
- vlookup question
- RegExp
- comparing values
- 2007 - Add-Ins tab
- newbie to ClModules is this correct use of Property Set?.....
- Runtime error 1004 on an application.count statement
- Simple VBA range loop?
- Copying columns
- create zip files
- Pivot Chart Dropdown Question
- Specific range formating
- location of userform to activecell topleft....
- Create Userform Objects
- clear button
- Digital cameras, mobile, LCD TV, Laptops, Notebooks, Digital Video,Mp3, Mp4, GPS for you!
- Same Items in 3 different Combo Boxes
- Listbox 01 --> 50 in UserForm
- Highlght rows
- product of two cells
- product of two cells
- Userform Calendar - Current Date
- almost have it... need help with last bit of it.
- view one worksheet from within another workbook
- Worksheet_Change Event Strange Behaviour
- Convert xls to pdf and bookmarks
- Range Printing
- Variable Subtotal range
- Remove from listbox
- Closing a program which was opened with shellexecute
- Excel Web Service - Multiple Pivot Charts - How to Have One commonFilter
- UDF for extracting hour from Date string
- Run time error '438'. Object doesn't support this property or meth
- Numbering Function
- picture is too large and will be truncated BUT
- Excel 2007 vba - Refresh after web query?
- Determining Cell within Range
- Disable screensavers from Excel
- Huge database of profiles with photos for all 30+ local singles.
- Pass Variable to another Sub
- code won't loop
- Passing arrays from Excel (VBA) to C# uisng COM interop
- How do I add to Auto_Open Macro keystroke Ctrl & F1 ?
- cell validation on protected sheets
- Help needed with Excel VBA sort
- SpecialCells in UDF
- Distribute Addin
- Searching from Excel
- How to scale image to fit inside a merged cell?
- Find rows with a common item and find or highlight difference
- Is there a way to Calculate with a VBA?
- Show Excel comment on mouseover but not the comment indicator
- Inserting a named range while recording a macro
- Dropdown in cell base on a selection of a different drop down
- Cell Change Event
- Need help modifying VB script
- vba 2007
- Visual Basic 6.5 in Excel
- Sort
- VBA for Smartphones / Windows Mobile 6?
- Locking Excel rows using C#
- ending zero
- save button
- Request for Help in Developing a Macro for a Billing Application
- Array help
- Save workbook and delete old workbook
- How to print line/row numbers as well ?
- Loop Macro
- Sign In Button
- Pivot Table: group dates by filing period
- Add a VBA Module from a String instead of from a file
- Variables being randomly destroyed
- Excel 2007 .AddPicture: Can it use a URL as a source?
- User Defined Function
- Compare columns in two WBks and when match is found...
- QUERY EXCEL TABLE DATA
- really weird behavior, chart with textbox font size problem
- Activating Outlook files and importing data from within Excel
- UDF to evaluate if row is hidden?
- How to disable and enable multipage elements during runtime?
- How to access all the textboxes inside a frame?
- How to refer to the .text property without text box name?
- Faastest way to find last previous entry?
- Load XLB file with worksheet?
- Automatic macro on sheet
- Invoking another Application from excelvba
- Data validation list in accending order
- Conditional Formatting in 2007
- updating userform
- "Mopy"
- Select and delete entire row Excel VBA macro
- Prevent Comment deletion
- Floating Information
- Bookmarks from VB to Acrobat 7.0
- checkbox backstyle
- Charting Problem
- XL2002 - Application Resize Event...
- Protecting a Worksheet Question
- replace only 8 cells of a row from next raw if one cell has value of45g
- A formula or macro that will place the date in an adjacent column Bany time something is typed in column A
- VB Code to hide and unhide rows
- copy csv worksheet to xls book using vba/vbs
- 2008 Australian Excel Conference - March 12 - March 14, Sydney, Australia
- How to export chart to a network drive?
- Problem with query against CSV file using ADO
- Insert a quote mark, then repeat
- Start a Macro when a file exists
- Excel
- Excel to text file
- Using Query in Excel
- Equipment loading using Excel graph
- Copy formula down up to last row
- Searching fro A file and returming the pathe to that file
- getting current procedure name
- Edit Cells while Macro is Paused at Message Box
- Multiple Sheets to one sheet
- Selecting a worksheet without making it active
- userforms starts crashing and getting "unstable"
- Protect workbook
- how do you save a form created with the data form wizard
- Calling Function in Add-in
- copy a formula down up to blank cells from other sheet
- Auto Macro and Locked PC
- path error when pointing/going to userform1
- office 2007 custom toolbars
- new custom menu
- UserForm ListBox problem
- Parameters in Forms Buttons - not working in Excel 2002
- vlookup or match function across worksheets (x-post - sorry)
- Worksheet_Change and Copy
- Copy data from large worksheet into multiple workbooks
- Moving data from Excel into an Infopath Template
- Efficiency re: Module Sequence in a Project feb08
- Extract Outlook Contacts to Combo Box in Worksheet
- Web Scraping With Loops
- SaveAs to different filesystem causes unreadable content
- pasting a link
- Help & Advise with code Please...
- Help & Advise with code Please...
- change date from 020315 to 03/15/02
- counting checkboxes
- Automatic Moving
- vb project data exported to excel
- ActiveCell.Value just disappears .... ?
- Run Time Error 438
- Check for font
- Setting width in pixel in Excel
- MACRO CODE
- Please Help - Trying to Launch IE from Excel
- create named worksheet based on existing numeration
- Deleting a range after selecting a sheet
- CODE FOR SHEET MODULE
- Copying workbook to main workbook
- How to make combobox non-editable?
- VB code to run multiple macro
- Object problem
- Check To see if file is open
- comboBoxes on a userform
- SumIf Function Question
- Macro to delete rows if they don't begin with "0"
- Preserve Option Buttun Selection
- MACRO TO ADJUST COLOUMN WIDTH BY VALUE
- Runtime error 57121
- Creating a view of another workbook
- I need to help with Excel (beginner) -- year row and month column
- Problem with ComboBoxes
- Excel users! Do-It-Yourself Dashboards, Reports, Guided Analytics and Business Presentations!
- Cancel on Worksheet_Change
- Error on opening Excel 2007(.xlsx) on office 2003 machine.
- Disabling Compatability Checker in Automation
- How to Insert Subttoals after the Excel File has Created
- OnAction callback is not invoked using hotkeys
- Combobox width not showing full data
- worksheet change problem
- Re: Is this macro scenario possible using VBA?
- How to disable activex controls & code on saving a new workbook.XL2003
- Transferring a Date array to a range
- How can I transfer an MSFLEXGRID picture to a worksheet?
- Calendar Control
- Scroll bar not appearing in text box
- A basic Macro: going to a particular Worksheet and then selecting thefirst blank cell in column A
- Save As macro
- How to Set an Option Button
- Time if/then caclculate average formula?
- deleting negative numbers
- workbook used to open but now crash with File/path error
- disabling message
- Hiding the Row and Column designation bars?
- Set Zoom Level in Auto-Open Macro?
- worksheet change
- Excel 2007 Macro Record
- Place an autoshape
- Newb VBA question
- Create CSV file based on table in Excel file
- VBA and Excel 2007
- Closing Workbook then Activating Other Wb with Userform showing?
- Alphabetizing Worksheets
- Editing text in cell
- This code does not work
- Finding a worksheet
- How do I add text box styles to a worksheet?
- Re: retreive Access via ADO
- Sort Worksheets
- replace cell with formula
- Help on VBA and Excel
- how to call a dll that requires parameters...
- ADO to get Worksheet Name
- Excel Progress Bar problem
- Maximise My Excel Window on startup?
- Lookup between list of Mins & Maxs
- NMEA input
- Networkdays code error
- Turn on secondary axis
- Macro and Copy and pasting special
- Selecting a small range of cells to delete
- Horiztonal page breaks and Margins feb08
- Inconsistent Printing of Spreadsheets
- organigram/diagram in Xls
- application worksheetfunctions fail
- store variables
- Problem renaming worksheet
- List all Computers in Workgroup
- On Change code
- Disable Calculation of selected worksheets toggle
- Deleting code comments from modules
- Need code for fill a number trend down
- Re: Error 76 in file download code
- "Open Browser Window And Select A File"
- How you do rename a module?
- Copying Data in excel
- Select a PivotField range without using the range object
- Textbox - Shape
- Run another macro from within this macro
- Copying data between workbooks
- User Form creating shadow images when moved?
- Range names starting with underscores?
- Adding and Graying MAXIMIZE button on vba E2007 form system menu
- Paste Link
- "Damage to the file was so extensive that repairs were not possible"
- Excel Template
- Adding/Removing Rows to Referenced Ranged in Worksheet
- New toolbar in Excel 2007?
- add comment in the loop
- Update worksheets
- Selecting a range of a Find object
- Selecting a range of a Find object
- Create copy of multiple worksheets and automatically fill in datafrom a main sheet
- need breakpoint to stop code
- Email with Outlook Express Problem
- VBA code mysteriously stops running
- Count unique values in Pivot table using VBA
- TAB BUTTON - VBA TO SKIP CELLS
- VBA Macro Required for Insert Row . . .
- Broken: Set Cells in Range to 0 if blank
- Re: Search all Macros for Specific Construction
- Macro for filtering
- Re: External query - No columns
- Display something on first open only.
- Delete rows if data changes in particular column
- Importing ASCII text into worksheet
- PLEASE help ...
- how to understand the three names relative to one worksheet
- Excel 2007 AddPicture help needed
- Editing text
- How do I link to and import specific data from other workbook.
- Update Textbox1 after combox easy help for beginner! Opzioni
- protect sheet using vba
- count 1st cell and last cell that contain specific word
- Shortcut Keys
- macro copy data from one file to another?
- Copy and paste
- Cancel Click on label control
- Macro to create sequence of numbers
- Re: External query - No columns
- Simple macro
- Pasting HTML table into excel - Problem
- Doubleclick
- Problem renaming command buttons with code
- HOW TO HOST / SHARE WORKBOOK ONLINE ?
- Using a string as a formula (for an array)
- Embedded word object
- Remove Autofilter
- Combo box
- Differences using worksheet functions in worksheet and via VBA
- Determining if a cell has an external reference ...
- Refresh Query on open failing
- how to I import word form fields in excel
- Add-In: Functions and Category
- Debra Dalgleish's clearing old items from Pivot Table dropdowns
- Code to add a workbook the rename it
- How do I create a new slide in PowerPoint from Excel using VBA?
- radio buttons independent for each row
- No Duplicates Allowed
- VSTO - Programatically building an org chart
- Find a Named Range programatically using VBA in Excel
- hiding worksheets programmatically
- Re: pulling properties
- Change the color of a cell when I type a certain word.
- Deleting duplicates
- MSXML5 and Excel 2003
- Sorting by cell color in Excel 2003
- another "to prevent possible loss of data, Microsoft Excel cannotshift nonblank cells off the worksheet."
- In Excel visual basic - Need an "auto adjusting" fill down macro
- UserForm Initialization
- refedit controls and Excel 2003 sp3
- UserForm Initialization
- UserForm questions about text box propertys, thanks
- Help with code needed
- RE: Validating two lists.
- Re: SUMPRODUCT HELP
- Re: Application.FileDialog(msoFileDialogSaveAs)
- Re: pulling properties
- RE: VBA for Skipping Cells
- Validating two lists.
- macro to refresh data
- VBA for Skipping Cells
- RE: ParamArray values not being passed, Feb08
- empty range
- Sort Errors
- Changing Contents of a cell.
- Macro to change date cell by specified interval
- Calendar Control in UserForm
- Using cell values in SQL (MS Query)
- Incremental search to find worksheets
- Validation lists that change based on a selection from another lis
- Custom Function Problems when multiple workbooks are open
- ChartObjects problem - can you check if a ChartObject is"full/contains data"?
- Setting Range in VBA - partial repost
- Radio Control Confirm problem
- Problems with Custom Functions and Muiltiple open workbooks
- Autofilter Question
- Using Autofilter within a macro
- Data Validation starts change event
- SumIf Function Questions
- Copy from one sheet paste to another
- Two way lookup
- Re: vba addin to copy a workbook
- List of all open Shared file names
- =DATE() function in VBA?
- Why calculated cell's value not updated when I change cell valueusing ado.net?
- import multiple files
- listbox multiple selections
- Printing all the charts
- Sorting data in Excel
- stop VBA
- UserForm Tab Name Change
- Using xl MID function through VB.
- copy paste
- Summary of list with multi length numbers
- Pivot table with start and end date selection option.
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.