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 |
- add up and calculate textboxes into a label
- error message
- Software for Distribution of XLAs
- Writing Workbook_BeforeSave into workbooks from an XLA
- Command Button Color For Next Loop
- Daily and Monthly Average Macro
- Excel VBA error
- newbe VB application in Excel
- Macro Compiles Sheets to One Book...Small Modification Needed
- SetFocus not working
- Cell name
- Here is a tough one!
- Macro Help
- Paste ranges with offset Excel 2000
- help with a do while loop
- Using a macro to copy certain cells
- Mass Email
- vba excel fileopen
- Order in which add-ins run
- Is this difficult???
- loop with array
- Using a cell reference to select a worksheet within a macro
- Fastest load of new Excel instance
- some code help please
- Excel 2003 & add-in programming
- converting excel to xml
- row location
- Replacing an Error
- sort issue
- identify text type: is it a phone nuber?
- Sum Unique Values Across SpecialCellType Visible Range.
- Populate a ListBox
- Userform
- Signatures
- Please help with passing values
- OT - Collaboratons
- Weekday in English when using foreign version of excel
- Prevent deletion Comments
- Loading sheet names in Combobox
- Re: Pasting date in a range
- Code bombs at line indicated, why?
- Stop Macros from Running When Workbook Opened via Automation
- Can't make this VB work plz assist :p
- Pasting date in a range
- RangeFromPoints
- Timing loop help please
- Help please?
- Searching for locked/unlocked cells
- Forcing an OnKey
- Need Macro for Extracting Unique Name from a Sheet
- Problem: populating listbox items
- Text madness, Spinbox and Textbox?
- Go to an Access form
- can excel webpage link in a website be edited at user end
- [ann] chexcel -- embedding C/C++ interpreter ch into excel released
- loading a form
- Info. in a function
- Book on Class Module
- Completely getting rid of unused macros in XL?
- Posting code with IF
- Save As Text file
- Implant macro coding into ASP coding
- Free-standing macros
- cell reference using macro
- VBA VLOOKUP
- The myworkbook.xls Auto_Open() macro won't run if started by a VBS
- Loop & add number list
- Linkage data between two spreadsheets
- supressing system warning messages
- excel macro to move minus sign
- Userform: listbox and controls' data entry validation
- Open an Excel Workbook from either a BAT (or VBS) without pausing.
- Why Won't This Code Work????
- Macro Help
- VB Macro writing a formula to a cell
- Charts.Add - Run-time error 1004 pls help
- dynamic "this week" macro
- excel linked to access
- Is there a VBA Event to Detect Change in ActiveCell Focus?
- Converting xla to xl COM add-in
- Reverse Userform
- Excel Icon Programming
- Macro: Copying Formula Help
- Deleting Personal.xls macro
- Correct VBA syntax for cell function formula
- InputBox - search for value and jump to cell
- get the parent folder of the working folder
- Refer to a different Worksheet regardless of which Worksheet I'm i
- not urgent
- Efficient way to copy a range in numerous sheets within a workbook
- excel macro to move minus sign
- Select Row of Active Cell
- need help with formula
- Macro to Merge and Sum Rows
- Macros Don't work anymore
- Hide and unhide columns
- Changing cell color
- problem with a named list
- input current time
- VB Code Works Perfect...but Not when the File is Shared
- Pull Cells From Sheets
- Collection Issue
- RE: IF formula problem
- Macro - Need location of XLS itself to be set as default
- VBA to zip excel spreadsheet using xp's compression system
- Shape Selection Name
- need help with macro modification please
- Displaying mail with Excel
- mixing absolute and relative references
- A variable that save its value
- Macro Help
- User entry correction
- Save filename as new file name
- Make table query works intermittently
- Code running order
- help with sumproduct function
- Syntax of VBA Code
- Clipboard clear
- Hide an entire row - Not working
- Formula to rank / lookup from list
- excel error? - second post
- look up for values in the cells
- InputMask for Textbox in UserForm
- showing userform with excel minimized
- Edit multiple workbooks
- Help With a Looping Task
- Compare values in 2 worksheets
- Automating XL charts from VB.NET 2003
- get selected row number
- Toggle AutoCalc
- Wondering if....
- Help With a Looping Task
- Password removal
- For Each offset range
- Array of files
- Grouping Sequential Numbers
- Capturing Decimal Values in Variable - Losing decimals when summin
- Separate multiple entries in cell to individual cells
- Scrollbars on a Userform
- Goto Button
- Visual basic 400 error in IDE???
- UpdateLink giving error 1004
- Deleting Sheets Warning
- Make Table Query into Text File
- countif
- Close a message box
- Consolidation Problem
- Lining up data from two sheets
- Macro
- Assign macro
- Renaming Zip files
- Determine last row before end of page on worksheet
- Extract Row if data exists
- Vlookup syntax
- When to kill an object
- Macro Help
- Open an existing Dropdown
- Shell Function - Syntax
- ComboBox
- Zoom - VBA Code
- fault message
- Exporting from Outlook Tasks to excel
- File lists
- combobox querie
- Retrieving VLookup Values
- Dealing with data in rows and columns
- Cell position / pass values
- Insert binary image file to Excel
- worksheet image control appearance change (and back) with mousemov
- Excel as a web based shipping calculator?
- Importing text file to array?
- change the data label of an chart to show qty
- Calculations in VBA
- Recognize text in message box by "Net send"
- VBA Macro
- select listbox item automatically
- HTML Code cleaner
- (Leo) preventing MDI file to be opened
- Excel Macro to take user back to page 1 before saving
- not allowing a file to open if macro's are disabled!?
- Populate fields From excel file to Web form/objects
- list related files, select which to open form
- Not a valid add-in file???
- Disable the Close Window button of the worksheet
- change data validation
- Retain Variant / String value
- Need small help with excel macro please
- Auto Size Wrapped/Merged Cells
- Fix format to text not number
- Re: converting dates to numbers and numbers to dates
- Passing the value of listbox to other Subs
- Office 12 new GUI
- Showing the total in a ColumnStacked chart
- Icon Programming
- InStr Function Question
- register any "mscal.ocx" using vba
- Error Routine
- Changin values in another cell
- Excel-97 SR-1 calculation=automatic iterations Workbook_Open
- Fill in a form
- How can I......
- Intermittent missing reference problem
- Repost: Speed of inserting pictures and Excel memory
- Re: Strange VBA speed issue based on whether overwritten file originally existed or not (?I think?). Excel from Access VBA
- Lookups using 2 workbooks
- Tools | References file type
- If...then structures
- functions that don't function
- Macro not performing
- Identifying version of Adobe Reader
- close without saving automatically
- Range Variable ?
- solving inside macros
- To Chip Pearsons
- Copying Protected Worksheet
- How do I create a macro to put "-" between existing numbers?
- RE: Range Variable ?
- look up for values in the cells
- text
- How to identify variable workbooks in an excel Addin
- Incremental Numbering: Compile Error - Variable not defined
- VBA code to create "variable" worksheets within a workbook
- how do I share a priavte key with other computers?
- RE: Range Variable ?
- matching duplicates then looking up corresponding amounts
- How to pivot and display 'text' in the data section, no Counts!
- combobox update
- RE: Range Variable ?
- automate data transfer from hyperterminal to excel
- How to program on check box
- Need
- method range failed
- Help with populating a text-box with a pull-down box
- Mouse Control
- ot check out a screenshot of excel 12
- Identifying a cell that has changed
- Extract and Transpose
- open folder statement?
- combobox rowsource as code
- 311983 to 19830101 (YYYYMMDD)
- How to macro simple graphs
- Conditional Compilation Based On Excel Version
- how to add a formula at the bottom of a pivot table?
- look up for values in the cells
- Loop question
- VLOOKUP From Another Worksheet???
- create a button and assign a macro
- Excel Locks up at end of Sub
- how do i prohibit user's from accessing formulas (lock the formula
- Listbox
- macro {r 1} command in lotus
- Macro giving runtime error on one PC and not another
- working with 2 different worksheets, how can I verify the data
- RE: Macro giving runtime error on one PC and not another
- look up for values in the cells
- suppressing passwords to edit linked files
- Explorer Hangs on "Reply"
- width of Merged cells within un merged cells
- Cracking Passwords
- multiple worksheet data into 1 worksheet
- VeryHidden
- Intersect, Union... where's Deduct?
- what's wrong with this paste line??
- Problem with OpenText in Excel 2000 (date format)
- Applying Macro to only certain sheets
- simple loop question
- Quick question on multitasking
- Excel loop to delete redudent rows
- Creating Name for a Command Button
- How can I auto-center checkboxes in cells
- Formula Help Needed
- Macro to combine data based on IF,THENs?
- Complex Userform - Step by Step
- How do I hide a row or column with a macro
- Selecting proper week
- Macro
- how to insert and color these rows
- Macro for Ctrl-P to print
- Auto Sort Columns on Workbook Open
- Help with this error Unknown reason for error with Range().Select
- How to add right-click menu in excel.
- how to insert and color these rows
- Re: Error on ExecuteExcel4Macro Page.Setup
- Macro runs in source , but not when in Personal Macro Workbook
- Excel 2003 operates differently on FILE SAVE AS?
- autofill with dynamic lists
- Truble Attaching PDF Files
- How can I rewrite this using an Array?
- page break preview and form button
- Add Excel data to Access
- Permutations, Array, For...Next, etc.
- WebBrowser1??
- Re: Strange VBA speed issue based on whether overwritten file originallyexisted or not (?I think?). Excel from Access VBA
- Code not working
- Simple loop?
- Unable to Unhide Personal Macro workbook
- List of all User Defined Functions
- Quick Start to working with checkboxes etc within a worksheet
- Excel Won't Open Lotus Files
- Manipulating text of an equation
- Fetching user-defined fields from Outlook
- VBA to change VBA
- Chart question
- (1) VARIABLE IN POSTING CODE (2) LOOPING
- Changes in Excel file by *.VBS script without Excel installed
- Changes in Excel file by *.VBS script without Excel installed
- Changing Cell Text/Data
- Sheet Rename (day 2)
- Extracing Data from Unopened workbooks (DAY 2)
- How to work a year on year figure
- How to work a year on year figure
- CopyRecordset in ADO
- More efficient code advice needed
- How to attach an Excel spreadsheet to this forum for help
- Word Doc locked for ediiting
- Common dialog control
- Resize Range without Select
- Breaking up a string
- File not found - error
- could not get solverget working
- 3 Part Question About Sending E-mail
- Excel memory and speed when inserting pictures ???
- i need help!!!!!
- Building a better Mouse Trap
- changing sheet in window without activating it
- Protect File Saved
- Popup for cell change
- Autofit Column Headers with wrapped text (Not a merged cell issue)
- Font size (Excel-Autocad)
- openning Access via Excel
- Debug - last leg of project
- Excel VBA rounding / time handling questions
- date range for pivot
- location for add-in files
- select first empty cell in a range
- Position of MyBar
- Find negative value & Clear
- yield code
- a With missing and I don´t know where and how to put it
- How can I assign a macro to each name in a drop down list
- Controlling Acrobat From Excel
- Unmerge cells and place contents of first cell in all cells
- edit word doc
- Copying to another workbook
- Can I test dynamic array for empty?
- VB for "conditional" formatting when recalc occurs
- Controling recalculation - or how to solve my speed problem?
- Spin Button control change capture in ThisWorkbook Module
- .Seek
- How do I conditionally lock cells?
- Automation Error - Element Not Found
- 438 - Object doesn't support this property or method
- Message box for cell change
- Loop problem
- Printing a Word doc from Excel VBA code
- In Excel, how do I change Column Hdings to words not A, B?
- Find value (31.12.9999) and clear
- ListBox MultiSelectMulti mode
- VBA sort records occupying 2 rows each
- Find number of spaces in a string (instr)
- macro for clearing autofilter
- Random range averaging
- Last day of the month
- to: John Walkenbach - Face ID add-in
- Range Comparison
- Can a variable be used in a Worksheet().Activate method
- Printing Question
- Using a DO loop to add values into a textbox
- Save File
- open folder _open file code?
- VBAProject still visible after closing workbook
- printpreview
- Data Analysis Question
- monthly compound of yield
- Deleting Rows with Sum of "0" in 4 columns
- DATA VALIDATION - for data which is the result of a formula
- How to make a particula cell ACTIVE using C#
- Retrieving Names of Worksheets
- Userform assistance please
- change DAO code to ADO
- A value between 2 values
- cell ranges to userforms
- link cells in multiple worksheets same workbook with excel vba
- Conditional Formatting to HIghlight named ranges - error
- Colouring autoshapes mapped to cells in excel
- Tough Excel/Access/VBA Problem! Please Help!!!
- formatting a specific character or number in each cell within a rangeof cells
- Running a Script upon Saving a File
- Writing values to worksheet from array
- Web toolbar moves
- Oracle database login
- How do I calculate hours worked on 3rd shift?
- Userforms
- Bug in Excel 2000? (CurrentRegion property triggers events)
- Copy Cell from Row Above
- Extracing Data from Unopened workbooks
- Help with Formulas
- Naming a sheet
- excel programing error?
- auto filter
- Size Limit for ADO query?
- For Next Question
- Why do I receive OLE errors when saving an Excel file in VB?
- Looping Problem
- Delete columns not required
- IF or LOOKUP
- Forcing recacalculation
- VB or C#
- how to open xla file in automation way with disable macro
- Excel Time issue
- Draw a circle to select a desired collection
- Draw a circle to select a desired collection
- ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method
- Userforms
- VBA Dates help
- Evaluating Conditional Formats
- Convert a wokbook to shared mode
- Exporting excel cell contents to word document
- Macro works, identical Function doesn't....why?
- Make a Better Userform
- Calendar problem
- Drag and drop event
- Inputbox's and Prompt value
- A mixed request
- Function to calculate an average
- can you link a hyperlink to a macro?
- Dumb question of the day.
- Strange behavior of InStrRev() function
- Auto Sort
- Add to CmdButton
- Prevent / Disable Worksheet Copy or Move
- calling excell from an external program
- can pictures be inserted into comments
- Sorting records in Pivot page field
- Hide worksheets at startup
- Dynamically adding a macro to a new worksheet
- New Line in code to worksheet cell?
- adding rows across multiple worksheets within a single workbook
- Code needed big time!
- add and remove rows from a called range
- cell reference in C-API xll
- Do not email sheet if nothing on it.
- sumproduct question
- Collection Object, 255 item limitation
- Detecting if OLE object is displayed as an icon
- Running Excel module within Access
- UserForm-New one or Reuse Original?
- Push range against right screen edge
- Adding and using a calendar
- how to link excel cells across the internet?
- Return to Main Page
- Tab Order
- Values from a ListBox
- Set Focus on Cell D8
- Subtotals macro
- Test
- option button?
- Blocking Error 3021 No current record
- Test if the active cell contains a shape
- Array Code to Delete Worksheets
- replace in a string
- scroll
- parameters AddTextbox
- Problem using pivot tables in win forms
- Database access & querying
- Exclude one range from another
- Call other sub in the same module
- Pass string value to another form
- Re: Status Bar : Display both Sum and Count
- cell references
- return sheet name to cell.
- Tax calculation formula
- Hide/Unhide in Code; Protect, Unlock, etc.
- VBA Code To Import Historical Stock Quotes In Excel
- Getting Forms button caption
- Text File to Excel Cells
- Copying Data Another Try
- Sheet Checkboxes clear
- Question about querytable vs copyfromrecordset
- Loops are Great as long as they work
- Match cells by columns
- Help with messed-up code!!!
- Cater for unregistered DLL
- Status Bar : Display both Sum and Count
- VBA calculation question
- Date Stamp Save
- Create UserForm programmatically
- Getting information from a file
- Passing Procuedure to Userform
- Stop Execution
- how do I get: What number _____*11.2%=19.86 ??? Thank you!
- Forms
- Filtered List as Listbox RowSource
- Identifying Blank Excel Sheet through .NET code
- File dialog box
- Why this code works and other do not? Newbie here.
- Email from Excel with Outlook Express
- Excel app as child form in VB.Net
- create custom menu with addin connect/disconnect
- running excel macros on remote computer
- Trouble with Declaring Worksheets
- Select non-consecutive cells for deletion
- Userform
- If column width is 8.43, what should the row height be to make a square?
- Calling variable files
- selecting multiple sheets in a macro
- Creating an If/Then macro?
- Add to sheet
- The missing link
- Hide and Seek
- Picking up Date formats for use in Filenames, Etc.
- Excel <> HTML Web page - How ?
- How to reference a Class Module located in an add-in or another workbook?
- Sum Formula
- Saving ranges as GIFs
- Range problem
- 0.25
- Change reference style in line of code
- Worksheet_Change Not Detecting DDE Updates
- Checking dB for New Records Using DAO??
- Input box that ask for web address..
- Buttons click in Code
- Unable to set installed property of addin
- copy rows programmatically from one worksheet to another
- Autofilter protected sheet
- Formula Help with Lists
- input box that ask for...
- Opening Excel - File Error
- Trouble with Formula in Cell
- webquery-cookie problems
- VBA Excel: Problem w/ Loop
- Need help writing a printing macro
- How do I remove a non-toolbar custom button from a sheet?
- ComboBox Problems
- Copy Cell from Row Above
- Encryption of data in cells using AES 256
- Question - Repost
- Excel forms button "click"
- compile error: Expected: = ...Why?
- Forms
- PASSING VARIABLE TO .xlT FILE FROM .xlA FILE (CONTAINS 'Auto_Open' PROCEDURE)
- Is scripting the way to go here?
- Syntax of If statement in before print event
- Macro for copy Word into Excel
- prevent saveAs dialog
- Thanks a ton, Bernie!
- Password Protect Macro?
- Automating production book creation - many procedures to run
- Linking Multiple Cells $$Hire?
- Run macro but let user update spreadsheet while it runs
- List box ' VBA
- Hiding a Button
- error '438'
- Creating PDF Files
- SetFocus problem
- protect/unprotect worksheet
- Adding quotes around text, i.e. "text"
- How to make a multi-column label?
- Date Copy and column adjust macro
- Create new book..paste data..save..close
- How can I run my spreadsheet on someone else's computer?
- Macro add Hyperlink formula
- Importing excel values to word document
- Spreadsheet with multiple tabs, same headers
- error on second pass of loop
- Macro codes security
- Run-time Error '1004
- control formula with a macro?
- Class Module vs. Arrays
- Toolbars
- FOR Statement Issue
- Interact with Spreadsheet Model via the web.
- Arrays problem
- Printing Multiple Pages Based on Different Cell Criteria
- Subject: Excel VBA .Lookin Error 9/9/2005 7:14 AM PST
- Automatic top of sheet?
- Is it possible?
- Pass parametres from Excel to Access query
- Macro to clear combo box values
- Add value to conditionnal formatting
- ListBox value limit
- Reference Issue
- add column of numbers for each row
- can com port data be imported & sorted into cells?
- How to modify loan amortization template
- User select row?
- Time sheet with 52 tabs
- Fill Down
- Change year value in a date column...
- cell validation with list drop down by using a makro - Excel bug?
- Scan a Directory
- Dynamic pie chart color
- method 'open text' of object 'workbooks' failed
- List of all Macro's in Personal.xls
- how to open xla file in automation way with disable macro
- Resize Comments Box
- Run macro on cell edit
- crystal32.ocx
- restructure long to wide
- Automatically insert signature in worksheet
- Record a Macro through VBA
- Verifying Printer with Excel VBA
- check if file already is open
- Put MsgBox text in a worksheet for printing
- Return to Excel after shell an application
- Adding Objects to PrintDialog
- textbox trouble
- How to make a new function category?
- excel object in visual studio
- how do I create a macro in excel?
- Looking for Excel VBA gurus
- How can I remove all traces of XLM macros?
- Code to different object models
- Need a way to display a descrete number of rows from a list.
- Copy two sheets
- Adding and naming new worksheets
- Closing a external legacy program using VBA
- saving changes to addins
- HELP! - Can't Copy Cells With VBA
- I have no Idea how to do this in Macro.. or if it can even be done easily
- Like to put it in VBA please
- commandbutton_click problem
- combo box pupulating macro
- Include Excel Application Inside Winforms
- My Microsoft Office Excel 2003 disappeared
- Compare Multiple Numeric Values
- user-function not returning any result (newbye)
- Need formula - conditional formatting - ran out of conditions!
- Copying Data
- Need help writing Excel macro to solve a cell in each row of a spreadsheet
- Why isn't this macro giving me proper results?
- VBA Macro Versions
- Question about ExclusiveAccess
- Type of macro (Excel Version 4) that cannot be disabled?
- Automate a button click event
- Rounding currency
- What is causing "Block if without End if" error?
- how to replace drawing with text in that cell
- Insert Picture Macro
- Keeping excel visible
- Inputbox question
- Are 2 dates between today's date
- Macro hangs my excel (not responding)
- Is this possible?
- Problem with Workbook_BeforeClose event
- crash on second pass of loop
- Looping
- Why doesn't this code compile?
- use macro to hide or show bitmap image
- Confusion with security
- search and offset?
- Need loop help
- VB script to sum up amount
- Disable Sharing mode in VBA
- Tiering Macro, Should be easy?
- Macro / Custom View
- R1C1 Helper Instr / Mid
- Links Utility
- Delete Unwanted Macro1 Sheet
- On open, resize page
- Listbox and Collections (Again!)
- Passing Arrays in User Defined Objects
- Add Password Using Access
- Excel 2000 VB
- Deleting Cells
- Macro Security
- PivotTable Pivot Fields CurrentPage
- GetSaveasFileName
- Creating TWO-WAY E-Mail Attachments with 'BeforeSave Events' in Code for 2nd E-Mail
- Efficient Copy/Paste
- Application run help!
- Runtime 1004 Sort method of range
- SourceData for graph
- Extract data question
- return data to specific columns?
- Conditional Formating by truncated values....
- Help with VBA Password
- Finding the last nonblank cell in a column in VBA or VSTO
- If a formula is too long then refer to the cell after a TRUE resul
- Simpel commandbutton question
- error
- VBA fault finding
- XL - Oracle Connection error
- Greyed Out Graphs...
- Sort Question
- Removing column borders from an invoice
- Module name
- Function Call Specified at Run Time rather than Compile Time?
- Create Format documenr from Web With out Installing Excel in Serve
- C# open xla file with automation
- Please Help!!!!
- Selection
- InputBox
- Pls Help Me!
- Clear Clip Board Memory
- Comparing Text to Numeric Vals
- How to make chart embedded in active sheet?
- Print Button
- Deleting rows with VBA
- Capture Network Domain Name
- Run-Time Error 424 - Object Required
- 2 Things, CommandBars & Windows
- Possible to have sheet to convert roman numerals?
- Using Find/Replace in Visual basic to adapt the code
- Automatic saving of worksheet with unique names
- Horizonal Line Chart
- Application.wait... won't!
- Format of CSV File in export
- Any comments on TurboExcel?
- Using ADO to run an action query from excel
- To copy from a range in another sheet to the active cell
- Write " to a string
- Pagesetup. Is there no way to control the LeftMargin of the LeftHeader ?
- limitation in the path + filename length
- EXCEL VBA tutorials
- Data Retrieval
- CHECK BOX HELP NEEDED
- tranfering value if...
- Are macros interchangable between Excel and Access???
- Incrementing Rows in columns
- Hyperlink
- problems finding "~" in text
- Pivot Tables - counting instances of a number of words
- Automatically Create XY (Scatter) Charts
- VBA Array display problem
- Pivot Tables - updating drop down lists
- Excel fails to open workbook using Automation from VB 6
- Differentiating Cell Drag Copy
- Adding image
- How to delete all page breaks?
- Character Limit
- Question
- How to calculate # days between business days
- configuration files for excel add-ins
- Closing Excel Safely within a Web Environment
- Test for an empty selection
- Copy MTD info from YTD detail and paste to new tab Macro
- Formatting data in Msg
- Delete a selected area from a non-contiguous range
- Duplicates, Comparison and Condensing
- Fill ComboBox with File Names
- LOAD userform
- How to end when test condition met?
- Sumproduct & Array Formula?
- Activating workbook without naming it specifically
- worksheet looping with varying labels (aka Need to Find the John!)
- VB for conditional formatting more than 3 conditions
- Hide AND Exclude?
- Need Help: 'sheets' function with a variable in a formula
- Help
- "Outlook.Application" vs "Outlook.Application.11"
- Dynamically Add Combo Boxes
- I'm just starting to play around with VB and would like some help.
- Saving macros
- saving option
- Excel & VBScript
- Retrieving Data Problem
- Excel file as an executable?
- How to click the button from module?
- append file on e-mail
- Error Trap
- Inserting rows at variable points
- Help deffining public variables in userform1
- Macro help
- Formulas in Sheet
- Public Variable not maintaining value.
- Macro on Button needs syntax help
- Formulas for dates and static data
- Menu /toolbar question
- Sort by colour
- Error Code 6
- Macro execution time
- SetFocus testing
- vba code in Excel
- Copy text from Ms Access record to Excel text box
- sheetname search question
- CHECK BOX HELP NEEDED PLEASE
- Time displaying as decimal
- Problem opening excel file with VBA
- Help "438 - Object doesn't support this property or method"
- Compile an Excel 2003 Application with VBA 6.0 Code
- Compiling Excel 2003 application written in VBA 6.0 Code
- XML mapping programmatically
- test for field that just has spaces in it
- XLStart and VB
- create a pause in print macro to allow user to select printer
- Listbox columnhead
- set up a pause in a print macro for user input
- Sorting a column
- Shading Rows
- Range.FormulaArray drops relative reference ?
- VBA in Microsoft Excel: Find & Replace method macro across multiple files
- Iinsert value into column L ...
- Insert value into column L if...
- If Then Else
- If statements
- Working with files in directory...
- Command Bar Tools, Protection Protect & Share ID
- Simple Declaration Question
- Range Value ie: (A1:A100) The Option of?
- Runtime error 1004
- Excel Command Line Options
- R1C1 riddle
- IF function based on True result with large formula.
- Custom Menus in Chart Sheets
- Deleting an entry from a ini file
- Why can't i filter two different columns with different criterias like this
- Grrrr...Range on another sheet trouble...
- Trouble with Arrays / Collections
- Macro to copy internet page
- Class module question
- Show values only in a pivot table
- SaveAs Maceo - Specify Folder it Autoselects to Save In
- Allow disabling of password, but no setting of password
- Newbies and Menu Bars
- summarize
- don't want to have page breaks in union
- MsgBox To Read A Value of a cell
- How do i know the name of current view?
- AdvancedFilter on cells with formulas, returning values and not formulas
- Printing multiple ranges w/o page breaks between
- Wait less than a second
- Pass a variable into a range?
- separate text and digits within a cell
- Dealing with a Locked Cell
- How can I specify workday capacities in a dynamic calendar???
- Excel VBA Library
- Excel VBA Library
- Getting my VB custom functions to support usage within an Array Formula - How do I ge
- VBA for excel
- Selecting Columns
- Programmatically putting text in title without using labels
- Excel split window refresh problem
- How to remove and old Add-in from list of avaiable Add-ins
- Expressions in Microsoft Query
- incorrect Format Date mm/yyyy in excel 2003
- dynamic combobox
- Circular reference error
- USE MACRO TO SAVE WORKSHEET SELECTING FILENAME FROM CELLS
- Worksheet Protection
- spelling check on a protected spreadsheet
- Defining a Property
- search and extract within text
- problems with a userform
- Printing Selected Worksheets
- Activitate sheet 1 and make all sheets read-only
- RE: spelling check on a protected spreadsheet
- Row Color
- Save As selection in Active Sheet
- MSG Box - Stop Macro
- macro that opens a number of workbooks and close them
- Suppress Save Dialog Box
- RE: problems with a userform
- RE: macro that opens a number of workbooks and close them
- RE: Activitate sheet 1 and make all sheets read-only
- RE: problems with a userform
- Sorting with a list
- how do i set up a Cobol Comp-3 data field in Excel?
- RE: MSG Box - Stop Macro
- Mesage based on table
- List of File Saved
- How can I delete multiple sheets in VBA...
- Command Button Freezes on Reopen
- Separating a string to two fields
- Using workbooks
- Auto Open sheet function
- Simple constraint problem...
- Modify a Worksheet
- basic
- Function Key F5 - go to reference
- unique filenames in macros
- Stumped - What am I doing wrong?
- Working with an array
- Application.WorksheetFunction.Match
- Log uses of Excel
- Please help with Macro
- Excel 4 macro conversions
- Exclude some worksheets when using UsrSht function
- Shade cells with links to external workbooks
- colouring cells that are between two dates
- copying value into alphanumeric table
- Trying to revive this question... Help :)
- Combo box
- Input Box Help - Validate Date Format
- Time Help
- Update and Add
- Excel VBA Need to rotate players - find / copy last 3 rows and move to the top
- Can Anyone Explain This?
- Question about intervals and results
- Problems with a formulas
- Tough Excel/Access/Windows Problem, need Help!!!
- Copy and Past to Differerent Work Sheet
- Keyboard shortcut to auto insert $ sign into formula?
- Macro Help - Deleting two characters per line!
- More combobox questions
- Print Sheet Array from List Box
- OLE or Automation Printing of Excel
- Beginner needs help, Look inside!
- Empty Date
- Module name change
- Run-time error’-2147417848 (8001
- Macro help...
- Easier way to insert columns
- Running VBA Code not written within the currrent worksheet
- save as latest excel format
- Excel and VBA how to call a procedure from an excel "cell"
- Formula
- Excel Filldown problem
- Last record in collumn.
- Distributed Addins
- Control Not Licensed Error
- Conditional formating
- Autorun a macro
- Return Information from Shell Command
- Toolbars: Hide now, display later
- Need help with Add-ins!
- How can i combine combo boxes
- Sumproduct.....
- How To Create a Document in Excel from a Template, Using a Macro
- need macro\method that would allow user input to a data filter
- Using VBA Functions in a worksheet
- Using a macro to delete all blank rows
- two space rounding
- Range.Insert query
- Macro To Create Hyperlink from html text
- Excel Userforms Textbox query
- Add a tamplate sheet automaticly when I have copy in a new sheet
- Select specic no. of rows down
- Generating inserts out of 1.5 million records CSV file
- Excel 2003 changes protection when saving
- Data validation with several fields
- CubeField Member Properties for Excel 2k?
- Value or formula in cell depending on input...
- UserForm PrintPreview & Print buttons
- Save file as sequential
- find first data entry in range
- automatically copy selected data from one excel to other excel
- Sheet scroll based on variable
- re : Possible ???? Pls help
- Create mirror workbook???
- VLOOKUP 2 CELLS
- Save Worksheet as Text File
- Fix or touch up heading so that it could be imported by Access97
- Sight Unseen
- Print all pages in a Multi page userform
- Parent Folder
- Copy outside Clipboard contents (html page) to a cell in Excel
- Formating X Axis on Chart using VBA
- Enable grouping in protected worksheet
- How to run a private sub in the workbook from another workbook
- partial derivative of a function
- Make date show
- Range names
- Names of Grouped Shapes
- Generate auto increment number from VB form
- form.show switches to debug mode
- VBE causes excel and word to crash when closed
- Tips for copying picture?
- Insert right pointing triangle
- Know exact position of a cell in the Sheet
- Option button help
- There has got to be away!?
- Inserting value with increment by 1 from previous value
- Error Handlers
- I want to verify data in 2 different worksheets
- I need to verify data from 2 different worksheets how do i do it
- Export Linkedcell
- File encoding problem
- multi text search question
- To Multiple Excel Files
- my first attempt at R1C1 in vba
- If, or on 3 conditions
- Files and Folders check
- Import data from two workbooks with similar names
- Remove Autofilter
- Protecting worksheet-Unable to view comments
- Telephone number data type?
- closing userform automatically
- Protecting worksheet-Unable to view comments and use a filter
- Using a Macro to delete all rows containing #N/A
- Using a Macro to perform a VLookup on varying number of rows
- Animated selection border
- Disable Tools, Protect, Protect Workbook
- access specific areas of a protected worksheet
- Option Buttons/Refresh
- Capture a cancel button
- rounding error
- v-lookup error
- DLL Entry Points
- Repeat Title Formatting With Macro
- Scanning objects
- Error: Out of memory
- how to keep focus on txt_box in userform
- Can anyone recommend a good free online excel
- Copy and paste between workbooks?
- error message: compile error, argument not optional
- I NEED A FUNCTION TO FIND IF THERE IS AN INTERSECTION BETWEEN 2 DATE RANGES
- userinput is wrong (check in vba)
- VBA Code works in Excel 2003 but won't work in Excel 2000
- How do I make a ComboBox use a list from another sheet in Excel?
vBulletin® v3.6.4, Copyright ©2000-2024, Jelsoft Enterprises Ltd.